Computer Skills

Excel - Intermediate Functions


Well-structured formulas make it easier to analyse information, perform calculations and work accurately with data in Excel.

This practical one-day course expands your knowledge of Microsoft Excel functions and formula structure. You will work with relative and absolute cell references, named ranges, common functions, Insert Function and formula auditing tools.

New Course Icon
Location
Date
Duration
Time (AWST)
Address
Participants
Total

What to expect

You will work through practical examples to understand how formulas and functions are structured. You will apply relative and absolute references, create named ranges and use a range of functions for calculating, counting, looking up, rounding and working with dates.

The course also introduces the Insert Function feature and formula auditing tools. These features can help you locate suitable functions, check how formulas work and troubleshoot common errors.

Is this course for you


This course is for anyone who is comfortable with basic Excel and wants to create and use formulas with greater confidence. It is suited to people who use Excel for day-to-day calculations and want to strengthen the structure and accuracy of their work.

This course is suited to individuals who want to

  • create clearer and more accurate formulas

  • understand relative and absolute cell references

  • use named ranges to make formulas easier to manage

  • apply common functions to workplace data

  • locate suitable functions using Insert Function

  • check formulas and troubleshoot errors

What you will explore

During this training course, you will develop skills in building structured, reliable Excel formulas. The course focuses on referencing, named ranges and the use of functions within formulas, helping participants work more accurately and efficiently with business data.

This course offers the opportunity to:

  • Create well-structured formulas using relative and absolute referencing and named ranges

  • Understand and use functions within formulas

Where this course can take you

During this training course, you will explore relative and absolute cell referencing, named ranges and how to use them in formulas, and the structure of formulas and functions. You will learn to calculate totals using AutoSum and apply functions for calculations, analysis, lookups, rounding and dates.

The course also covers the Insert Function feature and formula auditing tools, giving you practical skills to check formulas and troubleshoot errors with greater confidence.

Related Results


Level - Advanced

Designed for users who work with complex or repetitive data tasks, this course shows you how to use Power Query to connect, clean and reshape information before analysing it in Excel.

You’ll learn to automate data preparation, apply transformation steps and work confidently with the M language.


Level – Fundamental. 

If you’re new to Microsoft Project, this course helps you plan and track work with confidence.

You will learn how to set up schedules, allocate resources and monitor progress so your projects stay organised and on track.


If you want to feel more confident using Microsoft Teams day to day, this course helps you navigate chats, channels, files and meetings with ease.

You will learn practical tools that support clearer communication and smoother teamwork.


Level – Fundamental.

If you want your presentations to look clearer and more polished, this course helps you build the practical design skills to create slides that communicate with impact.

You will learn how to structure layouts, use templates effectively and enhance content with data visuals and multimedia elements that support clear, engaging communication.

size? 4 newAIMWASpecialCourse, aIMWACoursePage, aIMWACoursePage
Courses - Frequently Asked Questions

Get answers to common queries.

FAQs