Online Excel Beginners Self-Paced Course

Unlock Your Excel Potential with this Guaranteed Self-Paced Confidence-Boosting Program

11+ 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

Excel Stage 1
Self-Paced Course

Look no further! Whether you’re an absolute beginner, self-taught, or have some knowledge gaps, this ‘Excel Essential Skills – Stage 1’ course is perfect for you! Tailored specifically for New Zealand business, this self-paced online course is delivered by an expert instructor who will guide you through every step of the way!

buy now

complete in 4 weeks or less

With approximately 11 hours of video content, this 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 a fun quiz. Keep trying until you score 100% and earn a Certificate of Achievement to display proudly.

access to our private Facebook community

When you sign up for my Excel Stage 1 course, 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 an Excel pro!

I’ve created a self-paced online program that will fast-track you to becoming confident and super productive in Excel, 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 at 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 online self-guided ‘Excel Essential Skills – Stage 1’ course
Comprehensive step-by-step downloadable workbook
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 and a Certificate of Achievement
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 to 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

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 of Excel.

NZD

$347

+gST

Your 12-month membership includes:

One year membership to my online self-guided ‘Excel Essential Skills – Stage 1’ course
Comprehensive step-by-step downloadable workbook
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 and a Certificate of Achievement
Unlimited support from your expert tutor

Course price is in New Zealand dollars and exclusive of Goods and Services Tax

Looking to give your team the tools they need to excel in Excel?
Contact me for my special group discounts!