Course curriculum
-
01
Getting Started
Show Content- Course Overview
- Learning Outcomes
- Exercises
- Pivot Table Data Sets
- Introduction
-
02
Getting Started with Google Sheets
Show Content- Getting Started with Google Sheets
- EXERCISE #1: Getting Familiar With Google Sheets Core Functionality
- Review What You've Learned
-
03
Worksheets and Workbooks
Show Content- Overview
- EXERCISE #2: Worksheets and Workbooks
- Review What You've Learned
-
04
Entering and Organizing Data
Show Content- Overview
- EXERCISE #3: Entering and Organizing Data
- Review What You've Learned
-
05
Formatting and Organizing Data
Show Content- Overview
- EXERCISE #4: Formatting and Organizing Data
- Review What You've Learned
-
06
Formulas and Functions
Show Content- Overview
- Absolute and Relative Cell References
- Typical Formulas and Functions
- Manipulating Text, Statistics, Lookup Functions and Formula Errors
- EXERCISE #5: Formulas and Functions
- EXERCISE #6: Advanced Formulas and Functions
- Review What You've Learned
-
07
Charts and Graphs
Show Content- Overview
- Additional Chart Types
- EXERCISE #7: Charts and Graphs
- Review What You've Learned
-
08
Pivot Tables
Show Content- Overview
- Pivot Table Basics
- EXERCISE #8: Pivot Tables
- Review What You've Learned
-
09
Printing and Saving
Show Content- Overview
- EXERCISE #9: Printing and Saving
- Review What You've Learned
-
10
Wrap Up
Show Content- Wrap Up
- Reflect On Your Learning
- Share Your Feedback