How to generate static Google Maps in Google Sheets

How to generate static Google Maps in Google Sheets

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

How to Create a Crypto News Feed in Google Sheets

How to Create a Crypto News Feed in Google Sheets

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

How to import data from website to Google Sheets

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 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

Excel Named Range – Make Your Work Easier!

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 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

The Ultimate Guide to Handle Duplicates in Excel

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 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

How to Create a Button in Google Sheets to Run Scripts

How to Create a Button in Google Sheets to run Scripts

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

How to Create an Online Data Entry Form that can Perform CRUD Operations on Google Sheets

How to Create an Online Data Entry Form that can Perform CRUD Operations on Google Sheets

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