Excel Level 2 (Onsite)

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
Get group quote

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
Book your session

Ready to transform your skills? Let's find the perfect training solution for you.

Group Training

Perfect for teams from 3 to 16 people

Get your quote

Individual Training

One on one live sessions.

Book your session

Customised

Not sure where to start?

Talk to us
photo of a person using a headset

Why choose 365 Training Hub

We specialise in the design and delivery of digital workplace learning solutions using human-centered design, for the front line through to executive leadership teams.

  • Expert Trainers

    Our certified Excel specialists have 10+ years of corporate training experience and work with Fortune 500 companies daily.

  • Learning by Doing

    Every concept is immediately practiced with real-world datasets. No boring theory - just practical skills you'll use tomorrow.

  • Immediate Impact

    Participants report saving 5+ hours per week within their first month of applying these techniques.

Ready to transform your skills?

Let's get you the training you deserve

(optional)
(optional)
By submitting this form you agree to our Privacy Policy
Argus Fire
"I did some excel training this morning with you. I just wanted to reach out and say your delivery style was exceptional—energetic and highly interactive, which made the experience both engaging and enjoyable."
Jonathan
Eastern Institute of Technology
“We are happy to recommend the 365 Training Hub for your migration project. Their in-depth knowledge of the technology couple with a ‘people-first’ emphasis meant we achieved our goal of a painless and successful migration.”​
K. Harvey
Technical Project Leader
ADHB
Thanks so much – your presentation is slick, relaxed, inclusive and upbeat – brilliant!
Sue
attendee at General Teams Training session
RockMyBaby
Thank you for your help on this one. I thought it was a very worthwhile, high value exercise
G. Bell
Project Manager
Boxfish Research Limited
Thanks so much for customising the training for us, I believe that was really helpful and with the materials, the team can use the platform easier. Not to mention we got rid of at least two additional systems and one more in process. Such a relief!
V. Bronza
Marketing and Sales
Northern Regional Alliance Limited
The knowledge and humour were so beautifully entwined that the hour spend with you was not only an enriching experience but also one that has motivated me to use Teams to an optimum level.
R. Krishnaswamy
Attendee at a General Teams Training session

Contact Us to Discuss Your Unique Training Needs

Our courses can be delivered via live webinars or onsite training. If you’d like a customised course to address specific requirements, please reach out to us. We’re more than happy to assist. Additionally, if you have any special requests, such as needing a speaker for your next sales conference, let us know!

Let us know how we can tailor a course to target the specific training needs across your business.

Get in touch
Fill 17