Skip to Main Content

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

Event Details

  • Date: 9 July 2025 -
  • Venue: Cumbria Chamber of Commerce, Carlisle
Sign in to register