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 would thoroughly recommend this course to anyone. It has completely refreshed me up to the latest excel practices and will help me be much more efficient in my daily working life.
Super helpful course. The information was at the right level, but our trainer was great about checking in and making sure that we were understanding everything.
I was unsure going into this training how much I would take away and I could not be happier with how much and what I learnt and will be taking the level 3 course