IN-STEP E.X.C.E.E.D. - Excel Intermediate to Advanced

2 days

HRD Corp claimable

Runs in-house for your team

Overview

This programme builds on basic Excel knowledge for executives, managers, administrators, analysts and finance and HR staff who want stronger data analysis and reporting skills.

Sessions combine interactive lectures and discussion with practical exercises. Participants work through relative, absolute and mixed references, conditional functions such as SUMIFS and IFS, tables, conditional formatting and charts, then outlines and subtotals, XLOOKUP and data consolidation across workbooks. The later sessions cover PivotTables, slicers and PivotCharts, followed by protection for cells, sheets, workbooks and files.

Participants come away able to build interactive management reports and protect them from unauthorised changes.

Module topics

  • Relative, absolute and mixed references
  • Summary and conditional functions
  • Excel tables, sorting and filtering
  • Conditional formatting and charts
  • Managing multiple workbook windows
  • Outlining, grouping and subtotals
  • XLOOKUP and data consolidation
  • PivotTables, slicers and PivotCharts
  • Worksheet and workbook protection

Who runs this programme

Anne Hui San Teoh

Excel, Power Query and Copilot trainer

At a glance

2 days

In-house at your premises or a venue you choose

HRD Corp claimable