We use data from various sources for our data analysis works. In previous posts, we discussed how to import data from one Google Sheets to another, one sheet (tab) to another sheet(tab), and Import CSV files to Google Sheets. In this post, I will show you several methods to import data from website to Google … Read more
You can drag down the fill handle to autofill formulas. However, it is not efficient to use the fill handle when you are working with a large data set. And also, you need to drag down the fill handle every time you add new data (rows) to your dataset. This post will show you how … Read more
We identify each cell in the spreadsheet by a combination of its column letter and row number. A range of cells is defined using the upper Left cell and the lower Right cell. We call this A1 notation. But writing a complex formula using A1 notation is a bit difficult to understand and maintain. You … Read more
This post will show you how to handle duplicate entries or, in other words, repeated data in your data set in Microsoft Excel. There are many ways to handle duplicates in Excel. Sometimes you may have to remove duplicates. Sometimes you may have to work with the dataset while keeping the duplicates as it is. … Read more
You can create a button in Google Sheets to run Apps Script from its user interface. The button is essential when you design Google Sheets for others who do not know App Scripts. This post will show you how you can create a button in Google Sheets and attach the Google Apps Script function to … Read more
Google Sheets Checkbox is an interactive element that allows the user to make a binary choice. With this option, you can convert a cell to a check box. By default, the checkbox is unchecked, and the value is FALSE. You can click the cell to change the state. When the checkbox is checked, the cell … Read more
Online data entry forms are a powerful tool that you can use to collect many types of data more easily and accurately. Google Sheets is the most powerful cloud-based spreadsheet application that you can use absolutely free. Google is also offering another free tool named Google Apps Script (GAS) to increase the power of your … Read more
Microsoft Excel is a powerful spreadsheet program that is used by a lot of people in their daily lives. When working with this tool, you may have found there are many ways to perform the same action. Some of these methods help you to perform a task faster than others. Such methods can significantly improve … Read more
Keyboard shortcuts are designed to access routing functions more quickly and easily. When you are working with computer applications, you will see that several shortcuts are common to many of the applications. Knowing these common keyboard shortcuts will assist you in working with any application easier. This post is an attempt to summarize the top … Read more
Google is the most popular search engine in the world. However, did you know that there are special characters and words that you can include in your search to get even better results? Try following 10 google search tricks and tips on your next google search to get more accurate results. 01. Use quotes (“”) … Read more
