A spreadsheet is a computer application for organization, analysis, and storage of data in tabular form. Under this category, you will learn tips and tricks for using various types of spreadsheet applications. Mainly we will be discussing spreadsheets applications such as Microsoft Excel and Google Sheets.
Most of our day-to-day databases include geographic data such as country, region, city, address, latitude-Longitude, place names, etc. Many of you are used to storing these data on spreadsheets applications like Google Sheets, Microsoft Excel, etc… If you can link these databases to a map, you can see the changes to your data in real-time … 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
When you are working with databases, you know there are thousands or millions of records in a spreadsheet or your database. These data don’t sense anything when it is in that format. However, if you can represent these data in a graphical form, it is easier to visualize and understand trends, outliers, and patterns in … Read more
There are many Project Management Tools available in the market. Many of them have cloud versions that you can access with a monthly subscription. If those subscription plans are not affordable to your project, this article is for you. In this post, I will show you how you can use Google Sheets for project management. … Read more
In a previous post, I explained how to create a simple dependent dropdown list in Google Sheets. However, using that method you cannot copy the dependent dropdown list into multiple rows. As such, in this tutorial, I will show you how you can create a dependent dropdown list in Google Sheets and copy it into … Read more
Are you planning to take a loan? If so, what is your monthly payment would be? Will you be able to afford that payment? What is the best repayment period for you? You can easily find answers to these questions by performing a few easy calculations on spreadsheets. In this post, I will show you … Read more
Data entry is one of the important steps in the data analysis process. It is important that the data collected is correctly entered into the electronic format. A good data entry form can reduce the number of human errors added during the data entry. A correctly designed data entry form can speed up data entry … Read more
When it comes to mass data entry works, it is essential to use data entry forms to improve accuracy and speed. This tutorial will show you how to create a data entry form in Google Sheets. With Google Sheets, it has many advantages over data entry forms like MS Access installed on your local computer. … Read more
Dependent dropdown lists are a type of dropdown list where the options available in the list depend on the value selected in another dropdown list. This type of dropdown list is useful when you design data entry forms or create dashboards with options to automatically change their content based on the user’s selection. Using dependent … 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
