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.
When you are working with analysis works, it is a good practice to keep your row data in separate sheets. And you …
Read moreImport Data in Google Sheets #1 Import Data from another Sheet in the same Spreadsheet
There are a number of ways for creating forms in Google Sheets. The most popular and easiest method is to use Google …
Read moreCreating Forms in Google Sheets – Sidebar & Modal Dialog forms
Most of our day to day databases include geographic data such as country, region, city, address, latitude-Longitude, place names, etc… Many of …
Online data entry forms are a very powerful tool that you can use to collect many types of data more easily and …
Read moreHow to Create an Online Data Entry Form that can Perform CRUD Operations on Google Sheets
When you are working with databases, you know there are thousands or millions of records in a spreadsheet or your database. These …
Read moreHow to Create an Online Dashboard for free to Share and Visualize Your Data
There are many Project Management Tools available in the market. Many of them have cloud versions that you can access with a …
In a previous post, I showed you “How to Create a Dependent Dropdown List in Google Sheets“. However, you can only apply …
Read moreHow to Create a Dependent Dropdown List in Google Sheets and apply to Multiple Rows
Are you planning to take a loan? If so, what is your monthly payment would be? Will you be able to afford …
Read moreHow to Calculate Loan Repayments with Google Sheets
Data entry is one of the important steps in the data analysis process. It is important that the data collected is correctly …
Read moreHow to Create Data Entry Form with Google HTML Service and Submit Data to Google Sheets
When it comes to mass data entry works, it is very essential to use data entry forms in order to improve accuracy …