Advanced Excel

Advanced Excel

The purpose of this course:

This course builds on prior knowledge and progresses further with formulas by nesting formulas. Also working with text formulas when data is downloaded incorrectly to put this into the correct format. The delegate will learn to analyse data effectively using Pivot Tables and automate repetitive tasks by recording and playing macros.

Benefits to an organisation:

Users will be able to get to grips with the popular and useful features of this powerful programme. You will be able to improve your productively and maximise your time when producing complex spreadsheets. Users will be able to master some of the complex Excel functions, brining a new level to your ability to present, store and analyse data. The organisation benefits this can provide are wide ranging and can help improve overall business performance and customer satisfaction levels.

Who is this course for?

This course is suitable for anyone who uses Excel regularly to produce a range of spreadsheets and who already has good knowledge of Excel. This course is designed for experienced and confident users of the programme.

What will the course cover?

An in-depth look into:

  • Nesting IF’s
  • And/OR functions
  • Text functions
  • Database functions
  • New formulas: XLOOKUP, Filter, Sort and Unique (O365 only)

Pivot tables and pivot charts:

  • Creating and editing tables and charts
  • Refreshing data
  • Displaying pages
  • Slicers

Templates and advanced editing techniques:

  • Creating and editing templates
  • Deleting templates
  • Paste special and paste link
  • Data validation

Working with macros:

  • Creating and naming macros
  • Absolute and relative macros
  • Creating macro buttons
  • The VBA screen

By the end of the course, delegates will be able to:

  • Validate data by restricting entries and creating drop down lists
  • Create and use templates for speed and efficiency
  • Work efficiently with pivot tables
  • Start to automate routine tasks through the use of macros
  • Use new formulas: XLOOKUP, Filter, Sort and Unique

Timings: 9:30am – 3:30pm

Member cost£249 + VAT

Non-Member cost: £319 + VAT

For more information, or to book a place on this course, call us on 01908 733082 or email training@chambermk.co.ukChamber members can book online.

Our Upcoming The Business Toolkit Events

  • Advanced Excel | Milton Keynes Chamber of Commerce

    10 Feb 2025

    Advanced Excel

  • Introduction to Microsoft Power BI | Milton Keynes Chamber of Commerce

    04 Mar 2025

    Introduction to Microsoft Power BI

  • Introduction to Excel | Milton Keynes Chamber of Commerce

    08 Apr 2025

    Introduction to Excel

  • Level 2 Health & Safety in the Workplace | Milton Keynes Chamber of Commerce

    22 May 2025

    Level 2 Health & Safety in the Workplace

  • Intermediate Excel | Milton Keynes Chamber of Commerce

    03 Jun 2025

    Intermediate Excel

  • The Fundamentals of Project Management | Milton Keynes Chamber of Commerce

    11 Jun 2025

    The Fundamentals of Project Management

  • Advanced Excel | Milton Keynes Chamber of Commerce

    17 Jul 2025

    Advanced Excel

  • Introduction to Excel | Milton Keynes Chamber of Commerce

    16 Sep 2025

    Introduction to Excel

  • Intermediate Excel | Milton Keynes Chamber of Commerce

    22 Oct 2025

    Intermediate Excel

  • The Fundamentals of Project Management | Milton Keynes Chamber of Commerce

    13 Nov 2025

    The Fundamentals of Project Management

  • Level 2 Health & Safety in the Workplace | Milton Keynes Chamber of Commerce

    27 Nov 2025

    Level 2 Health & Safety in the Workplace

  • Advanced Excel | Milton Keynes Chamber of Commerce

    09 Dec 2025

    Advanced Excel

  • Introduction to Excel | Milton Keynes Chamber of Commerce

    27 Jan 2026

    Introduction to Excel

  • Intermediate Excel | Milton Keynes Chamber of Commerce

    25 Feb 2026

    Intermediate Excel

  • Advanced Excel | Milton Keynes Chamber of Commerce

    17 Mar 2026

    Advanced Excel