Growth Essentials

Is lack of excel

skills holding

your career back?

A supportive, beginner-friendly live learning Program designed to take you from spreadsheet panic to total workplace confidence.

Excel Essentials

Is a lack of Excel skills quietly holding back your career growth? Many capable professionals spend hours manually copy-pasting data, fixing broken formulas, or dreading the moment a manager asks for a quick report. Trying to “fake it until you make it” or searching YouTube for basic fixes only leads to frustration and wasted time.

Excel Essentials is an intensive, beginner-friendly live learning program designed to replace spreadsheet anxiety with total workplace confidence. Built specifically for professionals with or without prior experience, this practical course strips away complex jargon and focuses entirely on the real-world skills you need to work faster and smarter.

Throughout this hands-on session, you will learn how to navigate spreadsheets effortlessly, clean messy data, and master essential formulas like XLOOKUP and SUMIFS without errors. We also cover time-saving shortcuts and simple visual summaries, so you can turn raw data into clean, professional reports that get noticed for the right reasons. Delivered live in small, interactive groups, this learning program ensures you get real-time answers and step-by-step guidance every step of the way. You won’t just learn theory, you will actively practice on real office scenarios, ensuring every tool you master translates directly to your daily workload.

Interested?

Ready to take the next step in your career? Complete the brief form below to register your interest, and our team will get in touch with you shortly.

Step 1

Choose Your Learning Plan

Standard

For participants with no prior experience in excel or reporting.

  • 4 Weeks, 8 Sessions
  • 2 Sessions Every Week
  • Morning, Afternoon or Evening Sessions
  • Live, Instructor-Led Sessions
  • Up to 5 Participants Per Batch

Fast-Paced

For participants with prior experience of excel
  • 2 Weeks, 4 Sessions
  • 2 Classes Every Week
  • Morning, Afternoon Or Evening Sessions
  • Live, Instructor-Led Sessions
  • Up to 5 Participants Per Batch

Program Modules

Module 1

Introduction To Excel

  • Excel Interface, Ribbon, Quick Access Toolbar, Formula Bar, Status Bar
  • Moving around cells, Selecting cells and ranges
  • New workbooks, Templates, Saving and sharing options
  • Data Entry: Entering text, numbers, dates, autofill
  • Basic Formatting: Font, cell alignment, borders, number formats
Module 2

Data Management Basics

  • Basic sort, multi-level sorting, custom sort, filter data based on conditions
  • Data Validation: Rules, dropdown lists, validation for numbers, dates, text length
  • Removing Duplicates: Identifying and removing duplicates across columns
  • Conditional Formatting: Rules for highlighting cells, colour scales, data bars, icon sets
Module 3

Essential Formulas

  • Maths:  SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, SUBTOTAL.
  • Logical: IF statements, AND, OR, nested IF.
  • Text: CONCATENATE, LEFT, RIGHT, MID, LEN, FIND, UPPER, LOWER, PROPER, TRIM.
  • Date and Time: TODAY, NOW, YEAR, MONTH, DAY, HOUR, MINUTE, NETWORKDAYS, EOMONTH.
Module 4

Working with Tables

  • Converting ranges to tables, using Table Styles, table naming.
  • Structured References: Using column names instead of cell references in formulas
  • Table Design: Adding/removing rows and columns, total row, header row
  • Working with Large Datasets: Freezing panes, splitting windows, navigating large tables efficiently
Module 5

Data Analysis with Pivot Tables

  • Pivot Tables: Setting up a Pivot Table from scratch, using different data sources
  • Filtering and Sorting in Pivot Tables: Filtering data, sorting fields within Pivot Tables
  • Grouping Data: Grouping dates, numbers, and custom groups.
  • Creating Pivot Charts: Visual representation of Pivot Table data with Pivot Charts, customizing chart options.
Module 6

Advanced Formulas

  • Using VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP (for newer versions).
  • Nested IFs: Combining IF functions with other functions (AND, OR, etc.).
  • Array: Basic array functions, working with multi-cell arrays, dynamic arrays.
  • Dynamic Named Ranges: Creating named ranges that automatically expand as new data is added.
Module 7

Data Visualisation Basics

  • Creating Charts: Selecting data for charts, types of charts (Bar, Line, Pie).
  • Customizing Charts: Changing colors, adding labels, axes options, legend
  • Sparklines: Miniature charts within cells, line, column, win/loss types
  • Advanced Chart Techniques: Combo charts, secondary axes, adjusting scales, trendlines
Module 8

Automation with Macros

  • Introduction to Macros: Understanding macros, setting up security levels.
  • Recording and Editing Macros: Recording a macro, viewing the code, making edits
  • Introduction to VBA: Basic VBA concepts, syntax, using VBA to automate tasks.
  • Automating Common Tasks: Writing simple VBA codes to automate repetitive tasks, creating buttons for automation