Spreadsheet Class

Free Google Sheets Cheat Sheet (Formulas & Quick Reference)

Welcome to the free Google Sheets cheat sheet! This free cheat sheet contains the most useful formulas and shortcuts in Google Sheets. I am sharing this in hopes that it will make life easier… and also to show you a wide variety of very useful formulas that you can have […]

Read More

Recent Posts

Featured image for the Google Sheets Skills Test (Project Request)

Google Sheets Skills Test (Can you complete these projects?)

Continue Reading

Featured image for the lesson on how to insert a new line in a cell in Google Sheets (Plus new line in formula and automatic line breaks, including how to remove line breaks and how to replace characters with line breaks

Insert a new line in cells / formulas in Google Sheets (+ Automatic line break formulas)

Continue Reading

Featured image for the lesson on how to freeze and unfreeze rows and columns in Google Sheets

2 ways to freeze rows & columns (& How to unfreeze) in Google Sheets

Continue Reading

Featured image for the lesson on how to average in Google Sheets multiple method- lesson by SpreadsheetClass.com- (AVERAGE function and mathematical method)

How to average in Google Sheets (AVERAGE function + mathematical method)

Continue Reading

$Featured image for the lesson on how to add and sum in Google Sheets by using math or the SUM function (multiple methods)$

How to add and sum in Google Sheets (Addition and SUM function)

Continue Reading

Featured image for the lesson on how to pull stock prices and other stock data with the GOOGLEFINANCE function in Google Sheets with bonus example on how to pull crypto prices

Pulling stock & crypto data with the GOOGLEFINANCE function in Google Sheets

Continue Reading

Featured image for the lesson on how to indent in Google Sheets

5 ways to indent in Google Sheets

Continue Reading

Featured image for the lesson on how to create drop-down lists and use data validation in Google Sheets

How to create a drop-down list in Google Sheets (Data validation)

Continue Reading

A featured image created for the lesson on how to build a dashboard in Google Sheets (Simple and fast version)

Fast & Simple dashboard tutorial in Google Sheets (Build in under 15 minutes)

Continue Reading

Featured image for the lesson on pulling crypto prices in Google Sheets

Pulling cryptocurrency prices into Google Sheets (3 Methods)

Continue Reading

Featured image for the lesson on using the IMPORTXML function in Google Sheets to pull data from websites and web scrape

Pull data from websites in Google Sheets with IMPORTXML (Web scraping)

Continue Reading

Featured image for the lesson on building a Google Sheets dashboard in 3 steps

Build a Google Sheets dashboard in 3 simple steps

Continue Reading