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
The size of the images that can be printed/ captured from Google Maps is limited to the browser window’s dimensions. Therefore, sometimes you may come across situations where you need stitching Google Map images to make large high-resolution Google Maps. Such situations are maybe for printing purposes or any other offline uses. In my previous … Read more
When creating a Google My Map, the system automatically generates a data table for each layer. You can add rows or columns to this table as you develop the map. When you create a layer by importing data from a spreadsheet, the data in the spreadsheet is saved in the data table of that layer. … Read more
You can create your own maps by adding several other layers on top of the Google Map using the Google My Maps feature. Once you create your custom maps, you can share it with your team or anyone. You can view it on any device. In this post, I will show you how easily you … Read more
Using the DirectionFinder class of Google Apps script, you get directions between locations from Google Maps. This class returns several details, including travel time and distance between the given two locations. In this tutorial, I will show you how to get Google Map Travel Tim and Distance to Google Sheets automatically using Google Apps Script. … Read more
Google Drive is a great cloud storage service that provides you with 15 GB of cloud storage free. It is one of the most used cloud storage services and is associated with every Google account. Besides the cloud space, it also provides plenty of applications for free. In this post, I will show you how … 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
Google is the most popular search engine in the world. However, did you know that there are special characters and words that you can include in your search to get even better results? Try following 10 google search tricks and tips on your next google search to get more accurate results. 01. Use quotes (“”) … Read more
