Course Info
Duration: 60 mins
Level: Intermediate
Format: Onsite Training across Auckland. Nationwide Training also available, get in touch today.
Are you ready to take your Excel skills to the next level? Our Level 2 Excel course will equip you with advanced tools and techniques to manage and analyse data more efficiently.
What you’ll learn:
Working with Dates: Learn how to manage and manipulate date data in Excel.
Conditional Formatting: Understand how to apply conditional formatting to highlight important data.
Using Colour to Understand Data: Discover how to use colour to make data more understandable and visually appealing.
Linking Data: Learn how to link data across different worksheets and workbooks.
Creating Formulas Across Worksheets: Master the skill of creating formulas that span multiple worksheets.
If Statements: Understand how to use If Statements for conditional logic.
Conditional Statements: Learn to create and use various conditional statements.
Count Ifs and Sum Ifs: Discover how to use Count Ifs and Sum Ifs to count and sum data based on multiple criteria.
Creating Charts: Learn how to create charts to visually display your data.
Sparkline Charts: Discover how to create micro-charts contained in a single cell to provide quick visual insights.
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. Training available across Auckland. For nationwide onsite visits, please get in touch to discuss your needs.
Who is it for? This course is perfect for people who spend a lot of time in Excel and need to fill in the gaps on how to work more effectively. Whether you’re looking to update your skills or learn new techniques, this course will provide you with the tools you need to succeed.
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 2 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.
Contact Us to Discuss Your Unique Training Needs - need 1:1 coaching, we can help!
Choose your training format
We offer flexible learning options to fit your needs.
Group Training
Perfect for teams of 3+ people
- Interactive team exercises
- Collaborative problem-solving
- Cost-effective for organisations
- Shared learning experience
- Custom scenarios for your industry
1:1 Personal Coaching
Tailored training for individuals
- Personalised attention and pace
- Focus on your specific challenges
- Flexible scheduling around your calendar
- Work with your actual datasets
- Follow-up support included
