- Courses
- Microsoft Excel
- Excel Intermediate
Microsoft Excel Training Courses For Intermediate
Excel Intermediate
Enhance your Excel proficiency in just one day with this Intermediate course. Ideal for users who are comfortable with the basics, you’ll focus on practical features that improve data analysis, formula use, and reporting efficiency. Gain greater confidence working with your organisation’s essential data.
- 1 day
- Virtual or on-site
- 3 upcoming dates
Trusted by teams at
Course overview
This 1-day Excel Intermediate training course is designed for learners who already have foundational knowledge and skills in Microsoft Excel.
Want to take your Excel skills to the next level?
Gain practical methods to analyse and present data more effectively using Excel's intermediate-level features.
After just one day, you’ll be able to use Excel to support more informed, confident decisions at work.
Delivery is available via our online public dates or as a private, tailored session for your team.
Alternatively, contact us to arrange on-site training tailored to your needs!
By the end of this 1-day instructor-led course, you’ll know how to use conditional formatting, prepare and format various types of tables, and make use of widely-used Excel formulas and functions.
Comes with our money-back guarantee and unlimited email support.
Who it's for
- Regular Excel users needing to work faster with data
- Analysts and administrators managing spreadsheets and reports
- Team leaders producing monthly metrics and dashboards
What you need before you start
- Excel experience equivalent to our Excel Introduction course
What you'll learn
What you will be able to do by the end of the course.
- Build advanced formulas with mixed and absolute references
- Work confidently with named cell ranges
- Use conditional formatting for data insights
- Create structured and formatted tables
- Apply key Excel functions, including IF, SUMIF, VLOOKUP and ROUND
- Prepare print-ready reports with headers, scaling and titles
- Organise and manage worksheets efficiently
Course outline
8 modules across 1 day.
1Excel Setup & Printing Issues4 topics+
- Headers and Footers
- Scaling Your Worksheet to Fit Page(s)
- Printing Titles on Every Page
- Previewing a Worksheet
2Excel Functions and Formulas4 topics+
- Getting Help with Functions
- Nested Functions
- Consolidating Data Using a 3-D Reference Sum Function
- Mixed References within Formulas
3Excel Most Used Functions9 topics+
- Inserting the Current Time and Date
- Today Function
- Now Function
- Round Function
- Sumif Function
- If Function
- Trim Function
- Concatenate Function
- Vlookup Function
4Excel Named Ranges3 topics+
- Naming Cell Ranges
- Removing a Named Range
- Named Cell Ranges and Functions
5Excel Cell Formatting2 topics+
- Conditional Formatting
- Custom Number Formats
6Manipulating Worksheets within Excel5 topics+
- Copying or Moving Worksheets between Workbooks
- Hiding Rows
- Hiding Columns
- Un-Hiding Rows
- Un-Hiding Columns
7Paste Special Options within Excel1 topics+
- Using Paste Special ‘Values’
8Tables10 topics+
- Preparing data for a table
- Creating a table
- Formatting a table
- Display the table total row
- Adding a row to a table
- Deleting a row from a table
- Inserting a column in a table
- Deleting a column in a table
- Renaming a table
- Advantages of a table
Dates & booking
Pick a date and book online. Prices are per person and exclude VAT.
- 8Oct
8 Oct 2026
Thursday
- Virtual
- 1 day
£325per person + VAT10% off 2 or more seats
- 10Nov
10 Nov 2026
Tuesday
- Virtual
- 1 day
£325per person + VAT10% off 2 or more seats
- 7Dec
7 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 should attend the Excel Intermediate course?+
This course is ideal for those who already have a working knowledge of Excel and want to boost their confidence with formulas, data management, and reporting. If you regularly use spreadsheets and need to work faster or more accurately, this is for you.
What topics are covered in this training?+
You’ll cover a wide range of practical topics, including conditional formatting, advanced formulas, structured tables, named ranges, key functions like VLOOKUP and IF, and essential tips for reports and worksheet management.
How is the course delivered?+
We offer live online sessions on public dates or private team courses. You can also arrange face-to-face, in-house training if you prefer something tailored to your organisation.
Do I need prior knowledge of Excel to join?+
Yes, a basic understanding of Excel is required. This course is designed for those who already know how to create basic spreadsheets and want to move beyond the basics.
Will I receive any course materials?+
Absolutely. You’ll receive a comprehensive PDF of course notes and resources to refer back to after the session.
Is there any after-course support?+
Yes, we offer unlimited email support for all delegates after the training, along with our money-back guarantee.
How long is the course and is it intensive?+
The course runs for one full day. It’s hands-on, practical and focused on skills you’ll genuinely use at work—no filler content or endless theory.
Will the course help me create better reports quickly?+
Definitely. You’ll learn techniques to structure data, format tables, and apply formulas that speed up report creation and improve accuracy.
Can the training be customised for my team?+
Yes, we regularly tailor content and delivery for teams with specific needs, priorities or systems. Let us know your requirements and we’ll build the right solution for you.
Training where your team works
Microsoft Excel training by location
See local delivery details, nearby course options and practical information for your area.
