Date: Wednesday, 13th May
Time: 9am to 4pm
Price: £135 +VAT members / £215 +VAT non members
Venue: The Roundthorn Country Hotel, Penrith, CA11 8SJ

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 “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 so will be required to bring a laptop or tablet. Handouts will be provided for reference during the course.