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

  • How to get the most out of your course
  • Download your resources
  • Tips on how to get the most out of the videos
  • Download your Cheat Sheets
  • Intro to our Learning Community

Module 1 – Introducing Excel

  • Starting Excel
  • Excel screen components
  • Workbooks and worksheets

Module 2 – Entering Data

  • Selecting and moving around the workbook
  • Entering data into the worksheet
  • Deleting and replacing data
  • Using Undo and Redo
  • Spell Check
  • Overlapping data
  • Working with columns
  • Adjusting the column width
  • Making changes to the data
  • AutoComplete

Module 3 – File Operations

  • Saving a file
  • Saving your file for the first time
  • Using Save As to make a copy of an existing file
  • Closing a file
  • Starting a new workbook (file)
  • Opening an existing workbook
  • Deleting a file you no longer need
  • Current or active workbook
  • AutoSave

Module 4 – Performing Calculations

  • Different data types
  • Creating calculations
  • Checking cell content using the Formula bar
  • Creating a formula – step-by-step
  • Calculating percentages
  • Calculating GST
  • Copying formula using the little black cross
  • Using functions
  • The Sum function
  • Average, Max, Min, and Count functions

Module 5 – Modifying the worksheet

  • Inserting, deleting, and hiding rows or columns
  • Search the workbook using Find
  • Copying calculations
  • Creating an absolute reference
  • Moving and copying information
  • Moving and copying using the mouse pointer
  • Copying an entire worksheet
  • Deleting a worksheet from a workbook
  • Using Paste Link to link data
  • Identifying linked cells
  • Replacing formulas with values

Module 6 – Formatting

  • Understanding number formats
  • Font and Alignment formatting
  • Copying formatting only
  • Format Painter tool
  • Removing formatting from a cell

Module 7 – Printing

  • Previewing your work before printing
  • Setting up the worksheet for printing
  • Inserting a page break
  • Selecting what will print
  • Setting a Print Area
  • Additional print settings

Module 8 – Intro to Sorting and Filtering data

  • Sorting data
  • Using the Sort buttons
  • Using the Data Sort command
  • Filtering data in a list
  • Applying Filters

BONUS Module – Calculate Percentages like a Pro

  • Calculating GST
  • Gross Profit Margin
  • Amount after percentage increase
  • Calculate the percentage of the total
  • Calculate one figure as a percentage of another

BONUS Module – Save Time with Excel Shortcuts

  • Navigation Shortcuts
  • Selecting Shortcuts
  • Shortcuts to Work Quickly
  • Shortcuts using your Mouse
  • Passing the Finish Line
  • (Optional) Quiz to claim your Certificate of Achievement
  • Claim your Certificate of Completion
  • A final message from Sharyn

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

  • How to get the most out of your course
  • Download your resources
  • Tips on how to get the most out of the videos
  • Intro to our Learning Community

Module 1 – Working with large tables of data

  • Tips on selecting and moving around data lists
  • Freezing row and column panes
  • Preparing the data
  • Sorting data
  • Using the Data Sort command
  • Automatically insert subtotals in sorted data
  • Removing Subtotals
  • Multiple Subtotals
  • Filtering data in a list
  • Filter and remove rows containing blanks or errors
  • Filtering using set criteria
  • Filtering troubleshooting

Module 2 – When formulas don’t calculate as expected

  • Understanding calculations
  • Why brackets are important
  • Copying calculations
  • Why do formulas copy incorrectly?
  • Creating an absolute reference
  • Naming a range
  • Creating a named range using the Name box
  • Using named ranges in formulas
  • Modifying and deleting named ranges
  • Finding named ranges within the workbook

Module 3 – Using multiple worksheets

  • Tips for working with multiple worksheets
  • Navigating worksheets
  • Selecting multiple sheets
  • Ungrouping sheets
  • Working with grouped worksheets
  • Moving and copying worksheets between workbooks
  • Linking data between worksheets and workbooks
  • Linking a range of cells
  • Identifying linked cells
  • Open, modify, or break links to a source workbook
  • Sharing workbooks containing links
  • Replace link formulas with values

Module 4 – Time-saving functions

  • Understanding functions
  • Common Math functions
  • Inserting a function
  • Editing a Function
  • IF function – check if something is true or false
  • Creating an IF function
  • IFERROR and ISERROR – ignore errors
  • SUMIF and SUMIFS – summarise data
  • COUNTIF – to summarise data
  • COUNTIFS – to summarise data
  • The EDATE function
  • SUMPRODUCT – to summarise and total data
  • The TODAY and NOW functions

Module 5 – Conditional formatting

  • Conditional formatting
  • Setting a condition with Highlight Cell Rules
  • Identifying duplicate or unique rows of data
  • The Quick Analysis Tool
  • Setting a condition based on cell content
  • Setting a new rule based on a formula
  • Creating Data Bars and Colour Scales
  • Applying Icon sets
  • Managing Rules
  • Clearing Rules

Module 6 – Intro to recording macros

  • Using macros
  • Opening a macro-enabled workbook
  • Recording a macro
  • Running a macro
  • Saving macros
  • Adding a macro button to the Quick Access toolbar
  • Absolute or relative macro
  • Assigning a macro to a macro button
  • Copying macros
  • Deleting a macro stored in the active workbook
  • Deleting a macro stored in the Personal Macro workbook

Module 7 – Protecting

  • Protecting worksheets and workbooks
  • Unlocking cells
  • Protecting a worksheet
  • Protecting a workbook
  • Setting a password to open or modify a worksheet

BONUS Module – New Microsoft 365 functions

  • IFS function
  • FILTER function
  • FILTER with multiple criteria
  • SORT function
  • SORT and FILTER function
  • SORTBY function
  • UNIQUE function + drop-down menus
  • Fixing SPILL and CALC errors

Passing the Finish Line
Claim your Certificate of Completion
A final message from Sharyn

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.

Getting Started

  • How to get the most out of your course
  • Download your resources
  • Tips on how to get the most out of the videos
  • Intro to our Learning Community

Module 1 – Importing And Saving Text Files

  • What is a text file?
  • Opening a csv file into Excel
  • Saving an imported file as an Excel file
  • Exporting data from Excel as a text file

Module 2 – Use Lookup Functions To Cross-Reference Data

  • Understand lookups
  • Vertical lookups VLOOKUP
  • Horizontal lookups using the HLOOKUP
  • Two-way lookups with MATCH and INDEX
  • Flexible lookups with XLOOKUP

Module 3 – Preparing Data For Reporting

  • Preparing data to ensure lookups work
  • Using Conditional Formatting to identify duplicate data
  • Managing Rules
  • Removing duplicate rows of data
  • Conditional Formatting plus Filter
  • Remove Duplicates
  • Using Find and Replace
  • Converting cell formats using the Error Indicator
  • Pulling part of a text field
  • Convert text to a value without the Error Indicator
  • Split a single column of text into several columns
  • Removing unnecessary spaces using TRIM
  • Change the case of your text
  • Insert leading zeros
  • Replacing a formula with its result

Module 4 – Creating Dynamic Tables

  • Using the Tables feature
  • Inserting and formatting a Table
  • Automatic Freeze panes
  • Resizing the Table range
  • Tables Filtering and Slicers
  • Creating a calculated column
  • Analysing your data using a Total Row
  • Using the Table name in a formula
  • Removing a Table from a data range

Module 5 – Pivot Tables

  • Creating a Pivot Table report
  • Understanding PivotTable components
  • Managing Grand and Subtotals
  • Creating a Custom Name for the Value field
  • Controlling how data is summarized
  • Controlling Number formats
  • Placing multiple fields in the Values area
  • Displaying data as a percentage
  • Filtering the data
  • Individual Pivot Tables by field
  • Displaying detail
  • Grouping data
  • Sorting and Top 10
  • Creating your own formulas
  • Creating Calculated Fields
  • Styles for Pivot Tables
  • Refreshing the data
  • Resetting the data source

Module 6 – Pivot Charts

  • Creating Pivot Charts
  • Changing the chart design and layout
  • Adding elements
  • Hiding the field buttons
  • Changing the PivotChart format
  • Creating a combination chart

Passing the Finish Line
Claim your Certificate of Completion
A final message from Sharyn

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!

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!

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 1course (normally $347+GST)
  • 12-month membership to my Excel Stage 2course (normally $347+GST)
  • 12-month membership to my Excel Stage 3course (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.

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.