Excel & Google Sheets Mastery
Turn messy spreadsheets into decisions in Excel and Google Sheets
About this course
This course teaches the concrete, transferable craft of working with data in Excel and Google Sheets, treating both tools together so you can switch between them and pick the right one for a job. You will learn to clean and structure data into proper tables, write the formulas that matter in practice (XLOOKUP and INDEX/MATCH for lookups, SUMIFS and COUNTIFS for conditional aggregation, IF and IFS for logic, plus Google Sheets-only powers like QUERY, FILTER, and ARRAYFORMULA), and avoid the reference and error mistakes that quietly corrupt results. From there you will summarize and slice large datasets with PivotTables and pivot tables, choose and build charts that match the question being asked, and finally combine named ranges, lookups, pivots, slicers, and conditional formatting into a single interactive dashboard. By the end you can take an unfamiliar spreadsheet of thousands of rows and turn it into a clear answer, in either tool, without guesswork.
Curriculum
Module 1: Getting Your Data Right: Structure, Cleaning, and References
- Why structure beats formulas, and how to set up a real tablePreview
- Cleaning messy data without losing your mind🔒
- References, errors, and the F4 key that saves your formulas🔒
Module 2: The Formulas That Actually Matter
- Logic and conditional aggregation: IF, IFS, SUMIFS, COUNTIFS🔒
- Lookups done right: XLOOKUP and INDEX/MATCH🔒
- Google Sheets superpowers: QUERY, FILTER, ARRAYFORMULA, UNIQUE🔒
Module 3: Pivot Tables: Summarizing Thousands of Rows in Seconds
- Pivot table fundamentals in both tools🔒
- Grouping, calculated fields, and showing values as🔒
- Slicers, filters, and interactive exploration🔒
Module 4: Charts and the Interactive Dashboard
- Choosing and building the right chart🔒
- Conditional formatting and KPI tiles🔒
- Assembling a real interactive dashboard🔒