Online Excel Intermediate 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 – 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