Advanced Excel

Level 1 of 2

Beginner Level

Prerequisites

Microsoft Office Beginner level or equivalent: entering data, basic formulas such as SUM, AVERAGE and IF, formatting and simple charts. Module 1 includes a short refresher.

Duration

4 weeks · 52 guided hours · 5 modules. Taught live by an instructor — online or in person.

By the end of this level you can

  • Build reliable workbooks with tables, named ranges and error-proof formulas
  • Look up and combine data with XLOOKUP, INDEX/MATCH, SUMIFS and logical functions
  • Produce self-updating reports with dynamic array formulas
  • Summarise large data sets with PivotTables, slicers and PivotCharts
  • Design a clear, one-page dashboard for monthly reporting

Modules

  1. 1Module 1 · 10 h · 3 lessons · free taster lessonReliable Formulas and Excel Tables
  2. 2Module 2 · 11 h · 3 lessons · free taster lessonLookup and Logical Functions
  3. 3Module 3 · 10 h · 3 lessons · free taster lessonDynamic Array Formulas
  4. 4Module 4 · 11 h · 3 lessons · free taster lessonPivotTables and PivotCharts
  5. 5Module 5 · 10 h · 3 lessons · free taster lessonDashboard Fundamentals in Excel
  6. Free course quizQuick Quiz — Advanced Excel Basics

Beginner level project

Monthly Sales and Stock Dashboard

Turn three months of raw sales and stock records from a small distributor in Juba into a structured workbook with lookups, PivotTables and a one-page dashboard that updates when new data is added.

Deliverables

  • A workbook with data stored in Excel tables and a product lookup table
  • Calculated columns using lookups and conditional functions, free of errors
  • PivotTables and PivotCharts for sales by product, branch and month
  • A one-page dashboard with slicers, key figures and conditional formatting

Assessed on

  • Formulas are correct, use structured references and handle missing values
  • Adding a new month of data updates the tables, PivotTables and dashboard with a refresh
  • The dashboard answers the owner's three main questions at a glance
  • The workbook is tidy: named sheets, clear headings, no hard-coded totals

All levels are taught live by an instructor — online or in person — see registration options.