The aim of the course is to provide delegates with the skills to manage and analyse large amounts of data in a worksheet.
Delegates must have previously attended the Excel Intermediate course or gained similar knowledge in the workplace.
The course covers:
- Outlining and Grouping Data
- Using Subtotals Function
- Exploring Scenarios
- Goal Seek and Data Tables
- Using Solver
- Using the VLOOKUP Function
- Using the HLOOKUP Function
- Recording and Playing Macros
- Copying and Deleting Macros
- Visual Basic and Macros
- Getting Started with PivotTables
- Displaying Data in a PivotTable
- Formatting a PivotTable
- Using the Classic PivotTable Layout
- Getting Started with PivotCharts
- Using the PivotChart Tools Tabs
- Formatting a PivotChart
Delegates must have a laptop (or equivalent) running Excel for Microsoft 365(not online version).
£120 +VAT members / £199 +VAT non members
