📊 Excel & Google Sheets for Data
Work with data using the world's most widely-used tools. No downloads needed — everything runs in Google Sheets (free).
Prerequisites
No experience needed. Basic computer skills (mouse, keyboard) is all you need. If you can browse a website, you can take this course.
Works with Both Google Sheets and Excel
All examples are shown in Google Sheets — completely free with a Google account, no installation required. Key differences from Excel are noted throughout. If you have Excel, everything in this course works there too.
What You'll Learn
Course Modules
Getting Started with Google Sheets
Open Sheets, tour the interface, understand cell addressing, apply basic formatting, and learn essential keyboard shortcuts.
Formulas & Functions
Write your first formulas, use essential functions, and understand the difference between relative and absolute references.
Logic & Lookup Functions
Make decisions with IF and IFS, count and sum conditionally, and look up values across tables with VLOOKUP and XLOOKUP.
Working with Data
Sort and filter large datasets, freeze header rows, validate data entry, and name ranges for cleaner formulas.
Pivot Tables
Summarize hundreds of rows instantly. Learn Rows, Columns, Values, and Filters — then add slicers for interactive exploration.
Charts & Visualization
Choose the right chart for your data, insert and customize it, and add titles, labels, and colors that communicate clearly.
Data Cleaning
Remove extra spaces, fix capitalization, handle errors and blanks, and eliminate duplicates. Garbage in, garbage out — no more.
Capstone Project
Put it all together: import a realistic 50-row sales dataset, clean it, analyze it, build pivot tables and charts, and write your findings.
🎓 Ready to start? Begin with Module 01 and work your way through. Each module builds on the last. Most modules take 20–40 minutes to complete.
Start Module 01 →