Microsoft Word is one of the most popular tools for creating reports and documents. Whether you are a student, professional or anyone who does documentation works, proficiency in Microsoft Word is a skill that is necessary for today’s digital age. In this post, I am going to guide you in creating a professional looking Microsoft word … Read more
When it comes to mass data entry works, it is very essential to use data entry forms in order to improve accuracy and speed. If you use google sheets there are are many advantages compared to stand alone data entry forms like in MS Access. The default form option comes with the Google sheet (Google … Read more
Portable Document Format (PDF) is a file format used to present and exchange documents reliably, independent of software, hardware, or operating system. Invented by Adobe, PDF is now an open standard maintained by the International Organization for Standardization (ISO). PDFs can contain links and buttons, form fields, audio, video, and business logic. They can also … Read more
The drop-down lists are useful when you are creating data entry forms or creating interactive dashboards to present your data. While creating drop-down lists, you may come across situations where one drop-down list need to be populated dynamically as the value of the other drop-down changed. In other words, needs to create dependent drop-down lists. … Read more
The size of the images that can be printed/ captured from Google Map is limited to the dimensions of the browser window. In my previous post “How to capture, print a large Google map – larger than the screen” I explained to you how you can save large images. However, the size of the images … Read more
In the previous post, I have shown you how you can create your own map using Google My Maps. In that map, I developed a data table for that particual layer while creating the map. Sometimes you may need to export this data table to spreadsheets to use for other purposes. At present, Google My … Read more
You can create your own maps by adding a number of other layers on top of the Google Map using the Google My Maps feature. In this post, I will show you how easily you can create your own maps using Google My Maps. First of all you need to be logged into Your Google … Read more
With Google sheet app script, (similar to MS Excel VBA) you can extend the functionalities of the Google Sheet. In addition to that, you can automate some tasks using Triggers. In this post, I’m using Time-driven-triggers to automatically run an app script to get Google Map direction data to Google Sheet. How to get Google … Read more
Sometimes you may need to customize automatic chapter numbering and add some words as a prefix to the numbers. For example, you may need to change “1. Introduction” to “Chapter 1: Introduction“. Here is how to do it in a few easy steps. Here I assume that you have already formatted your headings and generated the … Read more
Google Drive is a great cloud storage service which provides you with a 15 GB cloud storage free of charge. It is one of the most used cloud storage services and associated with every Google account you are creating. Besides the cloud space, it also provides a plenty of application for free of charge. These cloud-based … Read more
Are you a daily commuter who spent hours on the road? It is easy to think that the time you spent commuting as a total waste. However, it doesn’t have to be. With some strategic planning, you can be more productive while commuting. Here are some productive tips that you can do while commuting. 01. … Read more