How to Use CHOOSE Function in Google Sheets [Purpose and Examples]

In Google Sheets, the CHOOSE Function is not much common in use. Many compare it with other Google Sheets functions like Switch as well...

Convert Date to String Using the Long-winded Approach in Google Sheets

Today I was just about to write a Google Sheet Query function but I soon realised I should first write few other Google sheet...

How to Use Date Criteria in Query Function in Google Sheets...

Using date as criteria is the complicated part of any criteria formation in Google Sheet functions. Most of the case you can not use...

How to Create 3D Pie Chart in Google Sheets – With...

Pie Chart is one of the visually appealing chart among all other chart types with its filled colours. It's a must to spice up...

Auto Serial Numbering in Google Sheets with Row Function

Multiple Ways of Serial Numbering in Google Sheets As you know, a standard format starts with serial number. To more precise it will be like...

Offset Function Examples in Google Sheets and Dynamic Ranges

In this Google Sheets tutorial I will explain you how to use Google Sheets Offset Function with the help of some Offset Function Examples. The...

Create Unit Calculator Using Google Doc Spreadsheet

We can create unit calculator using Google Doc spreadsheet for our day to day spreadsheet purposes. It can ease our job. You can create...

Find and Eliminate Duplicates Using Query Formula in Google Sheets

Learn how to find and eliminate duplicates using Query formula in Google Sheets. I've already shared few awesome tips to find and eliminate duplicates...

How to Compare Two Sheets in Google Sheets for Mismatch

May be you have sufficient reasons to compare two sheets in Google Sheets for mismatch. Whatever it may be, you can easily do it....

Alternative to Excel Formula Auditing in Google Sheets

Once I extensively used keyboard shortcuts in Excel 2003 as it could speed up my job. Now I'm not a regular user of Excel...

Inspirational - Random Posts

15 Highly Inspiring Quotes from Famous Painters to Motivate You

Below you can find selected 15 highly inspiring quotes from famous painters like Vincent van Gogh, Leonardo da Vinci, Raja Ravi Varma, Claude Monet, Pablo Picasso etc. Don't be...

Google Sheets - Random Tutorials

How to Hide Tabs from Specific People in Google Sheets

Hiding sheet tabs is not new in Google Sheets. It's available. You can hide tabs from specific people in Google Sheets. But it depends...