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.
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
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
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.