Grow Your Business Excel - Advanced

Programme

Excel - Advanced

Date: Wednesday, 9th of July 2025
Time: 9am to 4pm
Price: £120 +VAT members / £199 +VAT non members
Venue: Cumbria Chamber of Commerce, 3rd Floor, Broadacre House, 16-20 Lowther Street, Carlisle, CA3 8DA

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.

Related Programmes

11 February 2025

The Melbreak Country House Hotel

This course is suitable for delegates who are new to Excel or are self-taught and wish to ensure they make the most of the basic functions.

11 March 2025

The Melbreak Country House Hotel

The aim of the course is to provide delegates with the skills to use functionality that will make formulae easier to work with, to create formulae using data from multiple worksheets, and to apply more complex formatting.

15 April 2025

The Melbreak Country House Hotel

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