Nowadays, we have access to an abundance of data that can aid us in decision-making. Website data is a particularly accessible and cost-effective source, provided that we utilize appropriate data collection techniques and tools. Google Sheets is one such tool that can be used for free. In this article, I will demonstrate how you can … Read more
In this blog, we have discussed several methods that you can use to create Google Maps from Google Sheets data. In this post, let’s see how we can generate Google Maps in Google Sheets. In this post, I am going to use Google Apps Script to create the map image inside the Google Sheets. You … Read more
Cryptocurrency prices are susceptible to news information. Therefore, getting the right news around the crypto world is particularly important for crypto traders. However, it is not possible for you to find and read all such news as soon as they are published. As such, it is more beneficial to create your own news feed that … Read more
Identifying and removing or identifying duplicates is one of the essential steps in data cleaning. Duplicates can happen in your data set for many reasons like the nature of the data collection method, data entry errors, etc… This post will show you how to find duplicates in Google Sheets and remove them. You may also … Read more
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
You can use section breaks to divide a Microsoft Word document into separate sections and change the layout or apply different formatting to each section. Mainly there are four types of section breaks (Next Page, Continuous, Even Page, Odd Page) in Microsoft Word. For some reason, you may need to remove all or some of … Read more
When working with data, you may come across situations where you need to compare two or more datasets. For example, you may need to compare two different versions of the same data set. In such situations, we can compare the data sets using individual columns or column combinations. This post will show you how to … Read more
We have created a number of Google Apps Script Web Apps that can be used for data collection purposes in our previous blog posts. We included several types of form controls in those web apps, such as text fields, dropdowns, radio buttons, etc… This blog post will show you how to create a web app … Read more
Using the “Form” command, you can easily generate a data entry form in Excel. Data entry forms provide a convenient means to insert, view, update, or delete data. This post will show you how to generate Excel data entry forms and why and when to use them. Note: The examples in this post have been … Read more