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 focuses on expanding your knowledge of Microsoft Excel’s functions and understanding how to write well-structured formulas.

Location

Date

Duration

1 Day

Time (AWST)

Address

Participants

Total

What to expect

The Excel - Intermediate Functions course will help you to create well-structured formulas using relative and absolute referencing and named ranges. It will help you to understand and use various functions in formulas, including the Insert Function feature.

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

During this training course, you will develop practical Excel skills to work more efficiently, create impactful visuals and improve data accuracy and security. The course focuses on using time-saving shortcuts, advanced charting tools, data validation techniques and linking data across worksheets to support reliable, professional reporting.

By the end of this training course, you should be able to:

Create well-structured formulas using relative and absolute referencing and using named ranges.
Understand and use functions within formulas.

Where this course can take you

During this training course, you will explore Excel time-saving features and learn how to create advanced charts and sparklines to present data clearly. You will develop skills in relative and absolute cell referencing, named ranges, and building efficient formulas using functions, relative and fixed references and range names.

The course also covers a broad range of functions including SUM, AVERAGE, IF, COUNTIF, SUMIF, VLOOKUP, XLOOKUP, ROUND and more, as well as AutoSum and the Insert Function feature. You will learn to troubleshoot formula errors using worksheet auditing, apply data validation, work across multiple worksheets and workbooks, protect cells and worksheets, and create reusable worksheet templates.