Table of Contents
Front Matter
Main Content
Why Spreadsheets Still Matter
The most important software skill you can have — and why AI makes it even more powerful.
Spreadsheet Fundamentals
Cells, ranges, formatting, and the basics everyone needs.
Formulas and Functions
The essential functions that solve 90% of spreadsheet problems.
Data Management
Sorting, filtering, cleaning, and organizing your data.
Lookups and References
VLOOKUP, XLOOKUP, INDEX-MATCH, and connecting data across sheets.
Pivot Tables and Summarization
Turn raw data into insights in minutes.
Charts and Visualization
Present your data clearly and persuasively.
Automation and Efficiency
Keyboard shortcuts, templates, and working faster.
Using AI with Spreadsheets
Let AI write formulas, clean data, and solve problems for you.
Real-World Projects
Budgets, trackers, dashboards, and templates you can use today.