Book a Demo

Making the most of Functions and Formulas in Excel

Kick‑start your journey towards confidently analysing and interrogating data using Excel functions

Duration 60 minutes
Level Intermediate
Completion Certificate + Badge

Course Overview

This session focuses on helping you unlock the power of functions and formulas in Microsoft Excel. It builds on foundational Excel knowledge and introduces practical techniques for analysing, combining, and forecasting data.

You will explore how functions are structured, how to use lookups and array formulas, and how to combine and filter data from multiple sources. The session also introduces what‑if analysis to help model different scenarios and outcomes.

By the end of the session, you’ll be able to write, understand, and adapt common Excel functions with confidence — saving time and gaining deeper insight into your data.

Skills Gained

Understanding Function Syntax Lookup Functions Array Formulas Combining Data Tables Forecasting with What‑If Analysis

What You’ll Learn

• How Functions Work – Understand function structure, arguments, and Excel’s built‑in guidance.
• Lookup Techniques – Use VLOOKUP and understand more robust lookup approaches.
• Working with Arrays – Apply array formulas to calculate and transform large datasets.
• Combining Data – Stack and filter tables to bring multiple datasets together.
• What‑If Analysis – Model future outcomes by changing key assumptions.

Who Is This For?

This course is perfect for:

âś“ Users with basic Excel knowledge
âś“ Anyone wanting to analyse data more effectively
âś“ Learners preparing for advanced Excel sessions

Prerequisites

Microsoft 365 account. Familiarity with basic Excel features is recommended.

Upon Completion

Digital Badge

Shareable credential for LinkedIn and professional profiles

Certificate of Completion

Official certificate to showcase your achievement

£60.00

Buy multiple seats
Scroll to Top