Google Sheets Tips & Tutorials

• How to Add Live Stock Prices in Google Sheets (Free Template)
• How to Track Changes in Google Sheets
• How To Password Protect Google Sheets
• How to Sum Cell Values Between Two Dates in Google Sheets
• How to Make a Dot Plot in Google Sheets (Step by Step Guide)
• Google Sheets MEDIAN: How to Find Median in Google Sheets
• Free Google Sheets Attendance Template (Easy to Use)
• How to Add Labels to Legend in Google Sheets (Step-by-Step)
• How to Hide Columns from Certain Users in Google Sheets
• How to Use Index Match in Google Sheets (Step-by-Step Guide)
• How to Add Days to Date in Google Sheets
• How to Use REGEXEXTRACT Google Sheets Function
• What-If Analysis in Google Sheets Using Goal Seek
• How to Use REGEXREPLACE Function in Google Sheets
• How to Get Running Totals in Google Sheets (Easy Formula)
• Creating Candlestick Chart in Google Sheets (Step-by-step)
• How to Use the INDEX function in Google Sheets (Examples)
• Using Wildcards in Google Sheets (4 Examples)
• How to Combine Formula and Text in Google Sheets
• How to Convert PDF to Google Sheets
• How to Convert Text to Date in Google Sheets
• How to Convert Formula to Value in Google Sheets
• How to Use Slicer in Pivot Tables in Google Sheets
• How to Group Columns in Google Sheets
• How to Convert Time to Decimal in Google Sheets
• Comparison Operators in Google Sheets (A Complete Guide)
• Formula Parse Error in Google Sheets (& How to Fix it)
• How to Add & Use Calculated Fields in Google Sheets Pivot Tables
• How to Group by Month in Pivot Table in Google Sheets
• How to Refresh Pivot Table in Google Sheets
• How to Delete Every Other Row in Google Sheets (Easy Formula Trick)
• How to Make a Bell Curve in Google Sheets?
• How to Import and Open CSV File in Google Sheets?
• How to Convert Time to Military Time Format in Google Sheets?
• How to Use SWITCH function in Google Sheets?
• How to Round Numbers in Google Sheets? (ROUNDUP/ROUNDDOWN)
• How to Print Labels from Google Sheets (For Free)?
• How To Calculate Weighted Average In Google Sheets (Weighted Average Formula)
• How to Make a Scatter Plot in Google Sheets (Step-by-Step)
• How to VLOOKUP Multiple Columns in Google Sheets?
• How To Format Phone Numbers In Google Sheets?
• How To Recover Deleted Google Sheets Files
• How To Move A Column In Google Sheets
• How to Set Print Area in Google Sheets
• How to Unhide Rows in Google Sheets (4 Easy Methods)
• How to Show Formulas Instead of Values in Google Sheets
• Format Painter in Google Sheets (Copy formatting easily)
• How to Highlight Duplicates In Google Sheets (Easy Steps)
• How to Strikethrough in Google Sheets (3 Easy Ways + Shortcut)
• How to VLOOKUP from Another Sheet in Google Sheets
• How to Convert Text to Numbers In Google Sheets
• How to Compare Two Columns in Google Sheets (for matches & differences)
• How to Make a Histogram in Google Sheets (Step-by-Step)
• How to Make a Line Chart in Google Sheets (Step-by-Step)
• How to Sort by Color in Google Sheets
• How to Make a Pie Chart in Google Sheets (Step-by-Step)
• How to Automatically Send Emails from Google Sheets (Using Appscript)
• How to Insert a Pivot Table in Google Sheets (Step-by-Step)
• Capitalize First Letters in Google Sheets (Easy Formula)
• Remove Last Character from a String in Google Sheets (or Last N Characters)
• Leave Tracker Template in Google Sheets (Updated for 2021)
• Sparkline in Google Sheets – The Only Guide You Need
• How to Show / Hide Gridlines in Google Sheets
• 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 Lock Cells in Google Sheets (Protect a Range)
• 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