Excel — From Fundamentals to Advanced
This training begins with mastering the fundamentals of Excel, including formatting and the use of relative and absolute references. You will then progress to advanced formulas such as INDEX/MATCH, IFS, IFERROR, and the nesting of complex functions. The program also covers creating pivot tables, using slicers, and designing high-performance charts. You will learn to connect to external data sources using Power Query and to secure your inputs with drop-down menus and data validation rules. Finally, you will apply all these skills through a hands-on case study: designing a Target vs Actual dashboard based on real business data.
Objectives
Master Excel fundamentals: formatting, references (relative and absolute), and essential functions. Write advanced formulas: INDEX/MATCH, IFS, IFERROR, and nested functions. Build and manipulate pivot tables to summarize large datasets. Use slicers and interactive filters to make reports dynamic. Design effective, readable charts that communicate insights clearly. Connect to external data sources using Power Query. Secure data entry using drop-down menus and data validation rules. Build a complete Target vs Actual dashboard as a real-world capstone project.
Target audience
Business professionals, analysts, managers, and anyone working regularly with spreadsheets who wants to move beyond basic Excel use and produce reliable, professional reports and dashboards.
Prerequisites
Basic familiarity with Excel (entering data, simple formulas like SUM and AVERAGE, simple formatting). No prior experience with pivot tables or advanced functions required.
Instructors
Original Name
Updated bio.
Upcoming sessions
No session scheduled yet. Contact us to hear about the next cohort.
Discover also