Microsoft Excel Intermediate Training in New Zealand

  • Learn via: Online Instructor-Led / Classroom Based / Onsite
  • Duration: 2 Days
  • Level: Intermediate
  • Price: From €1,490+VAT
  • Upcoming Date:
  • UK Based Global Training Provider

The goal of this course is to provide you with the knowledge required to use more advanced formulas and work with various tools to analyse data in spreadsheets, such as advanced sorting and filtering, and conditional formatting. You will also organise table data and present data in different visuals, such as charts and maps.

The course emphasises hands-on experience, with a series of self-guided exercises integrated into the training.

We can organize this training at your preferred date and location. Contact Us!

Prerequisites

This course is aimed at existing Excel users who need to further their knowledge. Delegates are assumed to have experience of entering data and writing basic formulas, including common functions such as SUM and AVERAGE.

What You Will Learn

  • Use formula-related tools and techniques.
  • Work with popular Excel functions.
  • Use advanced data list features and Excel tables.
  • Create visuals representing data, using charts and sparklines.
  • Apply and use conditional formatting.
  • Utilise the capabilities of dynamic arrays to improve your formula writing

Training Outline

Module 1: Formula tools and techniques

  • Quick analysis.
  • Absolute and mixed referencing.
  • Working with range names.
  • Linking to other worksheets.
  • Linking to external workbooks.

Module 2: Popular Excel functions

  • Understanding functions.
  • Criteria-based functions.
  • Logical functions.
  • Lookup and reference functions.
  • Dynamic array functions.

Module 3: Working with data lists

  • Flash fill.
  • Advanced sorting.
  • Summarising with subtotals.
  • Advanced filters.

Module 4: Mastering Excel tables

  • Introducing tables.
  • Creating and managing tables.
  • Calculation and totals in tables.
  • Formatting a table.
  • Further table tools.

Module 5: Creating Visuals

  • Understanding charts
  • Creating a chart
  • Resizing and moving
  • Managing a chart
  • Working with chart elements
  • Formatting charts
  • Working with chart templates
  • Creating maps from Geographic data
  • Creating Infographics with Excel add-ins
  • Analyse data with sparklines

Module 6: Conditional formatting

  • Applying and managing conditional formatting.
  • Creating custom conditional formatting.
  • Sorting and filtering by colour.

Why Choose Us

Experience live, interactive learning from the comfort of your home or office with Bilginç IT Academy's Online Instructor-Led Microsoft Excel Intermediate Training in New Zealand. Engage directly with expert trainers in a virtual environment that mirrors the energy and schedule of a physical classroom.

  • Live Sessions: Join scheduled classes with a live instructor and other delegates in real-time.
  • Interactive Experience: Engage in group activities, hands-on labs, and direct Q&A sessions with your trainer and peers.
  • Global Expert Trainers: Learn from a handpicked global pool of expert trainers with deep industry experience.
  • Proven Expertise: Benefit from over 30 years of quality training experience, equipping you with lasting skills for success.
  • Scalable Delivery: Accessible worldwide, including New Zealand, with flexible scheduling to meet your professional needs.

Immerse yourself in our most sought-after learning style for Microsoft Excel Intermediate Training in New Zealand. Our hand-picked classroom venues in New Zealand offer an invaluable human touch, providing a focused and interactive environment for professional growth.

  • Highly Experienced Trainers: Boost your skills with trainers boasting 10-20+ years of real-world experience.
  • State-of-the-Art Venues: Learn in high-standard facilities designed to ensure a comfortable and distraction-free experience.
  • Small Class Sizes: Our limited class sizes foster meaningful discussions and a personalized learning journey.
  • Best Value: Achieve your certification with high-quality training and competitive pricing.

Streamline your organization's training requirements with Bilginc IT Academy’s Onsite Microsoft Excel Intermediate Training in New Zealand. Experience expert-led learning at your own business premises, tailored to your corporate goals.

  • Tailored Learning Experience: Customize the training content to fit your unique business projects or specific technical needs.
  • Maximize Training Budget: Eliminate travel and accommodation costs, focusing your entire budget on the training itself.
  • Team Building Opportunity: Enhance team bonding and collaboration through shared learning experiences in your workspace.
  • Progress Monitoring: Track and evaluate your employees' progression and performance with relative ease and direct oversight.


Contact us for more detail about our trainings and for all other enquiries!

Available Training Dates

Join our public courses in our New Zealand facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

We can organize this training at your preferred date and location.
07 April 2026 (2 Days)
Auckland, Wellington, Christchurch €1,490 +VAT
24 April 2026 (2 Days)
Auckland, Wellington, Christchurch €1,490 +VAT
27 April 2026 (2 Days)
Auckland, Wellington, Christchurch €1,490 +VAT
11 May 2026 (2 Days)
Auckland, Wellington, Christchurch €1,490 +VAT
26 May 2026 (2 Days)
Auckland, Wellington, Christchurch €1,490 +VAT
14 June 2026 (2 Days)
Auckland, Wellington, Christchurch €1,490 +VAT
28 June 2026 (2 Days)
Auckland, Wellington, Christchurch €1,490 +VAT
08 July 2026 (2 Days)
Auckland, Wellington, Christchurch €1,490 +VAT

New Zealand, with vibrant and rapidly growing tech communities in Auckland, Wellington, and Christchurch, is carving out a global niche in innovative software solutions and specialized niche technology markets. The nation’s commitment to digital readiness is backed by the research excellence of the University of Auckland and Victoria University of Wellington, focusing on areas like Creative-tech, Agritech, and Health-tech innovation. New Zealand offers a unique and forward-thinking environment for digital learning, where agility and creative problem-solving are highly valued in the professional landscape. Our IT education services in New Zealand focus on high-demand skills such as Web Development, Agile Project Management, and Information Security. We provide the tools and expertise necessary for Kiwi professionals to lead technological change in an economy that prioritizes sustainability, innovation, and global connectivity.

By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.