Home / Course catalog
Course
Excel Level 1 – 1 Structuring stable operational tables (Bus_Excel_01-01)
Business tools
Excel Level 1 – 1 Structuring stable operational tables (Bus_Excel_01-01)
Excel Level 1 – 1 Structuring stable operational tables focuses on the fundamentals of creating and managing tables in Excel. This includes learning how to organize data effectively, use proper formatting, and implement sorting and filtering...
Excel Level 1 – 2 Speeding-up recurring data entry (Bus_Excel_01-02)
Business tools
Excel Level 1 – 2 Speeding-up recurring data entry (Bus_Excel_01-02)


Excel Level 1 – 2 focuses on techniques to speed up recurring data entry tasks. This includes using features like AutoFill to quickly populate cells with repetitive data, as well as leveraging data validation to ensure accuracy while minimizing...
Excel level 1 – 3 Core calculations for totals and counts (Bus_Excel_01-03)
Business tools
Excel level 1 – 3 Core calculations for totals and counts (Bus_Excel_01-03)

This module helps you apply core calculations confidently to support billing and basic reporting. It directly addresses the need to use SUM, AVERAGE, COUNT and related functions to produce reliable totals and counts, including percentages and...

Excel level 1 – 4 Basic logic with IF (Bus_Excel_01-04)
Business tools
Excel level 1 – 4 Basic logic with IF (Bus_Excel_01-04)

This module helps learners automate operational logic with simple formulas based on IF. It directly responds to the need to create status flags such as overdue/paid/pending or missing data, and to use basic conditional logic safely so these flags...

Excel level 2 – 1 Reconciling and matching information (Bus_Excel_02-01)
Business tools
Excel level 2 – 1 Reconciling and matching information (Bus_Excel_02-01)

This module helps learners reconcile and consolidate information across files without manual checking. It directly addresses the need to match session lists, client lists, tariffs and SDN checks by using XLOOKUP and related techniques to bring in...

Excel level 2 – 2 Filtering and sorting for daily decisions (Bus_Excel_02-02)
Business tools
Excel level 2 – 2 Filtering and sorting for daily decisions (Bus_Excel_02-02)

This module helps learners filter and sort efficiently to support daily decision‑making. It directly responds to the need to extract client‑specific views, clean lists, and prioritise work by using filters, multi‑level sorting, and safe...

Excel level 2 – 3 Weekly summaries with pivot tables (Bus_Excel_02-03)
Business tools
Excel level 2 – 3 Weekly summaries with pivot tables (Bus_Excel_02-03)

This module helps learners build weekly and monthly summaries quickly without manual counting or heavy copy‑paste. It directly addresses the need to generate meeting summaries, payment follow‑up recaps, and planning or occupancy summaries by...

Excel level 2 – 4 Making issues visible with formatting rules (Bus_Excel_02-04)
Business tools
Excel level 2 – 4 Making issues visible with formatting rules (Bus_Excel_02-04)

This module helps learners make issues visible and avoid “formatting disappears” problems in their files. It directly answers the need to use conditional formatting correctly so that overdue items, missing data, duplicates, and priorities are...

Excel level 3 – 1 Consolidating multi‑source data with power query (Bus_Excel_03-01)
Business tools
Excel level 3 – 1 Consolidating multi‑source data with power query (Bus_Excel_03-01)

This module helps learners import and combine data from multiple sources with minimal manual handling. It directly addresses the need to consolidate simulator exports and recurring extracts reliably by using Power Query to import, transform, and...

Excel level 3 – 2 Reducing errors at source with data validation (Bus_Excel_03-02)
Business tools
Excel level 3 – 2 Reducing errors at source with data validation (Bus_Excel_03-02)

This module helps learners prevent errors at source in shared operational files. It directly responds to the need to enforce dropdowns, allowed values, and input constraints, so only valid data is entered and colleagues are guided when they risk...

Oh, no. Nothing was found.

Use a different term and try again.