Online Excel & Word Beginners Self-Paced Course Bundle 

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

22+ 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.”

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 Word Stage 1 online self-paced course

Word Essentials

Are you an absolute beginner, self-taught, or had minimal formal training in Word? Do you struggle with creating and formatting documents? Look no further! This Word Essentials course is designed to give you the skills and confidence you need to become a Word master. With easy-to-follow lessons, you’ll be able to easily tackle Word documents and breeze through your work in no time. Sign up today and start your journey to Word mastery!

what you’ll learn:

  • Master the essential basics of starting Word and creating new documents with ease, giving you the confidence to take on any project.
  • Elevate the look and feel of your documents with formatting skills that will make them visually appealing and polished, impressing your audience.
  • Acquire the necessary skills to insert basic tables and organise information within your documents, making them easier to understand and follow.
  • Bring your documents to life by adding captivating symbols and images that will grab your reader’s attention, increasing engagement and impact.
  • Develop the ability to modify existing documents with ease, allowing you to save time and effort while making any necessary changes.
  • Learn how to print your documents and adjust the printing settings to get the best results, giving you a professional finish every time.

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 – First Steps 

  • Starting Word 
  • Identifying parts of the Word screen 

Module 2 – Document creation 

  • Entering text 
  • Selecting text 
  • AutoCorrect and AutoComplete 
  • Undo and Redo 
  • Spelling and Grammar 
  • Find a replacement word using Synonyms 
  • Paragraph alignment 
  • Saving a document 
  • Open an existing document 
  • Starting a new blank document 

Module 3 – Format your content 

  • Control paragraph and line spacing 
  • Single space the entire document 
  • Insert bullets and numbering 
  • Control indent settings 
  • Control tab settings 
  • Adjust tabs on the Ruler bar 
  • Format text 
  • The Format Painter tool 
  • Clear All Formatting 

Module 4 – Insert Basic Tables 

  • Insert a Table 
  • Selecting within a Table 
  • Insert and delete rows and columns 
  • Merge and split table cells 
  • Control indents, spacing and alignment 
  • Format using Table Styles 
  • Split and Merge Tables 
  • Table alignment and wrapping 

Module 5 – Insert Symbols & Images 

  • Insert symbols and special characters 
  • Insert picture files 
  • Resize and move a picture 
  • Wrap text around a picture 
  • Modify a picture 
  • Crop a picture 
  • Arrange and Rotate a picture 
  • Insert images with Snip Tools 

Module 6 – Modify a document 

  • Make a copy of an existing file 
  • Search the document using Find 
  • Replace words or phrases 
  • Rearrange text using Cut, Copy and Paste 
  • Cut, copy and paste in a Table 
  • Cut, copy and paste Pictures 
  • Adjust margins 
  • Page Breaks 
  • Page orientation 
  • Insert automatic page numbering 
  •  Spell check an entire document 
  •  Save and share as a PDF 

Module 7 – Printing 

  • Preview before printing 
  • Print settings and printing 

BONUS Module – Word 365 Online Version  

  • Log in to Word Online 
  • Orientation and document creation 
  • Format content 
  • Insert tables & images 
  • Modify a document 
  • Print and share a document 

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 & Word Stage 1
Self-Paced Courses

Whether you’re an absolute beginner, self-taught, or have some knowledge gaps, this ‘Excel and Word Stage 1 Course Bundle’ 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 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 and Word 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 & Word 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 & Word Stage 1 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 Word pro!

enrol now

I’ve created a self-paced online program that will fast-track you to becoming confident and super productive in Excel and Word, and I’m 100% confident that you’ll love it!

My self-guided online program is designed to help you master Excel and Word 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 these applications to their full potential right away. 

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

Mastering Microsoft Excel & Word Made Easy

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

$397

+gST

NZD

$694

+gST

Your 12-month membership includes:

  • One year membership to my ‘Excel Stage 1‘ course (normally $347+GST)
  • One year membership to my ‘Word Stage 1‘ 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 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? 
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.