How to import data from one Google Sheet to another
In the previous tutorial, we discussed how to import data from another Sheet in the same Google Spreadsheet. This tutorial will show …
Spreadsheets
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.
How to import data from one Sheet to another in Google Sheets
It is easy to do your analysis when your raw/ source data is in a separate Sheet. Because it makes your analysis …
Creating Forms in Google Sheets – Sidebar & Modal Dialog forms
There are several ways to create forms in Google Sheets. The most popular and easiest method is to use Google Forms. However, …
How to link Google Sheets to Google Maps and create interactive maps
Most of our day to day databases include geographic data such as country, region, city, address, latitude-Longitude, place names, etc. Many of …
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. …
Create Stunning Free Online Dashboard for your Data
When you are working with databases, you know there are thousands or millions of records in a spreadsheet or your database. These …
How to use Google Sheets for Project Management
There are many Project Management Tools available in the market. Many of them have cloud versions that you can access with a …
Multi-Row Dependent Dropdown List in Google Sheets
In a previous post, I explained how to create a simple dependent dropdown list in Google Sheets. However, using that method you …
How to Calculate Loan Repayments with Google Sheets
Are you planning to take a loan? If so, what is your monthly payment would be? Will you be able to afford …
How to Create Data Entry Form with Google HTML Service and Submit Data to Google Sheets
Data entry is one of the important steps in the data analysis process. It is important that the data collected is correctly …
