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.uk. Chamber members can book online.
Our Upcoming The Business Toolkit Events
10 Feb 2025
Advanced Excel
04 Mar 2025
Introduction to Microsoft Power BI
08 Apr 2025
Introduction to Excel
22 May 2025
Level 2 Health & Safety in the Workplace
03 Jun 2025
Intermediate Excel
11 Jun 2025
The Fundamentals of Project Management
17 Jul 2025
Advanced Excel
16 Sep 2025
Introduction to Excel
22 Oct 2025
Intermediate Excel
13 Nov 2025
The Fundamentals of Project Management
27 Nov 2025
Level 2 Health & Safety in the Workplace
09 Dec 2025
Advanced Excel
27 Jan 2026
Introduction to Excel
25 Feb 2026
Intermediate Excel
17 Mar 2026
Advanced Excel