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
At a glance
2 days
In-house at your premises or a venue you choose
HRD Corp claimable
More in this category
Microsoft Excel
1 day
Microsoft Excel
2 days