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, bringing 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
Call the Training Team to discuss your training requirements 01604 490490 or email training@northants-chamber.co.uk

Our Upcoming The Business Toolkit Events

  • Mental Health First Aid | Northamptonshire Chamber of Commerce

    30/07/2024

    Mental Health First Aid

    By |Tags: |

    This course will allow you to become part of the largest MHFAider® community in England, gaining access to resources, ongoing learning and 24/7 digital support through our MHFAider Support App®, to give you the tools and knowledge you need to carry out the role effectively and confidently, whether that be in your workplace, a volunteer role, or in the community.

  • Emergency First Aid at Work | Northamptonshire Chamber of Commerce

    13/11/2024

    Emergency First Aid at Work

    By |Tags: |

    This course will train attendees to give appropriate emergency first aid to anyone who is ill or injured in the workplace. The course teaches the appropriate level of first aid required in low-risk businesses under the HSE 1981 legislation. Students are assessed to ensure that they understand and would be able to fulfil the role of first aider within their workplace. Bostock are registered by the First Aid Industry Body (FAIB) to provide EFAW training.

  • Introduction to Excel | Northamptonshire Chamber of Commerce

    10/04/2024

    Introduction to Excel

    By |Tags: |

    Excel is a multi-functional tool that can aid in a number of business functions. It is useful for creating databases of customers and suppliers or can be used for financial reporting. The pace of this course will suit those with little or no knowledge of the programme. By the end of this course, delegates will be able to navigate Excel with confidence, create simple spreadsheets and edit it using a variety of quick and effective methods learnt on the course.

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

    21/05/2024

    Level 2 Health & Safety in the Workplace

    By |Tags: |

    The most basic requirement of any workplace is that it is a safe place to work! This course provides solid and essential knowledge for any employee working in any area of the business, including how to identify potential hazards, how to report potential health and safety problems and how to work in safe and healthy manner. Good health and safety relies on employers and their employees working together.

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

    10/10/2024

    Level 2 Health & Safety in the Workplace

    By |Tags: |

    The most basic requirement of any workplace is that it is a safe place to work! This course provides solid and essential knowledge for any employee working in any area of the business, including how to identify potential hazards, how to report potential health and safety problems and how to work in safe and healthy manner. Good health and safety relies on employers and their employees working together.

  • Intermediate Excel | Northamptonshire Chamber of Commerce

    13/05/2024

    Intermediate Excel

    By |Tags: |

    Anyone who is familiar with the basic features of Excel together with basic formulas will benefit from attending this course. This course places great emphasis upon the importance of understanding how to build the spreadsheet correctly with Dynamic Ranges. It is therefore important that participants are at the appropriate level to ensure a good learning experience.

  • Advanced Excel | Northamptonshire Chamber of Commerce

    23/05/2024

    Advanced Excel

    By |Tags: |

    Do you already have good knowledge of Excel? Then this one’s for you! This course builds on your prior knowledge and will progress you further by using some of the more complex Excel functions, bringing your ability to a new level using new formulas and analysing data effectively.

  • Intermediate Excel | Northamptonshire Chamber of Commerce

    15/10/2024

    Intermediate Excel

    By |Tags: |

    Anyone who is familiar with the basic features of Excel together with basic formulas will benefit from attending this course. This course places great emphasis upon the importance of understanding how to build the spreadsheet correctly with Dynamic Ranges. It is therefore important that participants are at the appropriate level to ensure a good learning experience.

  • Advanced Excel | Northamptonshire Chamber of Commerce

    19/11/2024

    Advanced Excel

    By |Tags: |

    Do you already have good knowledge of Excel? Then this one’s for you! This course builds on your prior knowledge and will progress you further by using some of the more complex Excel functions, bringing your ability to a new level using new formulas and analysing data effectively.

  • Intermediate Excel | Northamptonshire Chamber of Commerce

    20/01/2025

    Intermediate Excel

    By |Tags: |

    Anyone who is familiar with the basic features of Excel together with basic formulas will benefit from attending this course. This course places great emphasis upon the importance of understanding how to build the spreadsheet correctly with Dynamic Ranges. It is therefore important that participants are at the appropriate level to ensure a good learning experience.

  • Advanced Excel | Northamptonshire Chamber of Commerce

    10/02/2025

    Advanced Excel

    By |Tags: |

    Do you already have good knowledge of Excel? Then this one’s for you! This course builds on your prior knowledge and will progress you further by using some of the more complex Excel functions, bringing your ability to a new level using new formulas and analysing data effectively.

  • Emergency First Aid at Work | Northamptonshire Chamber of Commerce

    06/06/2024

    Emergency First Aid at Work

    By |Tags: |

    This course will train attendees to give appropriate emergency first aid to anyone who is ill or injured in the workplace. The course teaches the appropriate level of first aid required in low-risk businesses under the HSE 1981 legislation. Students are assessed to ensure that they understand and would be able to fulfil the role of first aider within their workplace. Bostock are registered by the First Aid Industry Body (FAIB) to provide EFAW training.

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

    19/06/2024

    Powerspeak – Public Speaking & Presentation Skills

    By |Tags: |

    This course is designed to enhance public speaking and presentation abilities. It focusses on voice control, overcoming public speaking anxiety, effective body language, and practical scenario training. The aim is to build confidence and improve communication skills for a variety of professional contexts.

  • Introduction to Microsoft Power BI | Northamptonshire Chamber of Commerce

    05/09/2024

    Introduction to Microsoft Power BI

    By |Tags: |

    This course will help you gain the skills in how to analyse data and share insights with one of the most powerful reporting tools. With over 20 built-in visuals and a vibrant community of custom visualisations, you can create stunning reports.

  • Diversity Dynamics | Northamptonshire Chamber of Commerce

    12/09/2024

    Diversity Dynamics

    By |Tags: |

    This course is designed to empower organisations to harness the power of diversity and inclusion. The core purpose is to foster an environment where every employee feels valued, understood, and integral to the success of the business. By breaking down barriers, challenging stereotypes and cultivating an inclusive mindset, this course aims to transform your workplace into a vibrant, dynamic, and innovative hub.

  • IOSH | Northamptonshire Chamber of Commerce

    27/11/2024

    IOSH

    By |Tags: |

    The IOSH Managing Safely course aims to provide individuals with the knowledge and skills to effectively manage health and safety in the workplace, ensuring a safer working environment and compliance with relevant regulations.

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

    06/02/2025

    Powerspeak – Public Speaking & Presentation Skills

    By |Tags: |

    This course is designed to enhance public speaking and presentation abilities. It focusses on voice control, overcoming public speaking anxiety, effective body language, and practical scenario training. The aim is to build confidence and improve communication skills for a variety of professional contexts.

Northamptonshire Business Awards 2023!

The Northamptonshire Business Awards recognise and celebrate the very best in Northamptonshire business.

On Thursday 23rd November 2023 we revealed the winners of the Northamptonshire Business Awards 2023, headline sponsored by Wilson Browne Solicitors! Make sure you check out our highlight video and find out this year’s winners here.