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
I feel more ready for my new role at Marex!
Overall, great experience! Excellent trainer, funny and engaging, this training will definitely help me in my job, specially when I do reporting every month. It will definitely make my job a little easier!
Overall, I have really enjoyed today, left the course with lots of new knowledge I can practise and start to implement at work. Thank you Chris for a fantastic Excel training day.