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.

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

Related Programmes

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.

14 May 2025

Carlisle

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

11 June 2025

Carlisle

Provide you with the skills to use functionality that will make formulae easier to work with.