Home Google Docs

Google Docs

Best Google Docs (Sheets, Forms, and Docs) Tips and Tricks.

How to Format Date, Time, and Number in Google Sheets Query

How to Format Date, Time, and Number in Google Sheets Query

18
By using the Format clause, the last clause in the Query clause order, we can format date, time, and number column in Google Sheets...
Custom Heat Map in Google Sheets for Age Analysis

Custom Heat Map in Google Sheets for Age Analysis

0
Heat Maps in Google Sheets are the visualization of data using a color scale based on the values. It has nothing to do with...
flexible way of using named ranges in Google Sheets

Auto-Expand Named Ranges in Google Sheets to Accommodate New Rows

11
The sole purpose of using Named Ranges are creating clean looking formulas. But it won't help you in an ever-expanding data rage unless you...
AMORLINC Formula for Creating Depreciation Charts in Google Sheets

How to Use the AMORLINC Function in Google Sheets

0
The AMORLINC function in Google Sheets calculates depreciation for a period using linear depreciation, as defined in the French accounting system. In this Google Sheets...
Sheets-New-Feature-14-5-19

Removing Duplicates Using Data Clean-up Menu in Google Sheets

0
Say goodbye to duplicate rows in your dataset! A built-in Remove Duplicates menu option (command) is available in Google Sheets. You can check the Data menu in...
How to Return an Entire Column in Hlookup in Google Sheets

How to Return an Entire Column in Hlookup in Google Sheets

1
In your horizontal dataset, you may want to use Hlookup to return an entire column's content. Is it possible? Yes! It is possible in...