Intermediate Excel

Intermediate Excel

The purpose of the course:

The Intermediate Excel course focuses on more in depth formulas and data handling.

Benefits for your organisation:

This course builds on the knowledge of the introduction to Excel course by showing the user how to get more out of the programme. Delegates will learn to work with Dynamic Ranges meaning spreadsheets will remain up to date even when new data is added.

Who is this course for?

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.

What will the course cover?

An in-depth look into:

  • IF’s and VLOOKUP functions
  • Worksheet/workbook linking
  • Calculating with dates
  • Subtotals

Controlling data using:

  • Dynamic Ranges
  • Filtering
  • Grouping and outlining
  • Freeze panes
  • Sorting data
  • Working with comments

Manipulating worksheets using:

  • Named Ranges
  • Conditional formatting
  • Hiding/un-hiding data
  • Password protecting worksheets
  • Protecting specific cells

Advanced Chartering – Building on basic chartering using:

  • Combining multi-chart types
  • Custom chart formats
  • Creating secondary axis

By the end of this course you will be able to:

  • Combine Dynamic Ranges with formulas
  • Use the ‘IF function’ to set answers based on criteria
  • Use VLOOKUP tables to find the answers to complex queries
  • Design and manage long lists of data
  • Sort, filter and subtotal lists
  • Group columns to collapse or expand a list of data
  • Link worksheets and workbooks creating summary pages

Timings: 9:30am – 4:00pm

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 | Northamptonshire Chamber of Commerce

    30/07/2024

    Mental Health First Aid

    By |Tags: |

    This 2-day 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.

  • 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 3-day 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.

  • Introduction to Microsoft Power BI | Northamptonshire Chamber of Commerce

    04/03/2025

    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.

Northamptonshire Business Awards Finalist Announcement!

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

These prestigious awards are open to all businesses across the region and are presented to businesses that have clearly demonstrated all-round business excellence in a range of areas.

Join us on Thursday 7th September where we will be announcing this year’s finalists at the Northamptonshire Business Exhibition.