- Courses/
- Microsoft Excel/
- Excel Intermediate/
Microsoft Excel Training Courses For Intermediate
Excel Intermediate
Enhance your Excel skills with our 1-day Excel Intermediate course. You will learn advanced formulas, named ranges, data analysis, and conditional formatting. An ideal choice if you already have basic Excel knowledge. This course will empower you to make data-driven decisions.
Virtually Online Or On-Site
1 Day
Next Running:
3rd September
Expert Trainers
Small Class Sizes
Rated 4.8/5 by learners
Money-Back Guarantee
Why Choose Training with
Future Savvy?
Trusted by top UK Organizations
From NHS teams to FTSE 100 companies, over 1,000 professionals have trusted Future Savvy to upskill their teams with results-driven training.
Real Experts, not Just Instructors
Our courses are delivered by seasoned professionals with real-world experience using the tools they teach, not just theory, but practical insight.
Small Class Sizes for Big Impact
Our class sizes are intentionally small, usually no more than 6, to ensure every learner gets personal attention and time with the trainer.
Hands-on, Interactive Learning
You won’t just sit and watch, you'll get stuck in with practical exercises, real scenarios, and immediate feedback from your trainer.
Ongoing Support, even after the Course
Have questions after the training? We’re still here. All delegates get unlimited post-course email support at no extra cost.
100% Satisfaction Guarantee
We stand by the quality of our training. If you're not completely satisfied, we'll give you a full refund.
Course Information —Excel Intermediate.
Course Information
This 1-day Excel Intermediate training course is designed for learners who already have foundational knowledge and skills in Microsoft Excel.
Want to take you Excel skills to the next level?
We will teach you how to take advantage of some higher-level functionality in Excel in order to analyse and present data more effectively.
After just one day, you’ll be able to leverage the power of data analysis and presentation to make informed and intelligent decisions for your organisation.
Choose from our online public courses dates to book your course today.
Alternatively, contact us to arrange on-site training tailored to your needs!
Course requirements
Learners should have used Excel before and be familiar with creating basic formulas, using Autofill along rows or columns and working with Absolute Cell References (e.g. $C$5) to refer to fixed figures – such as VAT rates or performance targets.
Still need to grasp the basics? Get started with our 1-day Excel Introduction course.
What you will learn
After completion of the Excel Intermediate training course you be will be able to:
- Create advanced formulas
- Work with named ranges
- Analyse data by using functions and conditional formatting
- Organise and analyse datasets and tables
- Manipulate worksheets
By the end of this 1-day instructor-led Excel Intermediate course, you’ll know how to use things like conditional formatting, prepare and format all manner of Excel tables. What's more, you will have an in-depth understanding of the most used Excel functions and formulas.
All with our 100% Money-Back Guarantee and Unlimited Email Support.
1
Excel Setup & Printing Issues
- Headers and Footers
- Scaling Your Worksheet to Fit Page(s)
- Printing Titles on Every Page
- Previewing a Worksheet
2
Excel Functions and Formulas
- Getting Help with Functions
- Nested Functions
- Consolidating Data Using a 3-D Reference Sum Function
- Mixed References within Formulas
3
Excel Most Used Functions
- Inserting the Current Time and Date
- Today Function
- Now Function
- Round Function
- Sumif Function
- If Function
- Trim Function
- Concatenate Function
- Vlookup Function
4
Excel Named Ranges
- Naming Cell Ranges
- Removing a Named Range
- Named Cell Ranges and Functions
5
Excel Cell Formatting
- Conditional Formatting
- Custom Number Formats
6
Manipulating Worksheets within Excel
- Copying or Moving Worksheets between Workbooks
- Hiding Rows
- Hiding Columns
- Un-Hiding Rows
- Un-Hiding Columns
7
Paste Special Options within Excel
- Using Paste Special ‘Values’
8
Tables
- 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
UpcomingCourses
Wednesday3rd September
1 Day
£275.00
EX. VAT
Wednesday8th October
1 Day
£275.00
EX. VAT
Wednesday5th November
1 Day
£275.00
EX. VAT
Wednesday3rd December
1 Day
£275.00
EX. VAT
Friday9th January
1 Day
£275.00
EX. VAT
Friday6th February
1 Day
£275.00
EX. VAT
Friday6th March
1 Day
£275.00
EX. VAT
Friday10th April
1 Day
£275.00
EX. VAT
Friday8th May
1 Day
£275.00
EX. VAT
Friday12th June
1 Day
£275.00
EX. VAT
Friday10th July
1 Day
£275.00
EX. VAT
Friday14th August
1 Day
£275.00
EX. VAT
Thursday10th September
1 Day
£275.00
EX. VAT
Wednesday7th October
1 Day
£275.00
EX. VAT
Wednesday11th November
1 Day
£275.00
EX. VAT
Wednesday9th December
1 Day
£275.00
EX. VAT
Private courses.
We’ll help you meet your company training needs with instructor-led business skills and IT training courses, or your money back. Take courses in our UK classrooms or online - it’s your choice!
Tailored
Post Course Support
Cost Effective
You’re in Good Company
You’re in Good Company
Over 1,000 professionals from industry-leading brands have chosen Future Savvy for their training needs.
RelatedCourses
Excel and Power BI Data Modelling
Master the essentials of data modelling with our Excel and Power BI Data Modelling Training Course. This comprehensive course covers Power Query, Power Pivot, and Power BI, equipping you with the tools to clean, structure, and visualise your data effectively. Gain the skills to build powerful data models, create impactful reports, and make smarter decisions for your business.
Virtually Online Or On-Site
2 Days
Excel Power Query Introduction
This one-day Excel Power Query Introduction course is ideal for anyone looking to simplify data cleaning and transformation. Learn how to filter, transform, and consolidate data from various sources to create streamlined workflows and actionable insights.
Virtually Online Or On-Site
1 Day
Next Running:
11th November
Excel VBA Introduction
Boost your Excel skills with our Future Savvy 2-day Excel VBA course. Learn to automate spreadsheets, record macros, edit VBA code, and create custom forms. Perfect for gaining control and developing dynamic applications. Unlock the potential of workbooks and worksheets with hands-on guidance. Ideal for simplifying repetitive tasks and enhancing your Excel capabilities.
Virtually Online Or On-Site
2 Days
Registered England and Wales: 11477692 VAT Number: GB 3123317 52All trademarks are owned by their respective owners. Click here for details.
