Its hands-on, work-focused approach stands out: attendees practise XLOOKUPs, pivot tables, formulas and shortcuts using prepared spreadsheets and exercises, then apply them to real workplace data. They value trainers’ clear expertise, patience, humour and ability to adapt explanations and pace to different levels, while the structured progression, practical examples and take-away materials build confidence and efficiency in Excel. Some find the full day fast-paced, but still consider it highly useful.
Generated from recent reviews; may not reflect every review
About this course
Our Intermediate Excel Skills training course provides users with a smart approach to working with spreadsheet data. Giving users useful and practical techniques for working with large spreadsheets and spreadsheets that require data analysis. You will practise using a range of time-saving and accuracy-ensuring features.
What you will learn
- Fast & efficient ways of navigating, selecting and entering data
- Relative & Absolute cell addressing
- Range Names
- Automatic subtotalling
- Conditional Formatting
- Logical Functions – IF Function
- Introduction to Lookups
- Data Consolidation
- Introduction of Pivot Tables
- Protection of cells, Worksheets and Workbooks
Course video
Recent reviews
Great day training that exceeded my expectations
Great course
One of the best