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

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.