## 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. If your input nonsense data, you will also get a nonsense output. So, to get more accurate results, you should minimize the errors in your data. Error in data entry is one such … Read more

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

## 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 your cryptocurrency purchases. And also, you can view a summary of your total assets with the Dollar Cost Average (DCA) for each cryptocurrency. In addition to that, you can get the present value … 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

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

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

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 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 embed Google Apps Script Web Apps in Websites. In this post, I am not going to show how to build Webs Apps. I will show you how to embed an already made Web … Read more

## 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 Tables in Google Sheets

This post will show you how to create tables in Google Sheets to manage your data easily. In Microsoft Excel, the table feature allows you to manage and analyze related data easier. It has so many advantages over managing your data without a table. However, at the time of writing this post, Google Sheets does … Read more