What you'll learn:
- Write essential Excel formulas from scratch: SUMIFS, COUNTIFS, VLOOKUP, IF, date functions, and error handling
- Use Microsoft 365 functions including XLOOKUP, FILTER, SORT, and UNIQUE with dynamic array formulas
- Build pivot tables, pivot charts, slicers, and timelines to analyze and present data interactively
- Clean and organize data using sort, filter, Flash Fill, remove duplicates, and Find and Replace
- Apply conditional formatting, number formatting, and workbook design principles for professional reports
- Create advanced Excel charts including Pareto, Histogram, Treemap, Sunburst, combination charts, and sparklines
- Use Power Query to import, clean, and combine data from multiple sources without formulas
- Prepare and print Excel reports correctly including page breaks, headers, footers, and PDF export
Whether you're starting from zero or filling in the gaps, this course covers every Excel skill you'll actually use at work.
Most Excel users learn just enough to get by. This course gives you the full picture: from entering data correctly and writing formulas confidently, to building pivot tables, cleaning messy data with Power Query, and creating professional charts and reports.
It works for complete beginners and for experienced users who want to make sure their skills are solid across the board.
What you'll be able to do after this course:
Navigate and manage large Excel spreadsheets efficiently using shortcuts and productivity features
Write formulas correctly from the start: absolute and relative referencing, range names, error handling, and cross-sheet references
Use essential Excel functions: SUMIFS, COUNTIFS, AVERAGEIFS, VLOOKUP, IF, MAXIFS, date functions, and more
Use Microsoft 365 functions including XLOOKUP, FILTER, SORT, UNIQUE, and dynamic arrays
Clean and transform data using sort, filter, remove duplicates, Flash Fill, and Find and Replace
Apply conditional formatting, custom number formatting, and spreadsheet design principles for professional reports
Build pivot tables, pivot charts, slicers, and timelines to analyze data quickly
Create charts including combination charts, Pareto, Histogram, Treemap, Sunburst, and sparklines
Prepare and print Excel reports correctly including headers, footers, page breaks, and PDF export
Use Power Query to import, clean, and combine data from multiple sources
Why this course covers ground others skip:
Most Excel courses teach you what functions do. This one focuses on how to apply them to real files with messy, inconsistent data. Every section includes a practical challenge with a solution file so you can test yourself, not just watch.
The course also covers topics many Excel courses ignore entirely: workbook design principles, protecting worksheets and ranges, printing large datasets correctly, and how Excel's new calculation engine in Microsoft 365 affects your existing formulas.
What's inside:
15 sections from Excel basics to Power Query and Microsoft 365 dynamic arrays
Challenges and solution files in every section
Quizzes throughout to test your understanding
Downloadable course notes covering the most important concepts
"Become Pro" lessons flagged throughout for features that go beyond the basics
Version note:
Works with Excel 2016, Excel 2019, and Excel for Microsoft 365. Most features work on Excel 2010 and 2013. The dynamic arrays section requires Microsoft 365. Power Query requires the free add-in for Excel 2010 and 2013.
Taught by Leila Gharani, Microsoft MVP and trusted by 515,000+ students across 11 courses on Udemy.
Enroll now and start building Excel skills you'll use every day at work.
