How to import data from website to Google Sheets
We use data from various sources for our data analysis works. In previous posts, we discussed how to import data from one …
How to apply formula to entire column in Google Sheets
You can drag down the fill handle to autofill formulas. However, it is not efficient to use the fill handle when you …
How to use Google Sheets to Manage Data Entry Works
“Garbage in, garbage out” is a common saying in the computer world to describe how important the quality of the data is. …
How to compare two columns in Google Sheets
When working with data, you may come across situations where you need to compare two or more datasets. For example, you may …
Create A Crypto Portfolio Tracker in Google Sheets
This post will show you how to create a Crypto Portfolio Tracker in Google Sheets. With this Google Sheet, you can track …
Upload files to Google Drive with Google Apps Script Web Apps
We have created a number of Google Apps Script Web Apps that can be used for data collection purposes in our previous …
How to Generate a Data Entry form in Excel
Using the “Form” command, you can easily generate a data entry form in Excel. Data entry forms provide a convenient means to …
Excel Named Range – Make Your Work Easier!
We identify each cell in the spreadsheet by a combination of its column letter and row number. A range of cells is …
The Ultimate Guide to Handle Duplicates in Excel
This post will show you how to handle duplicate entries or, in other words, repeated data in your data set in Microsoft …
How to Embed Google Apps Script Web Apps in Websites
In previous tutorials, we created some Web Apps with Google Apps Script and Google Sheets. This post will show you how to …
