Excel Intermediate is a practical, interactive one-day course designed for users who want to build on their existing Microsoft Excel knowledge and make greater use of the software's powerful features. Delegates will learn how to work more effectively with data by creating range names, linking information between worksheets, calculating percentages and applying advanced functions such as IF and SUMIF. The course also introduces the use of Autofilter to manage and analyse larger datasets efficiently.
Participants will develop their skills in organising, presenting and protecting information by creating charts, working with grouped worksheets and carrying out calculations across multiple sheets and ranges.
This course is suitable for users who already have a good working knowledge of Microsoft Excel and are looking to develop their skills further. Delegates should be comfortable creating and editing spreadsheets, using basic formulas and functions, and navigating Excel independently.
It is ideal for:
