Excel 365 Functions & Formulas
Intermediate and advanced Excel 365 skills for analysts, finance, HR, and operations professionals.
Program overview
Excel 365 Functions & Formulas moves teams beyond basic spreadsheets into modern Excel capability. Participants work with dynamic arrays, cleaner formula design using LET, reusable LAMBDA functions, and models that scale with real business reporting needs.
Ideal for professionals who already use Excel and need stronger analytical and automation-ready skills.
Learning outcomes
- Master dynamic array functions
- Simplify formulas using LET
- Create reusable LAMBDA functions
- Build scalable Excel models
- Apply advanced case studies
Who this is for
- Data analysts and business professionals
- Finance, HR, Operations, and reporting specialists
- Advanced Excel users and internal trainers
HRDC claimable · Available as public or in-house training
Why organisations choose this program
Strong Excel capability reduces manual work, improves reporting accuracy, and speeds decision support. Teams that rely on spreadsheets daily gain immediate operational value from modern functions and cleaner models.
Especially useful for finance, HR, operations, and any function that builds recurring reports or dashboards in Excel.
Delivery options
- Standard module — request the brochure and program details
- Customised version — adapt exercises to your data and workflows
- In-house corporate run — scheduled for analysts and reporting teams