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. Whats 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.