StretchLearn Course

Turn messy spreadsheets into decisions in Excel and Google Sheets

Clean data, the formulas that matter, pivot tables, honest charts, and an interactive dashboard, taught side by side in both tools.

Preview Curriculum Back to Catalog

Beginner9 hr 55 minSelf PacedRegistered

Course Overview

What this course is designed to develop

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.

Learning Outcomes

What the learner should be able to understand, build, or execute.

Structure and clean raw data into proper tables using consistent headers, data types, and tools like Text to Columns, TRIM, and Remove duplicates

Write lookup and aggregation formulas that work, including XLOOKUP, INDEX/MATCH, SUMIFS, COUNTIFS, and IF/IFS, with correct absolute and relative references

Use Google Sheets-only functions QUERY, FILTER, ARRAYFORMULA, and UNIQUE to pull and reshape data the way SQL would

Summarize thousands of rows with PivotTables and pivot tables, including grouping, calculated fields, filtering, and slicers

Choose and build the right chart for each question and avoid misleading axes, dual-axis traps, and chart-junk

Assemble an interactive dashboard combining named ranges, lookups, pivots, slicers, conditional formatting, and KPI tiles in both Excel and Google Sheets

Curriculum Preview

Inside the curriculum: a structured path from fundamentals to execution.

Preview the course structure, see how the modules build on one another, and understand the path this program is designed to take you through.

Module 1

Module 1: Getting Your Data Right: Structure, Cleaning, and References

Before any formula works, your data has to be structured and clean. Set up proper tables, fix common data problems, and understand the reference system every formula depends on.

3 lessons

Why structure beats formulas, and how to set up a real tableContent · 45 min

Preview Enabled

Cleaning messy data without losing your mindContent · 50 min

LMS Access

References, errors, and the F4 key that saves your formulasContent · 45 min

LMS Access

Module 2

Module 2: The Formulas That Actually Matter

A small set of functions does the vast majority of real spreadsheet work. Master logic, lookups, and conditional aggregation in both tools, plus the QUERY and FILTER superpowers unique to Google Sheets.

3 lessons

Logic and conditional aggregation: IF, IFS, SUMIFS, COUNTIFSContent · 55 min

LMS Access

Lookups done right: XLOOKUP and INDEX/MATCHContent · 55 min

LMS Access

Google Sheets superpowers: QUERY, FILTER, ARRAYFORMULA, UNIQUEContent · 50 min

LMS Access

Module 3

Module 3: Pivot Tables: Summarizing Thousands of Rows in Seconds

Pivot tables are the fastest way to summarize and explore large data without writing formulas. Build, group, calculate, and slice them in both Excel and Google Sheets.

3 lessons

Pivot table fundamentals in both toolsContent · 50 min

LMS Access

Grouping, calculated fields, and showing values asContent · 50 min

LMS Access

Slicers, filters, and interactive explorationContent · 45 min

LMS Access

Module 4

Module 4: Charts and the Interactive Dashboard

Turn summaries into honest charts and combine everything, lookups, pivots, slicers, conditional formatting, into a single dashboard a decision-maker can use.

3 lessons

Choosing and building the right chartContent · 50 min

LMS Access

Conditional formatting and KPI tilesContent · 45 min

LMS Access

Assembling a real interactive dashboardContent · 55 min

LMS Access

Built for Application

A complete learning path, not a one-off inspiration hit.

This program is designed around progression: focused lessons, structured modules, applied resources, assessments, and a course rhythm that turns information into usable capability.

excelgoogle sheetsspreadsheet formulaspivot tablesxlookupdata analysisdashboardsdata cleaning