(08) 9383 8000
Excel - Intermediate
Level - Intermediate
Move beyond the basics and streamline your work.
Designed for people who want Excel to work faster and smarter, this course introduces tools and techniques that improve efficiency, accuracy and presentation.
You’ll learn how to use time-saving features, create stronger visuals and manage data across multiple sheets and workbooks.
What to expect
Excel offers many features that can significantly improve your workflow once you move beyond the basics. This course builds your ability to apply shortcuts, structure formulas well and use formatting tools that make your spreadsheets clearer and more reliable.
You will explore advanced charting options, including sparklines, and practise using data validation to keep information accurate. Named ranges, relative and absolute references and worksheet auditing tools help you create efficient formulas and troubleshoot issues quickly. You’ll also learn how to work confidently with multiple worksheets and workbooks, link data for more consistent reporting and protect your files to keep information secure.
By the end of the course, you will be equipped with practical skills that make everyday Excel tasks faster and more effective.
Is this course for you
This course is ideal for people who already use Excel but want to improve efficiency, accuracy, and presentation when working with data.
This course is suited to individuals who want to:
-
work more efficiently with Excel data
-
improve accuracy in data handling and analysis
-
present data clearly and professionally
-
apply practical techniques to everyday Excel tasks
What you will explore
By the end of this training course, you should be able to:
- Apply Excel shortcuts and time-saving tools
- Create advanced charts and sparklines for visual impact
- Protect worksheets and workbooks to secure your data
- Use relative and absolute references to structure formulas
- Apply data validation for accuracy and reliability
- Link data across worksheets and workbooks for better reporting.
Where this course can take you
Level – Advanced.
If you work with long or detailed documents, this course builds the skills to structure, format and manage them with confidence.
You will learn how to keep reports consistent, add references and produce polished, professional outputs.
Level – Advanced.
If you want to save time and standardise your documents, this course builds the skills to create templates, forms and simple macros that streamline everyday work.
You will learn practical tools that improve consistency and reduce repetitive tasks.
Level - Intermediate.
Strengthen your ability to analyse and calculate with Excel.
Designed for those ready to move beyond the basics, this course shows you how to use formulas and functions that make your spreadsheets smarter and easier to work with.
You’ll learn how to structure formulas well, use named ranges and troubleshoot errors so your calculations stay accurate and reliable.
Use Microsoft 365 Copilot to work more efficiently across documents, emails, meetings and data.
This course helps non-technical professionals apply Copilot inside familiar Microsoft 365 tools, with a focus on useful prompts, careful review, privacy awareness and responsible workplace use