Online Excel Stages 1-2-3 Course Bundle

Go from Beginner to Pro with this Guaranteed Confidence-Boosting Program

33+ hours of easy-to-follow video

Microsoft Excel Stage 1 online self-paced course

excel essential skills

Are you an absolute beginner or tired of feeling unsure and ‘winging it’ when it comes to 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 update with tips and tricks to avoid frustrations.
  • Get a handle on file management and avoid common “gotcha” situations.
  • Build confidence in creating formulas and performing common math functions easily, 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.”
  • BONUS module: Master calculating percentages like a pro and apply them effortlessly in your everyday tasks.
  • BONUS module: Unlock time-saving Excel shortcuts to streamline your workflow and boost productivity.

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  
  • Join our Learning Community for extra support  
  • 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  

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 

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

BONUS Module – Calculate Percentages like a Pro

Master percentage calculations with ease.  

  • Calculate GST  
  • Work out Gross Profit Margin  
  • Apply percentage increases  
  • Calculate percentages of totals and comparisons  

BONUS Module – Save Time with Excel Shortcuts

Work faster with essential keyboard and mouse shortcuts.  

  • Navigate and select data efficiently  
  • Use shortcuts to speed up everyday tasks  

Passing the Finish Line 

Celebrate your achievement and wrap up your learning journey.  

  • Complete a short 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.
  • Eliminate repetitive tasks and save time by recording Macros for common actions such as setting column widths, deleting rows and columns, etc.
  • Protect shared files to prevent unauthorised changes and ensure only those with permission can open, update, or modify them.
  • BONUS module: Learn the latest Microsoft 365 functions that will take your Excel skills to the next level, and see why subscribing to Microsoft 365 is a must-have.

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  
  • Join our Learning Community for extra support  
  • 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  

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 – Intro to Recording Macros

Automate repetitive tasks and save hours of work.  

  • Record and run macros to streamline processes  
  • Save macros for future use  
  • Add macro buttons to the Quick Access Toolbar  
  • Assign macros to buttons for one-click automation  
  • Understand absolute vs relative macros  
  • Include macro buttons in shared files  
  • Copy or delete macros when needed  

Module 7 – 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  

BONUS Module – 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. 

  • 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 like 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 make your data come 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.

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  
  • Join our Learning Community for extra support  
  • 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 

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 

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.  

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

Excel Stage 1, 2 & 3 Self-Paced Courses

Looking to become an Excel Pro? Look no further than this ‘Excel Stages 1, 2 & 3 Course Bundle’! This comprehensive bundle is designed to help you master Excel quickly and easily. 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 business, this course is delivered by an expert instructor who will guide you through every step of the way!

buy now

complete each course in 4 weeks or less

With approximately 11 hours of video content, each course is designed with a 4-week plan for those who prefer a structured approach. However, with 12 months of access, you have the flexibility to take your time and revisit the material as needed to continue refining your skills.

unlimited help along the way

Sign up today and receive a welcome email with all the information to get started immediately. I’m here to support you, ensuring you get the best guidance possible. If you need help, just email me. I’m committed to making your Excel journey smooth and stress-free!

Earn a certificate of completion

Congratulations, you did it! After completing your training, you’ll receive a Certificate of Completion. Starting at Excel Stage 1? Test your knowledge with my fun quizzes. Keep trying until you score 100% and earn a Certificate of Achievement for each course to display proudly.

access to our private Facebook community

When you sign up for my Excel Stage 1, 2 & 3 course bundle, you also gain access to our private Facebook community. Here, you can find additional resources, connect with others, ask questions, and get expert support to help you succeed as a Excel pro!

enrol Now

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!

My self-guided online program is designed to help you master Excel quickly and easily, without all the stress and frustration. And the best part? I guarantee that you’ll see results so you can start using Excel to its full potential right away.

So don’t wait, join now and let’s get you on your way to becoming a pro in Excel!

Collection of devices with different parts of the Excel at Work Excel self-paced online courses being displayed with captions.

Mastering Microsoft Excel Made Easy

  • 12-month membership to my ‘Excel Stage 1‘ course (normally $347+GST)
  • 12-month membership to my ‘Excel Stage 2‘ course (normally $347+GST)
  • 12-month membership to my ‘Excel Stage 3‘ course (normally $347+GST)
  • Comprehensive step-by-step downloadable workbooks
  • Downloadable exercise files to follow along with the step-by-step videos
  • Done for you templates and cheat sheets
  • Access to our members-only Facebook Community
  • A Certificate of Completion
  • Invites to attend bonus live sessions with your course tutor (worth over $1,500+GST)
  • Unlimited support from your expert tutor

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 have done this.  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 used my skills already, which has made life much much easier. I thought I knew Excel well before this, but there were so many new things I learned as well, 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 doing this course, it suited my way of learning, both audio 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 the fact that I can do refreshers and easily look up lessons up 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

Unlock your Excel potential today!

Just a heads up, this course is designed for use on Windows PC and may not be compatible with the Mac version.

NZD

$497

+gST

NZD

$1041

+gST

Your 12-month membership includes:

  • One year membership to my ‘Excel Stage 1‘ course (normally $347+GST)
  • One year membership to my ‘Excel Stage 2‘ course (normally $347+GST)
  • One year membership to my ‘Excel Stage 3‘ course (normally $347+GST)
  • Comprehensive step-by-step downloadable workbooks
  • Downloadable exercise files to follow along with the step-by-step videos
  • Done for you templates and cheat sheets
  • Access to our members-only Facebook Community
  • A Certificate of Completion
  • Invites to attend bonus live sessions with your course tutor (worth over $1,500+GST)
  • Unlimited support from your expert tutor

The Excel bundle price is in New Zealand dollars and is exclusive of the Goods and Services Tax.

Looking to give your team the tools they need to excel? 
Contact me for my special group discounts! We can supply a GST invoice, payable in 7 days, for any businesses who would prefer this method of purchasing for their team members.

buy now

Get Your Ultimate Course Info Pack!

  • Detailed pricing and money-saving bundles
  • Full course duration and content breakdown
  • Exclusive team booking benefits and community details
  • Live sessions, certificates, and money-back guarantee

100% Satisfaction Guarantee

My 60-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. To qualify, you must have completed all of the modules.