- 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.
Not sure this is the right level? Compare all Microsoft Excel training courses.
- 1 day
- Virtual or on-site
- 4 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.
- 10Nov
10 Nov 2026
Tuesday
- Virtual
- 1 day
£325per person + VAT10% off 2 or more seats
- 11Nov
11 Nov 2026
Wednesday
- 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 was really friendly and positive, really clear, and made sure everyone was on the same page, and spent individual time focusing on each person to make sure they understood and were up to speed with the training.
Overall the course was excellent. The trainer delivered well, he was knowledgeable and concise.
Overall - Brilliant though, genuinely, the trainer was informative, talked at a steady pace
asdfasdf
here is my quote text
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.
