- Courses
- Microsoft Excel
- Excel Advanced
Microsoft Excel Advanced Training Courses
Excel Advanced
Advance your Excel skills in this one-day course, designed for those already comfortable with spreadsheets. Gain practical tools for automating tasks, handling complex datasets, and visualising results, so you can analyse and present data with ease for your team or organisation.
- 1 day
- Virtual or on-site
- 3 upcoming dates
Trusted by teams at
Course overview
This instructor-led Excel Advanced training course builds on your prior experience to help you work more skilfully and efficiently. You’ll gain the practical know-how to automate tasks, collaborate seamlessly, and make better sense of your data.
You’ll discover how to use Excel’s most powerful features with confidence.
By mastering advanced tools such as automation, auditing and data validation, you can let Excel do the hard work while you focus on making insightful decisions. You’ll find it easier to extract clear answers from complex datasets and present your findings effectively.
Choose from our online public dates or arrange on-site training tailored to your team’s needs.
Alternatively, contact us to discuss how we can support your organisation.
For other levels, see our Introduction and Intermediate Excel courses.
Related courses are listed below.
Who it's for
- Analysts and finance professionals
- Operations and project managers
- Experienced administrators and power users
What you need before you start
- Confident use of Excel basics
- Experience with formulas and basic data analysis
What you'll learn
What you will be able to do by the end of the course.
- Build advanced formulas using nested functions and logic.
- Create and enhance PivotTables for detailed data analysis.
- Automate tasks with macros and form controls.
- Validate and clean data with advanced rules.
- Protect workbooks and manage permissions.
- Audit spreadsheets by tracing precedents and dependents.
Course outline
10 modules across 1 day.
1Pivot Tables4 topics+
- Creating and Using a Pivot Table
- Filtering and Sorting Data within a Pivot Table
- Automatically Grouping Data in a Pivot Table and Renaming Groups
- Manually Grouping Data in a Pivot Table and Renaming Groups
2Charts12 topics+
- Creating a Combined Line and Column Chart
- Adding a Secondary Axis to a Chart
- Changing the Chart Type for a Particular Data Series
- Adding a Data Series to a Chart
- Removing a Data Series from a Chart
- Re-Positioning Chart Title
- Re-Positioning the Chart Legend
- Moving and Formatting Chart Data Labels
- Modifying Chart Axis Scales
- Formatting an Axis to Display Using Commas
- Inserting Images into Chart Columns
- Inserting Images to Chart Bars
3Hyperlinks3 topics+
- Inserting a Hyperlink
- Editing a Hyperlink
- Removing a Hyperlink
4Linking & Embedding5 topics+
- What Is Embedding and Linking?
- Linking Data within a Worksheet
- Linking Cells between Worksheets within a Workbook
- Linking Data between Workbooks
- Linking Data from Excel to a Word Document
5Importing Text Files2 topics+
- What Is a Delimited Text File?
- Importing a Delimited Text File
6Sorting and Filtering Data8 topics+
- Sorting Data by Multiple Columns at the Same Time
- Applying a Pre-Installed Custom Sort
- Creating a Customized List and Performing a Custom Sort
- Removing a Customised List
- Using AutoFilter
- Using AutoFilter to Perform Multiple Queries
- Top 10 AutoFilter
- Removing All AutoFilters from a Worksheet
7Validating4 topics+
- Data Validation - Whole Number
- Data Validation - Decimal Number
- Data Validation - List
- Data Validation - Date
8Auditing7 topics+
- Tracing Precedent Cells
- Tracing Dependent Cells
- Cells with Missing Dependents
- Showing All Formulas in a Worksheet
- Inserting and Viewing Comments
- Editing and Deleting Comments
- Showing and Hiding Comments
9Macros2 topics+
- Macro to Apply a Custom Number Format
- Deleting Macros
10Passwords & Security Issues7 topics+
- Adding 'Open' Password Protection to a Workbook
- Adding 'Modify' Password Protection to a Workbook
- Removing an 'Open' Password from a Workbook
- Removing a 'Modify' Password from a Workbook
- Password Protecting Cells and Worksheets
- Hiding Formulas
- Un-Hiding Formulas
Dates & booking
Pick a date and book online. Prices are per person and exclude VAT.
- 15Oct
15 Oct 2026
Thursday
- Virtual
- 1 day
£325per person + VAT10% off 2 or more seats
- 23Nov
23 Nov 2026
Monday
- Virtual
- 1 day
£325per person + VAT10% off 2 or more seats
- 14Dec
14 Dec 2026
Monday
- Virtual
- 1 day
£325per person + VAT10% off 2 or more seats
Booking 2 or more places?
Save 10% on every seat when you book them together, subject to availability. Choose a date above, then book up to 6 seats.
Choose a datePrivate Group Training
Run this course just for your team, virtually or at your site.
Booked with a 100% money-back guarantee
Every course we run is covered. Book with confidence — if it isn’t right, you aren’t left out of pocket.
Training for your team
Run this course just for your team, on a date that suits you, virtually or at your site.
- Tailored contentBuilt around your team's work and skill levels.
- Flexible schedulingDates and times that suit your team, not ours.
- Your place or onlineDelivered at your office or virtually.
- Better value per headOne trainer, one day, your whole team.
- A dedicated trainerYour team gets all of the trainer's attention.
- Relevant examplesExercises shaped around the work your team does.
Why Future Savvy
Practical training, backed properly
Rated 4.72/5
From 696 reviews by learners and clients.
Money-back guarantee
A 100% money-back guarantee, for peace of mind.
Up to six learners
Small enough that every delegate gets trainer time on their own work.
Trainers who do the job
Practitioners who use these tools on real work, not career instructors.
Support after the course
Email your trainer when you hit something back at your desk.
What delegates say
Independently verified reviews, alongside quotes collected from delegates after their course.
I had a good experience with this Microsoft Excel training course! Mark the trainer was exceptionally knowledgeable, patient, and engaging, taking the time to explain complex functions and formulas in a way that was easy to understand. The pace of the class was well-managed, and there was plenty of opportunity to ask questions without feeling rushed. I left the session feeling much more confident, efficient, and equipped with time-saving shortcuts. Highly recommended for anyone looking to upgrade their spreadsheet skills!
good value for money, I understood notions that were very not clear to me. Thanks to Mark.
Very good communication and an excellent tutor.
Very happy with Mark's training ethos and training he provided.
Excellent course and really well presented. Starting from basic knowledge the course guided you through step by step and was well paced for all.
Really enjoyed the course. Tutor was knowledgeable, friendly and gave real-world, practical advice to get the most out of the training.
The trainer really tailored the course to our needs, encouraged us to ask questions, and was knowledgeable and really helpful.
The trainer was very patient and did not mind having to explain things a few times to make sure we were all on the same page, was very helpful for someone like myself who sometimes misses details on the first go around
Excellent trainer, the format of the training was fantastic and I got a lot from the course.
This was, by far, one of the best training courses I have had the pleasure of attending. The trainer was extremely knowledgeable and delivered a great course!
This was the first time I have joined an excel course and I found it very informative and very helpful.
I liked how the trainer tailored the training around what our needs and roles are.
A great pace for somebody just starting and never an issue with questions, and always had a good way of answering.
From knowing nothing to what I know now and in less than a day I would highly recommend as it was extremely useful, and has made my understanding of MP a 100x better. Thank you the trainer for the great lesson!
Excellent course, definitely the best 'power' course I have attended. The trainer was enthusiastic about the material and kept it relevant to our needs
The trainer was really knowledgeable and extremely helpful in helping us to build our own reports.
It was very productive as a working session. I learnt a lot.
His careful delivery of the course really made the difference not only in its usefulness but in how well we, as learners, will retain and apply this new information.
Verified reviews are published on our Reviews.io profile, where anyone can read every one of them.
Frequently asked questions
Who is the Excel Advanced course designed for?+
This course is ideal for experienced Excel users who are already confident with spreadsheets and want to master more advanced functionality, such as automation, auditing, PivotTables, macros, and secure data handling.
What practical skills will I take away from this course?+
You'll learn to create advanced formulas, automate repetitive tasks with macros, build and refine PivotTables, validate and audit data, and secure your workbooks. These skills help you work more efficiently and analyse complex data with confidence.
Is this course instructor-led or self-paced?+
Our Excel Advanced course is fully instructor-led, delivered either on-site or live online. You’ll benefit from time with an experienced trainer, plus practical exercises and tailored guidance throughout the session.
How long does the Excel Advanced course take?+
The course takes one day, with focused training that gives you extensive hands-on experience without eating into your entire week.
What are the prerequisites for attending?+
You should already feel comfortable with the basics of Excel, including formulas and basic data analysis. If you’re not quite there, you might prefer our Introduction or Intermediate Excel courses.
Do I need to bring my own laptop or software?+
If attending on-site, we can provide equipment or work with your organisation’s setup. For online training, you’ll need access to Microsoft Excel on your device. Full joining instructions are provided in advance.
Will I receive any course materials or a certificate?+
Yes, you’ll get practical reference materials for future use and a certificate of completion to confirm your achievement.
Can the course be customised for our team?+
Absolutely. We can tailor the content and pace to suit your team’s specific needs or organisational context, whether delivered on-site or remotely.
How interactive is the training?+
Expect an engaging mix of demonstrations, hands-on exercises, group discussions, and problem-solving – with plenty of opportunity for questions and real-world examples.
Training where your team works
Microsoft Excel training by location
See local delivery details, nearby course options and practical information for your area.
