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
30/07/2024
Mental Health First Aid
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.
13/11/2024
Emergency First Aid at Work
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.
10/04/2024
Introduction to Excel
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.
21/05/2024
Level 2 Health & Safety in the Workplace
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.
10/10/2024
Level 2 Health & Safety in the Workplace
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.
13/05/2024
Intermediate Excel
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.
23/05/2024
Advanced Excel
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.
15/10/2024
Intermediate Excel
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.
19/11/2024
Advanced Excel
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.
20/01/2025
Intermediate Excel
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.
10/02/2025
Advanced Excel
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.
06/06/2024
Emergency First Aid at Work
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.
19/06/2024
Powerspeak – Public Speaking & Presentation Skills
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.
12/09/2024
Diversity Dynamics
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.
06/02/2025
Powerspeak – Public Speaking & Presentation Skills
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.