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
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
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
A checklist is a list of things that can be checked off individually when completed or noted. In a checklist, there is a checkbox for each list item that you can check or uncheck. This post will show you how to make a checklist in Google Docs. You may also be interested in How to … Read more
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
In this post, I will show you how you can completely remove image background for free. And I will also show you how to remove an object from an image easily. For this I am going to use is Microsoft Paint 3D. Microsoft Paint 3D comes with Windows 10 for free. With Paint 3D, you … Read more
When you share a Google Sheet with others, they will have access to all individual sheets in the Spreadsheet. At present, there is no direct option to share a single sheet in Google Sheets. However, using the following method, you can share data in a single sheet or selected few sheets without giving access 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
In the previous tutorials, we talked about importing data from another sheet in the same spreadsheet and from other spreadsheets to Google Sheets. In this tutorial, let’s focus on importing CSV into Google Sheets. You can import TSV files also using the methods described below. In addition to that, I will show you how to … Read more
