Learn

Use this page to learn spreadsheet skills and apply them to real-life scenarios.

Google Sheets

Edit & format a spreadsheet

The Secret Behind Making Beautiful, Modern, and Professional Spreadsheets!

How to Remove Blank Rows in Google Sheets | The Easy Way

Sort, filter, and format data

How To Hide and Show Cells Using Checkboxes | EASY

How to Add Checkboxes in Google Sheets | Easy & Simple

How to Sort, Group, and Freeze on Google Sheets | Simple & Easy

Work with data

Google Sheets | Reference Cell in Another Sheet

Finance

The Smart Way to Budget with Spreadsheets

Google Sheets Playlist

25 Videos

How to remove blank rows & gaps in your spreadsheet! #excel #googlesheets

How to remove blank rows & gaps in your spreadsheet! #excel #googlesheets

0:20

Simple, yet powerful tips for the header in your spreadsheet! #googlesheets #excel #tips

Simple, yet powerful tips for the header in your spreadsheet! #googlesheets #excel #tips

0:28

How to use checkboxes in Google Sheets! #spreadsheets #googlesheets #checkboxes

How to use checkboxes in Google Sheets! #spreadsheets #googlesheets #checkboxes

0:45

How to hide and show data using checkboxes! #spreadsheets #sheets

How to hide and show data using checkboxes! #spreadsheets #sheets

0:23

How to make dynamic charts for google sheets! #tutorial #spreadsheets #googlesheets #sheets

How to make dynamic charts for google sheets! #tutorial #spreadsheets #googlesheets #sheets

0:54

How to separate cell data in Google Sheets! (the Split Formula) #spreadsheets

How to separate cell data in Google Sheets! (the Split Formula) #spreadsheets

0:28

Easily extract numbers from a cell in Google Sheets! #spreadsheets

Easily extract numbers from a cell in Google Sheets! #spreadsheets

0:53

Finding averages the PROPER way in your spreadsheets! #tutorial #spreadsheets #excel #sheets

Finding averages the PROPER way in your spreadsheets! #tutorial #spreadsheets #excel #sheets

0:36

How to find an average based off a criteria, easy & simple! 🔢 #sheets #spreadsheets

How to find an average based off a criteria, easy & simple! 🔢 #sheets #spreadsheets

0:45

A practical way to use the COUNTIF function in your spreadsheets! #tutorial #spreadsheets

A practical way to use the COUNTIF function in your spreadsheets! #tutorial #spreadsheets

0:35

How to use the REGEXEXTRACT function in your spreadsheets! #tutorial #spreadsheets

How to use the REGEXEXTRACT function in your spreadsheets! #tutorial #spreadsheets

1:01

Have your spreadsheet automatically summarize your notes using REGEXEXTRACT! #tutorial #spreadsheet

Have your spreadsheet automatically summarize your notes using REGEXEXTRACT! #tutorial #spreadsheet

0:46

How to split up data in a cell! This REGEXextract function can do it all! #spreadsheets #tutorial

How to split up data in a cell! This REGEXextract function can do it all! #spreadsheets #tutorial

0:53

Using AI in your spreadsheets! 🤖 #tutorial #ai #spreadsheets

Using AI in your spreadsheets! 🤖 #tutorial #ai #spreadsheets

1:01

How to make a dropdown in your spreadsheets! (Easy!) #tutorial #spreadsheets

How to make a dropdown in your spreadsheets! (Easy!) #tutorial #spreadsheets

1:01

Simple tips for your spreadsheets! 📊 #tutorial #spreadsheets #tips

Simple tips for your spreadsheets! 📊 #tutorial #spreadsheets #tips

0:49

Tips for styling your spreadsheet, let’s leave ugly sheets in the past! 📊 #tutorial #spreadsheets

Tips for styling your spreadsheet, let’s leave ugly sheets in the past! 📊 #tutorial #spreadsheets

0:50

Do this to stop people from changing things in your spreadsheet. Google sheet protected ranges.

Do this to stop people from changing things in your spreadsheet. Google sheet protected ranges.

0:25

How to transpose data in your spreadsheet. #tutorial #googlesheets

How to transpose data in your spreadsheet. #tutorial #googlesheets

0:18

The secret to good looking spreadsheets! 📊 #tutorial #spreadsheets

The secret to good looking spreadsheets! 📊 #tutorial #spreadsheets

0:49

The SUMPRODUCT is goated and is a MUST KNOW! 🐐 #tutorial #sumproduct #spreadsheets

The SUMPRODUCT is goated and is a MUST KNOW! 🐐 #tutorial #sumproduct #spreadsheets

0:27

How to reference another cell or sheet in Google Sheets! #spreadsheets

How to reference another cell or sheet in Google Sheets! #spreadsheets

0:44

A cool way to link locations in your spreadsheet! ↔️

A cool way to link locations in your spreadsheet! ↔️

0:28

➡️ Creating borders in spreadsheets! #tutorial #spreadsheets #googlesheets

➡️ Creating borders in spreadsheets! #tutorial #spreadsheets #googlesheets

0:45

💡Here's everything you need to know about Google Sheets new Table feature! #spreadsheets

💡Here's everything you need to know about Google Sheets new Table feature! #spreadsheets

1:00