Excel - Advanced

The aim of the course is to provide delegates with the skills to manage and analyse large amounts of data in a worksheet.

Prerequisites
Delegates must have previously attended the “Further Progress in Excel” course or gained similar knowledge in the workplace.

Course Outline

• 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 will be asked to carry out exercises as we progress. Handouts will be provided for reference during the course.

Delegates must have a laptop (or equivalent) running Excel for Microsoft 365(not online version)

Book here