Course description
Microsoft Excel Level 2 Ninjas
Ascend to Excel Mastery: Microsoft Excel Level 2 Ninjas
Ready to transform from Microsoft Excel novice to Microsoft Excel ninja? Imagine Training's Microsoft Excel Level 2 Ninjas is the course for your team.
This Excel Level 2 training session equips you with advanced techniques to conquer even the most complex Microsoft Excel spreadsheets. Become a true Microsoft Excel master by mastering:
- Multi-File & Worksheet Management: Effortlessly manipulate multiple files and worksheets simultaneously.
- 3D Formula Power: Unlock the secrets of 3D formulas for advanced calculations.
- Cell Linking Expertise: Link cells across spreadsheets with ease and edit links efficiently.
- Data Entry Acceleration: Master special number formats to streamline data entry and save valuable time.
- Data Visualisation Prowess: Learn to condense large worksheets for clear data summarisation and create impactful charts with just one click using hidden formulas!
- Navigation Agility: Navigate your spreadsheets with lightning speed and pinpoint the information you need.
Join our expert trainers and embark on your journey to Microsoft Excel Level 2 mastery!
Upcoming start dates
Suitability - Who should attend?
Who is this for?
This TWO HALF DAY course is specifically designed for office staff/managers with some previous knowledge of Excel, and is designed to take you to the next level. Mistakes can be reduced if you use the tools that come with Excel and check your work.
Training Course Content
- You’ll get the upper hand by knowing how to create a table in one click so you can easily sort and filter your data.
- Take your charting skills to a professional level by learning how to use 5 key types of charts and manipulate them to show off your data!
- How to save time using special number formats and working with functions to format text.
- We’ll show you how to use multiple workbooks and link them to save replication and keep data up to date. You’ll also learn the magic of 3-D formulas.
- Tired of creating the same documents over and over again? Learn how to simply create templates you can use repeatedly.
- Learn the benefits of Pivot Tables and feel like a Jedi Master of Excel!
- How to save time using special number formats and working with functions to format text.
- See the advantages of creating and using range names in your spreadsheets and how to manage them.
Request info
Imagine Training
Welcome to Imagine Training, empowering businesses through comprehensive Microsoft 365 training with a particular emphasis on Excel Training. As we navigate through the rapidly evolving digital age, our mission is to ensure your organisation not only keeps pace but excels....