Google Sheets Basics – Create, Design, and Share

Learn all of the foundational skills necessary to create and use spreadsheets. 10 downloadable videos, LINKED GOOGLE SHEETS for you to copy and use, quizzes, and built-in notes. You'll have lifetime access to this course.

Buy $19.99 Free Preview

1

Welcome to the course!
- Intro and how to use this course
- Before we begin...
2

Create a Spreadsheet
- Create a Spreadsheet - Video
- Create a Spreadsheet - Text
3

Style your Spreadsheet
4

Use Cell References
- Use Cell References - Video
- Use Cell References - Text
- Use Cell References - Quiz
5

Create Formulas
- Create Formulas - Video
- Create Formulas - Text
- Create Formulas - Quiz
6

Sort and Filter
- Sort and Filter - Video
- Sort and Filter - Text
- Sort and Filter - Quiz
7

Share and Protect
- Share and Protect - Video
- Share and Protect - Text
8

Pivot Tables
- Pivot Tables - Video
- Pivot Tables - Text
- Pivot Tables - Quiz
9

Top 10 Functions
- Top 10 Functions - Video
- Top 10 Functions - Text
- Top 10 Functions - Quiz
10

Protect, Hide, and Edit Sheets
- Protect, Hide, and Edit Sheets - Video
- Protect, Hide, and Edit Sheets - Text
11

Wrapping up
- Copy of Before you go...

Experienced Instructor

I'm Adam Steinfurth (AKA Prolific Oaktree) and I work on different clients' spreadsheet on a daily basis. This course is drawn from this experience and from feedback on the videos and articles that I have created about spreadsheets over the years.
Video Based

The ideas in this course are conveyed through screencast videos supplemented with notes and quizes. We'll walk through the exact steps needed to create and customize your Pivot Tables and discuss the "how" and the "why" along the way.
Shared files

The spreadsheet files shown in the video are made available to everyone that purchases the course. You can copy them into your own Google Drive and you will have unlimited access to them.

wounsel

Excellent tutorial. Straight to the point. Thanks!

Lindsey J

Just passed my google educator level 2 exam! Your videos really helped me to prepare. Thanks!

Chris R

Thank you! Solved my problem very clearly and concisely.