Microsoft Excel Essentials for Supervisors & Managers

Duration: ~ 8 hours | Fee: PROMO🔥

Training Objective:

Participants will learn essential Excel (Windows version) skills to manage, prepare, analyse, and work with business data more effectively. Through practical use of Excel Functions, Power Query, PivotTables, PivotCharts, Slicers, and time-saving Excel techniques, participants will improve their productivity, produce clearer reports, gain useful business insights, and support better decision-making.

Training Outcome:

Participants will be able to use essential Excel functions to retrieve and manage data, use Power Query to prepare and transform data, and use PivotTables, PivotCharts, and Slicers to analyse and report business information. They will also apply practical Excel techniques and shortcuts to work more efficiently, improve productivity, and support data-driven decision-making.

Module 1 

Essential Excel Functions

• VLOOKUP, XLOOKUP

• IF, OR, AND

Module 2

Power Query for Data Preparation & Reporting

• The Basic Power Query in Action

• Extract

• Transform

• Load the data for Analysis & Reporting

Module 3

Smart Data Analysis & Visualisation 

• Analyse Business Data using PivotTables

• Create PivotCharts for Business Reporting

• Perform Interactive Analysis using Slicers

• Identify Trends, Patterns and Business Insights

Module 4

Time Saving Excel Tips & Tricks

• Excel Tables: The Smarter Way to Manage Data

• Clean Data Instantly with Text to Columns Feature

• Time-Saving Excel Shortcuts Every Leader Should Know