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

  • Mental Health First Aid | Milton Keynes Chamber of Commerce

    30 Jul 2024

    Mental Health First Aid

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

    05 Sep 2024

    Introduction to Microsoft Power BI

  • Diversity Dynamics | Milton Keynes Chamber of Commerce

    12 Sep 2024

    Diversity Dynamics

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

    10 Oct 2024

    Level 2 Health & Safety in the Workplace

  • Intermediate Excel | Milton Keynes Chamber of Commerce

    15 Oct 2024

    Intermediate Excel

  • Emergency First Aid at Work | Milton Keynes Chamber of Commerce

    13 Nov 2024

    Emergency First Aid at Work

  • Advanced Excel | Milton Keynes Chamber of Commerce

    19 Nov 2024

    Advanced Excel

  • IOSH | Milton Keynes Chamber of Commerce

    27 Nov 2024

    IOSH

  • Intermediate Excel | Milton Keynes Chamber of Commerce

    20 Jan 2025

    Intermediate Excel

  • Powerspeak – Public Speaking & Presentation Skills | Milton Keynes Chamber of Commerce

    06 Feb 2025

    Powerspeak – Public Speaking & Presentation Skills

  • 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