Excel: Basic to Advanced

Course syllabus

Every module in the order you'll work through it. Each one is practised inside the portal and marked as you go.

1. 01

   Basics

   Challenge

   18 lessons: the interface, workbooks, data entry, formatting, Fill Handle, Paste Special, Flash Fill, printing and keyboard shortcuts.

   6 Hours
2. 02

   Formulas Core

   Challenge

   14 lessons: operators, SUM and COUNT family, logical, text, date and lookup functions, named ranges and error handling.

   5 Hours
3. 03

   Intermediate

   Challenge

   15 lessons: sorting, filtering, conditional formatting, data validation, tables, charts, sparklines and sharing.

   5 Hours
4. 04

   Advanced Formulas

   Tool

   7 lessons: INDEX & MATCH, XLOOKUP, dynamic arrays, SUMPRODUCT, LET & LAMBDA and financial functions.

   3 Hours
5. 05

   Analysis Tools

   Tool

   8 lessons: pivot tables, slicers, pivot charts, Goal Seek, Scenario Manager, data tables and Solver.

   3 Hours
6. 06

   Power Tools

   Tool

   6 lessons: Power Query get, clean, merge and append, the Data Model, Power Pivot with DAX, and interactive dashboards.

   3 Hours
7. 07

   Automation

   Tool

   6 lessons: recording macros, VBA basics, loops and conditions, UserForms, Office Scripts and Copilot in Excel.

   3 Hours
8. 08

   Capstone Projects

   Project

   6 projects: employee report, invoice and billing, payroll, loan/EMI calculator, inventory tracker and sales dashboard.

   6 Hours