← All Apps
Excel
Move beyond basic spreadsheets — train your teams to analyse data confidently with Power Query, PivotTables, dynamic formulas and visualisations.
Book This Session →
Move beyond basic spreadsheets — train your teams to analyse data confidently with Power Query, PivotTables, dynamic formulas and visualisations.
Book This Session →Microsoft Excel remains the backbone of business data work — a spreadsheet platform that now spans formulas, dynamic arrays, Power Query, PivotTables, Power Pivot and Copilot-powered natural-language analysis. Modern Excel is far more than a grid of numbers; it's a self-service data tool capable of pulling from dozens of sources, shaping data at scale and producing interactive reports.
It's ideal for financial modelling, budgeting, operational reporting, data cleaning, forecasting and any ad-hoc analysis that doesn't warrant a full BI project. Finance, operations, HR, analysts, project managers and department heads benefit most. Excel solves the universal business problem of data being scattered across systems and manipulated inconsistently — by giving everyone a single, familiar environment to transform, analyse and share numbers, without waiting on a central data team.
A focused session designed to build real-world skills fast.
A confident tour of the Excel interface — workbooks, worksheets, the ribbon and the formula bar — so nothing on screen feels mysterious. We then practise entering and editing text, numbers and dates cleanly, and let AutoFill and Flash Fill take over the repetitive typing.
Making spreadsheets readable with number formats, alignment, borders and cell styles that give your work a professional finish. We also unlock Paste Special, so you can paste just the values, just the formats, or transpose a whole range in one move.
The heart of Excel, starting with relative and absolute references so formulas copy correctly every time. We build fluency with the core functions — SUM, AVERAGE, COUNT, COUNTA, MIN and MAX — then add decision-making with IF and look up values across sheets with XLOOKUP.
Turning raw data into answers by sorting and filtering, then converting ranges into Excel Tables with a Total Row and built-in filtering. Conditional formatting highlights what matters with rules and colour scales, while data validation keeps entries clean with dropdown lists and input restrictions.
Presenting results with basic column, bar, line and pie charts, and printing without surprises using print areas, page layout and repeating titles. We finish with saving to OneDrive and SharePoint so the whole team can co-author the same workbook at once.