Course Info

• Duration: 60 mins

• Level: Advanced

• Format: Onsite Training across Auckland. Nationwide Training also available, get in touch today.

Are you ready to elevate your Excel expertise? Our Level 3 Excel course will equip you with advanced tools and techniques to manage and analyse complex data more efficiently.

What you’ll learn:

• Named Ranges: Learn how to create and use named ranges for longer formulas and easier navigation.

• Data Validation: Understand how to restrict data entry in cells to certain data types using data validation.

• V-Lookup Tables: Discover how to use the VLOOKUP function to find specific data in a table using existing information as a reference, such as looking up a price list based on a product code from another table.

• If Error: Combine If Error with a VLOOKUP function to remove error messages from cells.

• X-Lookups: Replace VLOOKUPs with a bigger, better, more versatile formula available in Microsoft Excel 365.

• Pivot Tables: Get up and running with Pivot Table basics to analyse and summarise data.

Course Highlights:

• Hands-On Training: Engage in practical, hands-on exercises that ensure you can apply what you learn immediately.

• Expert Guidance: Benefit from the expertise of our seasoned trainers who will provide personalised support and feedback.

• Interactive Learning: Participate in interactive sessions that reinforce your learning through real-world examples and scenarios.

• Group Pricing: Get in touch for group pricing. 1:1 coaching also available.

Who is it for? Now that you have some Excel experience, you are ready to get to the next level with your Excel use. These are essential ‘advanced’ skills in Excel which you need for working with larger data sets. This course is perfect for anyone looking to enhance their advanced Excel knowledge and improve their efficiency.

Why Choose Us?

• Experienced Trainers: Our trainers have extensive experience in Excel and data management.

• Tailored Approach: We can customise the training to meet your specific needs and goals.

• Proven Success: Many professionals have enhanced their Excel skills through our courses.

Invest in your professional development and transform the way you work with data in Excel. Get in touch to book our Level 3 Excel course today for your team and build a strong foundation in advanced Excel skills! Get in touch for group pricing. 1:1 coaching also available. Jump in and start learning.

Pricing is based on Auckland locations, for nationwide options, please get in touch.

Contact Us to Discuss Your Unique Training Needs - need 1:1 coaching? We can help!