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
Good course, would definitely reccommend
very indepth, small classes so more attention and time is spent with each person.
Really enjoyed the class and have already signed up to the next one. I especially liked how in depth it was with the ability to answer any of my queries or questions which were beyond the typical syllabus.