Microsoft Excel Functions

All courses can be delivered as is, or we can customise a training program so your team completes the exact topics they need in the number of days that suits your organisation.

You are currently viewing the Functions course page, but you can easily explore the other Excel courses using the links below.

Core Excel Courses

• Microsoft Excel Introduction – Learn the fundamentals of creating, editing, formatting, and managing spreadsheets, with a strong focus on accuracy, good design, and practical everyday use.
• Microsoft Excel Intermediate – Build more productive workbooks using formulas, functions, advanced formatting, charts, tables, and analysis tools such as Goal Seek and Quick Analysis.
• Microsoft Excel Advanced – Work with complex data, including PivotTables, data consolidation, advanced filtering, validation, protection, macros, and collaboration features.

Specialist Excel Courses

• Microsoft Excel Functions (on this page!) – Work confidently with logical, lookup, financial, statistical, text, and date functions.
• Microsoft Excel Data Analysis Add‑Ins – Analyse and visualise data using Power View, Power Pivot, Get & Transform, and Power Map.
• VBA for Excel – Automate Excel processes and build custom solutions using VBA.

The Microsoft Excel Functions course is a specialist program designed for users who already understand the basics of formulas and want to work more confidently and efficiently with Excel functions. This course focuses on applying a wide variety of built‑in functions to solve real‑world calculation and data analysis problems.

Participants learn how to use logical, lookup, mathematical, statistical, financial, text, date, and information functions effectively. The course is highly practical and is ideal for anyone who regularly works with formulas and wants to improve accuracy, consistency, and efficiency in their spreadsheets.

In this course, you will learn how to:

• Use logical functions to test conditions and control results
• Apply lookup and reference functions to retrieve data dynamically
• Use mathematical and statistical functions to solve complex problems
• Apply financial functions for common calculations
• Work with date and time functions
• Manipulate data using text functions
• Use information functions to test and validate worksheet data

When you partner with CTO for onsite or customised Microsoft Excel training, you receive a learning experience designed specifically for your team. We focus on the Excel skills that matter to your work, your data, and your level of experience — no generic content and no time wasted.

Here’s what our clients value most:

• Training tailored to your needs – whether you follow a structured Excel learning pathway or select specific topics relevant to your business.
• Experienced, engaging facilitators who specialise in Microsoft Excel and bring real‑world examples to every session.
• Hands‑on, practical learning that builds confidence and equips your team to apply their skills immediately.
• A supportive and enjoyable experience — our trainers are known for making complex Excel concepts clear, logical, and approachable.

We bring training directly to your team, ensuring the content aligns with your systems, processes, and real-world Excel usage.

About Corporate Training Options

For over 30 years, Corporate Training Options has helped organisations across Australia build capability, improve productivity, and get more value from their software tools. Our customised approach ensures your team gains the right skills, in the right way, for long‑term success.

Whether you want a single Microsoft Excel course or a tailored multi‑level training program, we’re here to help.

Call us on 1300 667 660 to design the perfect training solution for your team.