Master Excel from the basics to advanced features: formulas, conditional formatting, pivot tables, Power Query, Power Pivot/DAX, VBA, dashboards and certification.
Understand Excel, install it and discover workbooks, sheets and cells.
Format a table and write your first formulas and functions.
Automate calculations with logical and lookup functions, filter and structure.
Summarise and visualise: pivot tables, charts, slicers and data validation.
Automate cleaning, model data and program Excel.
Dashboards, analysis, collaboration and certification prep.
Case studies, error playbook, toolbox and field feedback.