New: Gemini July — Free Gemini training for your whole team in July →
Skip to content
Live LearningCo
For IT Teams
Drive adoption & reduce tickets
For Learning Teams
Scale training without headcount
Policy to Practice
Turn AI policies into capabilities
Technology Migration
Dedicated rollout support
Gemini July
Free Gemini training — July 2026
Microsoft Month
Free Microsoft training — May 2026
LMS Integration
Courses
Live Learning
ScheduleTrainers
Learning for Good
Free training for VCSE organisations
BlogCase Studies
PricingAbout
Free TrialBook a Demo
Live LearningCo

Live expert training for enterprise teams. Close the gap between software investment and real adoption.

Solutions
  • For IT Teams
  • For L&D Teams
  • Policy to Practice
  • Technology Migration
  • LMS Integrations
  • For Enterprise
  • Pricing
Courses
  • Microsoft 365
  • Google Workspace
  • AI & Copilot
  • View All
Company
  • About
  • Careers
  • Case Studies
  • Blog
  • Contact
  • Learning for Good
© 2026 Live LearningCo. All rights reserved.
Privacy PolicyTermsCookies
HomeCoursesMicrosoft ExcelMaking the most of Functions and Formulas in Excel
Microsoft Excel

Making the most of Functions and Formulas in Excel

1 hour
Live
All levels
Next: TBA
Book a SessionRequest Team Booking

About this course

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

You might also like

Browse all courses
Using Pivot Tables in Excel

Using Pivot Tables in Excel

1 hourLive
Gaining Steam in Excel: An Intermediate Guide

Gaining Steam in Excel: An Intermediate Guide

1 hourLive

Upcoming live sessions

No upcoming sessions scheduled yet. Get in touch to arrange a session for your team.

Request a Session

Frequently asked questions

Next Session
TBA
Book a SessionRequest team booking
Live interactive session
Expert certified trainer
Certificate of completion

Need help?

Not sure if this course is right for your team? Our learning specialists can help.

Chat with an expert
Getting Started with Excel

Getting Started with Excel

1 hourLive