Google Sheets Tips & Tutorials

• Leave Tracker Template in Google Sheets (Updated for 2019)
• Sparkline in Google Sheets – The Only Guide You Need
• Show / Hide Gridlines in Google Sheets (in less than 5 seconds)
• How to Insert Timestamp in Google Sheets
• How to Insert Checkbox in Google Sheets (with Examples)
• 101 Google Sheets Keyboard Shortcuts
• 10 Google Sheets Tips that’ll Help You Get Work Done Faster
• How to Insert Spin Button in Google Sheets (+1 Increment Buttons)
• How to Copy a Sheet from One Google Sheets to Another
• 4 Steps for Quick and Easy Data Analysis with Google Sheets
• How to Create and Use Filter Views in Google Sheets
• How to Create a Table of Contents in Google Sheets
• Google Sheets Weekday Function – Explained with Examples
• How to Get the Last Monday of the Month in Google Sheets
• Calculate Age in Google Sheets (using the Date of Birth)
• How to Create Hyperlinks in Google Sheets (Step-by-Step Guide)
• Using FILTER Function in Google Sheets (explained with Examples)
• How to Search in Google Sheets and Highlight the Matching Data
• How to Use OR Function in Google Sheets (with Examples)
• How to Use IMPORTRANGE Function in Google Sheets (with Examples)
• How to Use IMPORTDATA function in Google Sheets
• Calculate the Number of Days Between Two Dates in Google Sheets
• Using IFS Function in Google Sheets to Test Multiple Conditions
• How to Quickly Freeze / Lock Rows in Google Sheets
• Using IFERROR Function in Google Sheets (with Examples)
• How to Create a Drop Down List in Google Sheets
• Using IMPORTFEED in Google Sheets to Fetch Feed from URL
• Using Query Function in Google Sheets – Examples
• Concatenate in Google Sheets – Combine Cells Using Formula
• How to Zoom In and Zoom Out in Google Sheets
• How to Quickly Transpose Data in Google Sheets
• How to Fill Down in Google Sheets Using Fill Handle
• Calendar Template in Google Sheets (Monthly and Yearly)
• The Ultimate Guide to Google Sheets VLOOKUP Function (with Examples)
• How to Create Named Ranges in Google Sheets (Static & Dynamic)
• How to Quickly Insert Multiple Rows in Google Sheets
• How to Rotate Text in Google Sheets (in less than 5 seconds)
• How to Count Cells If Not Blank in Google Sheets
• Conditional Formatting Based on Another Cell Value in Google Sheets
• Creating a Heat Map in Google Sheets (Step-by-Step Tutorial)
• How to Split Text to Columns in Google Sheets (with Examples)
• How to Convert Excel to Google Sheets (a Step-by-Step Tutorial)
• How to Create a Dependent Drop Down List in Google Sheets
• How to Insert an Image in a Cell in Google Sheets
• How to Use COUNTIF Function in Google Sheets
• How to Quickly Merge Cells in Google Sheets
• The Ultimate Guide to Using Conditional Formatting in Google Sheets
• How to Use Spell Check in Google Sheets to Find Misspelled Words
• Using IF Function in Google Sheets (with Examples)
• How to Protect a Range of Cells in Google Sheets
• How to Sort Data in Google Sheets
• How to Wrap Text in Google Sheets
• How to Quickly Split Text in Google Sheets
• How to Insert Bullets in Google Sheets
• How to Count the Number of Words in Google Sheets
• How to Remove Duplicates in Google Sheets
• How to Color Alternate Rows in Google Sheets