Online Excel Course NZ – Work Smarter with Confidence

Learn Excel online with practical skills you can use at work. Go from beginner to confident at your own pace.

Delivered by Sharyn Baines. Trusted by workplaces and teams across New Zealand

What is the Best Online Excel Course in NZ?

The best online Excel course is one that helps you build real skills you can use immediately. The Excel at Work Learning Hub gives you step-by-step video lessons, practical examples, and a place to get answers quickly whenever you get stuck.

You may have just searched for something like “what is the best online Excel course in NZ?” — and you’re probably looking for something that actually helps you at work, not just another course you never finish.

It’s not just a course — it’s your go-to place for Excel help. Instead of trying to remember everything, you can search the Learning Hub anytime and find answers instantly. That means you can solve problems faster, work more efficiently, and feel confident knowing what you’re doing.

From $59/month, you get ongoing access to everything — lessons, answers, and support. Try it risk-free with a money-back guarantee.

Start Learning Excel Today

Cancel anytime. No messy contracts

Is this you?

  • You use Excel in your work, or you’re just getting started and want to build your skills the right way.
  • You’ve learned bits and pieces over time and worry that there are gaps in your understanding.
  • You’d love to confidently say you’re a Beginner, Intermediate, or Advanced user — and mean it.
  • Sometimes you need quick help now; other times you want to build skills properly.
  • Copilot sounds useful, but you’re not always sure when to trust it.
  • You want to reduce Excel errors and rework — without sending staff on generic courses.

If that sounds like you, you’re in the right place.

Meet the Excel at Work Learning Hub

The Excel Learning Hub is an online self-paced Excel training membership designed for people who use Excel at work—in offices, on sites, in schools, in small businesses, and everywhere in between.

Inside the Hub, you’ll transform:

  • From overwhelmed to organised: Structured learning that replaces random guessing with true spreadsheet mastery.
  • From stuck to solved: Fast, topic-specific lessons that rescue your workflow exactly when things break.
  • From searching to knowing: Powerful, curated search tools that eliminate hours of frustrating Google searches.
  • From stranded to supported: Constant expert help ensuring you are never left to struggle by yourself.
Start your Membership

Only $59/mo. Cancel anytime • No pressure

A clear Excel skill pathway employers understand

This pathway mirrors how employers typically describe Excel capability — Beginner, Intermediate, and Advanced.

Inside the Hub, your skills are organised into:

Excel Stage 1
Beginner

Excel Stage 2
Intermediate

Excel Stage 3
Advanced

  • Each stage builds naturally on the one before.
  • You can complete a full stage or dip into specific lessons when needed.
  • Resume-Ready Credentials: Earn CPD-relevant Certificates of Completion for Stages 1, 2, and 3.
  • Prove Your Expertise: Ace the final short quiz to secure your formal Certificate of Achievement.

“I’ve created a self-paced online program that will fast-track you from Beginner to Excel Pro in no time, and I’m 100% confident that you’ll love it!” – Sharyn Baines, Certified Microsoft® Office Specialist

Microsoft Excel Stage 1 online self-paced course

Excel essential skills

Are you an absolute beginner, or tired of feeling unsure and ‘winging it’ with Excel? My Excel Stage 1 self-paced course is designed specifically for individuals like you who are totally new to Excel, have been self-taught or have received bits and pieces of training from multiple sources. My course will help fill in the gaps in your knowledge and give you the confidence you need to excel in Excel. Don’t let your lack of formal training hold you back any longer. This Stage 1 course is perfect for you!

What you’ll learn:

  • Learn how to create a spreadsheet from scratch and easily navigate the Excel screen.
  • Master the art of data entry and updates with tips and tricks to avoid frustrations.
  • Get a handle on file management and avoid common “gotcha” situations.
  • Build confidence in creating formulas and easily performing common math functions, including calculating totals, averages, GST, and percentages.
  • Discover the power of formatting and layout and learn how to copy, move and organise data between worksheets.
  • Add some flair to your data with formatting techniques, and understand the importance of number formatting.
  • Say goodbye to printing headaches by mastering the ins and outs of printing and avoiding common mistakes.
  • Learn how to sort and filter data like a pro and avoid common pitfalls that can cause a “train wreck.”
  • Cut down Excel effort by using Copilot to create, check, and format your work faster.

Getting Started

Set yourself up for success before diving in.  

  • Learn how to get the most out of your course  
  • Download your resources and cheat sheets for quick reference  
  • Tips for making the most of the videos
  • Learn how to join our live group meetups with Sharyn  

Module 1 – Introducing Excel

Get comfortable with Excel and its interface.  

  • Start Excel and explore the workbook and worksheet layout  
  • Understand the key parts of the Excel screen  
  • Learn how Excel organises data for easy navigation  

Module 2 – Entering Data

Enter, edit, and organise your data accurately and efficiently. 

  • Select and move around your workbook with ease 
  • Enter, delete, and replace data quickly 
  • Use Undo and Redo to fix mistakes instantly 
  • Check spelling to maintain accuracy 
  • Handle overlapping data without losing information 
  • Adjust column width for a clean, readable layout 
  • Insert or resize columns to fit your data 
  • Make changes to existing data without breaking your layout 
  • Speed up entry with AutoComplete 

Module 3 – File Operations

Save, open, and manage your workbooks with confidence.  

  • Save your file for the first time and create copies with Save As  
  • Open existing workbooks and start new ones  
  • Delete files you no longer need  
  • Understand the active workbook and AutoSave in Microsoft 365  

Module 4 – Performing Calculations

Build accurate formulas and perform essential calculations.  

  • Understand different data types and why brackets matter  
  • Create formulas step by step  
  • Calculate percentages and GST  
  • Copy formulas using AutoFill for speed  
  • Use functions like SUM, AVERAGE, MAX, MIN, and COUNT  
  • Check and fix calculations using the Formula Bar  
  • Use AutoFill to generate dates and sequences quickly 
  • Practise with real-world exercises to reinforce learning
  • Copilot assistance with formulas  

Module 5 – Modifying the worksheet

Edit and organise your worksheets like a pro.  

  • Insert, delete, and hide rows or columns  
  • Unhide hidden rows and columns  
  • Search and replace data quickly  
  • Move and copy information using the mouse or commands  
  • Copy entire worksheets  
  • Lock cell references with absolute references  
  • Replace formulas with values for fixed results  
  • Use Paste Link for dynamic updates 

Module 6 – Formatting

Make your data clear, consistent, and easy to read. 

  • Control number formats so your data displays correctly and formulas work as expected 
  • Apply font and alignment formatting for a professional look 
  • Copy formatting only where needed using the Format Painter 
  • Quickly remove unwanted formatting to restore a clean layout
  • Use Copilot to quickly apply professional formatting 

Module 7 – Printing

Print your worksheets without surprises.  

  • Set up print areas and adjust print settings 
  • Control page breaks and scaling so your data prints neatly across the correct number of pages 
  • Preview and print for professional results  

Module 8 – Sorting and Filtering

Organise and analyse your data quickly.  

  • Sort data using simple and advanced options for better insights 
  • Filter your list to show only the rows that meet your criteria 
  • Hide blanks, errors, or irrelevant data to keep your view clean 
  • Use custom filters to drill down to specific information 
  • Combine sorting and filtering for powerful data analysis

Passing the Finish Line 

Celebrate your achievement and wrap up your learning journey.  

  • Complete a quiz to claim your Certificate of Achievement 
  • Claim your Certificate of Completion to showcase your new skills  
  • Enjoy a final message from Sharyn with tips for your next steps  

Microsoft Excel Stage 2 online self-paced course

Excel organise and analyse data

Once you know the basics, you’re ready to take your skills to the next level and master time-saving features to organise and analyse data. Whether you’re looking to boost your productivity or impress your boss, I’ll teach you the shortcuts and techniques you need to master Excel and work smarter, not harder. This Stage 2 course is perfect for you!

What you’ll learn:

  • Master the art of organising and analysing large tables of data with the efficient data tools Sort, Filter and Subtotal, plus learn tricks and tips to ensure you avoid making a mess of your data.
  • Learn how to fix and avoid “rubbish” calculations and copy formulas perfectly.
  • Learn to read and create the most popular Excel functions used in a business environment. Unlock a new set of powerful tools and boost your confidence.
  • Create dynamic worksheets that automatically apply Conditional Formatting as your data changes, perfect for alerts and notifications.
  • Protect shared files to prevent unauthorised changes and ensure only those with permission can open, update, or modify them.
  • Learn the next generation of Microsoft 365 functions that will take your Excel skills to the next level, and see why subscribing to Microsoft 365 is a must-have.
  • Cut down Excel effort by using Copilot to create, check, and format your work faster.

Getting Started

Set yourself up for success before diving in.  

  • Learn how to get the most out of your course  
  • Download your resources and cheat sheets for quick reference  
  • Tips for making the most of the videos
  • Learn how to join our live group meetups with Sharyn

Module 1 – Working with Large Tables of Data 

Manage and analyse big data lists with ease.

  • Quickly select and navigate large datasets  
  • Freeze rows and columns to keep headers visible  
  • Prepare data for accurate sorting and filtering  
  • Use Flash Fill to split or combine data automatically  
  • Sort data by one or multiple levels  
  • Automatically insert and manage subtotals  
  • Insert multiple subtotals for grouped analysis  
  • Filter data to focus on what matters  
  • Remove blanks and errors from your lists  
  • Create custom filters for specific criteria  
  • Troubleshoot filtering issues  

Module 2 – When Formulas Don’t Calculate as Expected

Correct formula errors and ensure your calculations are accurate and reliable.  

  • Understand how Excel calculates (and why brackets matter)  
  • Refresh your knowledge of BEDMAS for accurate formulas  
  • Copy formulas correctly without breaking references  
  • Create absolute references to lock cells  
  • Practise absolute references with real examples  
  • Use named ranges for easier, error-free formulas  
  • Modify, delete, and find named ranges across your workbook

Module 3 – Using Multiple Worksheets 

Work smarter across multiple sheets and workbooks.  

  • Navigate and manage multiple worksheets efficiently  
  • Group and ungroup sheets for bulk updates  
  • Move or copy sheets between workbooks  
  • Link data between sheets and files for dynamic updates  
  • Identify, update, or break links when needed  
  • Troubleshoot broken links  
  • Replace link formulas with values to lock results  

Module 4 – Time-Saving Functions 

Speed up your work with powerful Excel functions.  

  • Understand and insert functions with confidence  
  • Use IF functions to check conditions  
  • Create nested IF statements for complex logic  
  • Combine conditions with AND and OR functions  
  • Handle errors with IFERROR and ISERROR  
  • Summarise data with SUMIF, SUMIFS, COUNTIF, and COUNTIFS  
  • Calculate totals with SUMPRODUCT  
  • Work with dates using EDATE, TODAY, and NOW
  • Use Copilot for formula assistance and insights  

Module 5 – Conditional Formatting

Highlight key insights and spot issues instantly.  

  • Apply rules to highlight important data  
  • Identify duplicates or unique values  
  • Create custom rules using formulas  
  • Combine Conditional Formatting with filters and sorting  
  • Add visual impact with Data Bars, Colour Scales, and Icon Sets  
  • Manage and clear rules for clean formatting  

Module 6 – Protecting Your Work

Keep your data safe and prevent unwanted changes.  

  • Unlock and protect specific cells  
  • Protect worksheets and workbooks  
  • Make workbooks read-only  
  • Add passwords to control access  
  • Understand the limits of Excel protection  

Module 7 – New Microsoft 365 Functions 

Unlock the latest Excel tools for smarter, faster work.   

  • Use IFS for multiple conditions  
  • Filter data dynamically with FILTER  
  • Apply multiple criteria in FILTER  
  • Sort and filter together for powerful analysis  
  • Apply SORTBY for advanced sorting  
  • Create unique lists with UNIQUE (and drop-down menus)  
  • Fix SPILL and CALC errors like a pro  

Passing the Finish Line 

Celebrate your achievement and wrap up your learning journey. 

  • Complete a quiz to claim your Certificate of Achievement 
  • Claim your Certificate of Completion to showcase your new skills 
  • Enjoy a final message from Sharyn with tips for your next steps 

Microsoft Excel Stage 3 online self-paced course

Excel Data Analysis & Pivot Tables

In this course, you will learn how to avoid spending countless hours on data clean-up, preparation, and reporting. Improve your workflow with advanced Excel tools such as lookup functions and Pivot Tables.

These powerful tools will streamline your data analysis and reporting process. Don’t waste any more time. Upgrade your Excel toolbox today! 

What you’ll learn:

  • Learn how to import CSV or TXT files and format them to suit your needs with ease.
  • Master Excel’s most popular Lookup functions, VLOOKUP and XLOOKUP, INDEX, and MATCH, and discover a host of tips, hints, and complementary functions that will have you creating look-ups like a pro.
  • Get a handle on cleaning data, and learn how to prepare your data for optimal performance with various functions and reporting features in Excel.
  • Discover the time-saving benefits of Excel’s Table feature, and learn how to create dynamic ranges and multi-functional lists that will save you from having to reset your ranges again.
  • Effortlessly generate impactful Pivot Table reports and provide your team with the crucial data they need.
  • Chart your data with Pivot Charts and bring it to life. With a couple of clicks, you can create stunning charts that will elevate your reports and presentations.
  • Create smarter worksheets using Data Validation to guide user input, reduce errors, and keep your data clean and consistent — all with just a few clicks.
  • Unleash the power of Power Query to quickly clean, transform, and combine your data from multiple sources — saving hours of manual work and supercharging your reporting.
  • Cut down Excel effort by using Copilot to create, check, and format your work faster.

Getting Started

Set yourself up for success before diving in.  

  • Learn how to get the most out of your course  
  • Download your resources and cheat sheets for quick reference  
  • Tips for making the most of the videos  
  • Learn how to join our live group meetups with Sharyn  

Module 1 – Importing and Saving Text Files

Learn how to confidently import, clean, and save text files without losing data or formatting. 

  • Understand what text files are and when to use them 
  • Control how CSV files open in Excel to avoid formatting issues 
  • Import fixed-width text files accurately 
  • Save imported text files as Excel workbooks for easier editing 
  • Export Excel data as text files for sharing or system uploads 

Module 2 – Use Lookup Functions to Cross-Reference Data

Master lookup functions to quickly find and match information across your spreadsheets. 

  • Understand how lookup functions work and when to use them 
  • Use VLOOKUP to find and return data from another list 
  • Compare two lists of data using VLOOKUP 
  • Control VLOOKUP results and avoid common errors like #N/A 
  • Perform horizontal lookups with HLOOKUP 
  • Create flexible two-way lookups using MATCH and INDEX 
  • Combine MATCH and INDEX for dynamic row and column lookups 
  • Use XLOOKUP for more powerful and flexible lookups 
  • Replace older functions with XLOOKUP for easier, error-free formulas 
  • Handle approximate matches and advanced lookup scenarios 
  • Join text values to look up multiple criteria in one formula
  • Lookup function assistance with Copilot

Module 3 – Preparing Data for Reporting

Fix common data issues so your reports and formulas work perfectly.

  • Prepare data so formulas and lookups work correctly  
  • Find and remove duplicate data  
  • Highlight errors and duplicates using Conditional Formatting  
  • Convert numbers stored as text into real numbers  
  • Split text in one column into multiple columns  
  • Combine content from multiple cells using text joining functions  
  • Remove unnecessary spaces—even the tricky ones TRIM can’t catch  
  • Clean text further using SUBSTITUTE for unwanted characters  
  • Check text length with LEN to validate data  
  • Change text case to proper, upper, or lower  
  • Add leading zeros without breaking your data  
  • Extract specific text using functions like LEFT, RIGHT, MID, TEXTBEFORE, and TEXTAFTER  
  • Clean and transform messy data instantly using smart tools like Flash Fill and Copilot for Excel  

Module 4 – Creating Dynamic Tables

Turn your data ranges into dynamic tables for easier analysis, filtering, and reporting. 

  • Insert and format tables to make your data easier to manage 
  • Resize tables as your data grows or shrinks 
  • Use built-in filters and slicers for quick, interactive analysis 
  • Apply filters to view subtotals and focus on key data segments 
  • Create calculated columns for automatic, consistent formulas 
  • Add a Total Row to summarise your data instantly 
  • Use structured references and table components for dynamic formula updates and seamless PivotTable refreshes 
  • Practise using table references in multiple formula scenarios 
  • Convert a table back to a normal range when needed 

Module 5 – Pivot Tables

Summarise, analyse, and present your data with powerful PivotTable tools. 

  • Create PivotTables to summarise large datasets quickly 
  • Understand PivotTable components and customise the layout 
  • Manage Grand Totals and Subtotals for transparent reporting 
  • Create custom names for Value fields for better readability 
  • Control how data is summarised and formatted 
  • Apply number formatting for professional reports 
  • Place multiple fields in the Values area for deeper analysis 
  • Display data as percentages to show comparisons 
  • Filter data using filters, slicers, and timelines 
  • Generate individual PivotTables by field with one click 
  • Drill down to display underlying detail 
  • Group data by categories, dates, or time periods 
  • Sort data and highlight the Top 10 values 
  • Create your own formulas using PivotTable data 
  • Add Calculated Fields for custom calculations 
  • Apply styles for a polished, professional look 
  • Refresh PivotTables to update with new data 
  • Reset the data source when your dataset changes
  • Copilot Pivot Table assistance 

Module 6 – Pivot Charts

Visualise your PivotTable data with clear, dynamic charts. 

  • Create PivotCharts to bring your data to life 
  • Change chart design and layout for better storytelling 
  • Add chart elements for clarity and impact 
  • Hide field buttons for a cleaner look 
  • Format PivotCharts for a professional finish 
  • Create combination charts for comparing different data series 

Module 7 – Data Validation

Control data entry and create user-friendly spreadsheets.  

  • Create drop-down lists to simplify data entry 
  • Use data validation to prevent incorrect entries 
  • Edit, copy, and delete validation settings easily 
  • Create dynamic drop-down lists that update automatically 

Module 8 – Power Query

Combine and transform data from multiple sources in minutes. 

  • Build one report from several CSV files in a folder 
  • Combine and report on data from multiple Excel files 
  • Append and consolidate data from multiple worksheets 

Passing the Finish Line 

Celebrate your achievement and wrap up your learning journey.  

  • Complete a quiz to claim your Certificate of Achievement 
  • Claim your Certificate of Completion to showcase your new skills 
  • Enjoy a final message from Sharyn with tips for your next steps   
Start your membership

Pay monthly, or save with an annual subscription

You don’t just watch – you practice

Every lesson includes exercise files, step-by-step follow-along guidance, the ability to pause, replay and practise safely.

With a focus on practical skills and real-world applications, you’ll go from beginner to pro in no time. Whether you’re looking to improve your productivity at work or just want to become an Excel wizard, this bundle is perfect for you.

Tailored specifically for New Zealand businesses, this course is delivered by Sharyn Baines, an expert instructor who will guide you through every step of the way!

buy now

Complete each course in 4 weeks or less

Each course is approximately 11-hours of video content. If you want to fast-track, you can download structured learning plans to fit the course into your everyday routine and complete it in 4 weeks. However, with a 12-month membership, you can also take your time and revisit anything whenever you need.

Unlimited help along the way

Sign up today and receive a welcome email to get started straight away. Alongside your courses, you’ll have access to additional support, including help from me, a powerful search tool, an AI chat assistant, workbooks, cheat sheets, and my YouTube videos without the ads. If you get stuck, just email me — I’m here to help!

Quizzes for all levels

Perfect for working out where to start and earning your Certificate of Achievement. You can begin with a quick quiz to see where you’re at — if you score 100%, you’ll receive your certificate straight away. If not, I’ll send you a personalised report showing exactly what to focus on, so you know where to put your time and effort. After completing your training, you’ll receive a Certificate of Completion with additional course details, ideal for CPD and professional development records.

Invites to Live Online Excel Meetups

When you sign up for my Excel course bundle, you’ll receive invites to my live online Excel meetups. These sessions give you the opportunity to learn, ask questions, and get extra tips and guidance. If you can’t attend live, that’s absolutely fine — you can watch the replay at a time that suits you. All session replays are stored inside the learning platform, so you can come back to them whenever you need a refresher.

What’s included?

  • My Excel Stage 1, 2 and 3 self-paced courses (value $590)
  • Topic‑specific short courses for bite‑sized learning (value $149 each)
  • Live meetups + replays with exercise files (value $199 each)
  • Powerful search that jumps to the exact moment in a video
  • Exercise files for every lesson
  • Resource Library: workbooks, quick reference cards, shortcut sheets, learning plans
  • Certificate of Completion with CPD relevance for Stage 1, 2, and 3
  • Quizzes for all levels – perfect for working out where to start and earning your Certificate of Achievement
  • Ongoing updates as Excel/Microsoft 365/Copilot evolve
  • Ad‑free access to my most‑watched YouTube lessons inside the Hub
Start Learning Today!

Cancel anytime • No pressure

Start producing results!
Just like these Excel at Work students…

  • I am so appreciative and privileged to have worked through this new, beneficial skill that I so needed to learn many, many years ago, and I have had this wonderful opportunity to do so.  This is obviously not the end of learning all the wonderful things about Excel; it is the beginning 🙂 Thank you so much, Sharyn. You have been inspiring to say the least; it has been fun and, of course, rewarding.
    I will endeavour to continue practising this worthwhile and beneficial skill.
    Merrin Joseph
    Administrator
  • Thank you so much for the wonderful online Excel course. Your teaching approach was wonderful, encouraging, calm and very clear (tone). You were very encouraging and precise on what is important to remember and learn. Loved it, and I have already used my skills, which has made life much, much easier. I thought I knew Excel well before this, but I learned so many new things, like filtering. This is really cool. This is just one of the many things I learned. Thank you again.
    Mati Itonga
    Self Employed
  • Sharyn is incredible at teaching you all you need to know about Excel. The courses are user-friendly, with good resources and exercises. I would definitely recommend Excel at Work and am looking forward to signing up for the next course.
    Rebecca Burgess
    HR Advisor / Payroll Consultant
  • This course totally rocks! It is amazing, exactly what I was looking for. I can learn at my own pace, and your videos are so clear and easy to follow. So THANK YOU!!

    LORINDA MOCHRIE
    Financial Services Manager
  • I really enjoyed taking this course; it suited my learning style, both auditory and visual.  I found it advantageous to be able to go over lessons again when I didn’t fully understand the more difficult stages.  I like that I can take refreshers and easily look up lessons at any time. I highly recommend this course over sitting in a classroom and cramming for a day or two.  I also enjoy attending Sharyn’s live workshops and receiving her email Super Tips. 
    Rosemary Quensell
    Investment Assistant

Membership options

  • $59 NZD/month – cancel any time*
  • $590 NZD/year – best value

* Pay monthly, cancel anytime – no contracts, no lock-ins.

Prices in NZD and inclusive of GST.

Start your Online Excel membership

Contact Sharyn to ask about annual subscription options:

  • purchasing by GST invoice
  • special group discounts

100% Satisfaction Guarantee

My 14-day money-back guarantee. If you complete the course and don’t feel it was worth your investment, I’ll give you a full refund. Just let me know why, and I’ll take care of it.

FAQs

Q: Do I need the Copilot license to use Copilot with Excel?

A: No. You’ll learn Excel first, properly. I then teach you how to use Copilot where it helps, with guidance on getting the most from the free and paid versions.

Q: I’m not a beginner — will I still learn something new?

A: Yes. Many members already know the basics but quickly improve how they work with data — creating cleaner spreadsheets, stronger lookups, and formulas that don’t break. A short quiz helps you pinpoint the best place to start, so you’re not wasting time on things you already know.

Q: Can my company pay by invoice?

A: Yes — team access and GST invoicing are available for 12-month memberships. Please get in touch.

Q: What if I fall behind?

A: No stress. The Hub is always available and always up to date. Learn at your pace; join live when you can.

Q: Does this work on Mac?

A: The content is recorded on Windows Excel (Microsoft 365). Many of my students use Mac and have been more than happy with the course content. Jump in and have a look around. If you aren’t happy, use my money-back guarantee, and I’ll happily refund you, no questions asked.

Q: Will I be told when something changes?

A: Yes. When I add a new video or update a lesson, I’ll let you know so you can choose whether and when to watch.

Q: Are the certificates endorsed by Microsoft

A: No — certificates are issued by Excel at Work, not Microsoft. They support professional development and CPD but are not Microsoft‑endorsed. If you need a Microsoft certification, please visit Microsoft Learning.

Q: Do you offer a diploma?

Excel at Work doesn’t offer a Diploma. We provide practical skills, Certificates of Completion/Achievement, CPD‑ready course details, and ongoing support so you can apply what you learn at work.