In this module, you’ll get comfortable with the Excel workspace and its core tools. You’ll learn how to navigate the interface, customize your layout, and use smart data entry features like Autofill, Flash Fill, and data validation. By the end of this module, you’ll be able to enter, organize, and format data efficiently and professionally.
This module takes your formula skills to the next level. You’ll work with advanced functions like IF, AND, OR, and IFERROR to make your spreadsheets more dynamic. You’ll also learn how to search and reference data using VLOOKUP, INDEX, MATCH, and XLOOKUP, plus manipulate text with string functions. These are the tools Excel professionals use every day.
Data quality is everything. In this module, you’ll discover how to clean messy data, fix common issues like duplicates and inconsistent formats, and ensure accuracy using Excel’s built-in data validation tools. You’ll leave this module knowing how to prepare raw datasets for reliable analysis.
In this module, you’ll learn how to structure your data with Excel Tables, apply powerful filters and sorts, and define Named Ranges to streamline your formulas. These techniques help you manage large datasets more effectively and write cleaner, more understandable spreadsheets.
Here, you’ll unlock Excel’s most powerful tool—PivotTables. You’ll learn how to summarize data by categories, perform custom calculations, and display insights with PivotCharts and slicers. This module will help you turn raw data into visual, actionable reports that tell a story.
Module 6: Professional Spreadsheet Design & Delivery
In the final module, you’ll bring everything together to create polished, professional spreadsheets. You’ll design interactive dashboards, protect sensitive areas of your workbook, and prepare clean outputs for sharing or printing. By the end, your Excel files will not only work perfectly—they’ll look great too.