Online Excel Beginners Self-Paced Course

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