Excel - Intermediate Functions

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.

Location

Date

Duration

Time (AWST)

Address

Participants

Total

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

During this training course, you will explore:

Excel time-saving features
Creating advanced charts and sparklines
Attaching comments to cells
Creating efficient formulas using functions, relative and fixed references and range names
Troubleshooting formulas with worksheet auditing
Using data validation to maintain accuracy
Working with multiple worksheets
Creating calculations across worksheets and workbooks
Protecting cells, worksheets and workbooks
Creating worksheet templates.