Excel and Google Sheets Mastery

Go from basic spreadsheets to powerful data analysis. Learn formulas, pivot tables, charts, and automation with macros. Essential skill for any career.

Level:Beginner
Duration:9 hours
Lessons:8

Course Preview

Learn This on Popular Platforms

Affiliate links - We may earn a commission when you sign up through these links

Recommended Gear

Get the tools you need for this course: Excel Bible 2024

View on Amazon

Amazon affiliate link - We earn a commission at no extra cost to you

Course Curriculum

1

Spreadsheet Fundamentals

Navigation, data entry, and basic formatting

30 min
2

Essential Formulas

SUM, AVERAGE, IF, VLOOKUP, and more

75 min
3

Data Sorting and Filtering

Organizing large datasets quickly

45 min
4

Pivot Tables

Summarize thousands of rows in seconds

60 min
5

Charts and Dashboards

Visualizing data effectively

60 min
6

Conditional Formatting

Making data insights visually obvious

30 min
7

Google Sheets Specifics

Collaboration features and Google-only functions

45 min
8

Macros and Automation

Record and run macros to save hours of work

60 min

Total course duration: 9 hours