Grow Your Business Excel - Advanced

Programme

Excel - Advanced

Date: Tuesday 15th April 2025
Time: 9am to 4pm 
Price: £120 +VAT Chamber members / £199 + VAT non members
Venue: The Melbreak Hotel, Winscales Road, Little Clifton, Workington, CA14 1XS

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).

To book onto this course, you will be taken to our parent organisation Cumbria Chamber of Commerce's website.

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.