● Foundation to Advanced · MCT Certified

Microsoft Excel Training

A complete Excel training programme — from formulas and functions through to PivotTables, data analysis and advanced Excel. Delivered by an MCT with 17+ years of enterprise training experience.

⏱ 2 Days👥 6–30📊 25,000+ Trained🏅 MCT
📈
fx
=SUMIFS(Revenue,Region,"West",Month,"Jan")
Region
Product
Revenue
Qty
West
Alpha
₹1.4Cr
284
East
Beta
₹0.9Cr
196
North
Alpha
₹2.1Cr
422
South
Gamma
₹0.7Cr
143
PivotTable → Total by Region
West ₹4.2Cr
North ₹3.0Cr
East ₹2.0Cr
South ₹1.4Cr
0
+ Professionals Trained
0
Days Duration
0
+ Enterprise Clients
0
+ Years Excel Training

What Participants Will Master

Practical, measurable outcomes from Day 1.

📝

Formulas & Functions

VLOOKUP, XLOOKUP, IF, SUMIFS, COUNTIFS, INDEX-MATCH — the essential toolkit for any analyst.

📊

PivotTables & PivotCharts

Summarise 100,000 rows in seconds — drill down, group by date, add calculated fields.

🎨

Charts & Data Visualisation

Right chart for the data, formatting for impact, sparklines and dynamic charts.

🔄

Data Cleaning & Transformation

Remove duplicates, text functions, Flash Fill — turn messy data into clean data fast.

Data Validation & Protection

Dropdown lists, input restrictions, conditional formatting, sheet and workbook protection.

🔍

Advanced Lookup & Analysis

Power Query introduction, What-If Analysis, Goal Seek, Scenario Manager and data tables.

Who Should Attend

📊

MIS & Finance Teams

Build reports, financial models and dashboards with confidence — faster and more accurately.

📋

HR & Operations

Maintain trackers, automate attendance, analyse operational data with PivotTables.

🆕

Excel Beginners

Start from scratch and reach a level where Excel becomes a core professional skill.

📈

Intermediate Users

Advance beyond basic formulas to PivotTables, functions and data analysis techniques.

Course Curriculum

All modules — practical, hands-on labs throughout.

01

Excel Interface & Essentials

  • Navigation, keyboard shortcuts and productivity settings
  • Cell references: relative, absolute and mixed ($)
  • Entering, editing and formatting data efficiently
  • Workbook and worksheet management
  • Printing and page layout
02

Formulas & Functions

  • Arithmetic and text formulas — building blocks
  • IF, IFS, AND, OR — logical functions
  • VLOOKUP, XLOOKUP, INDEX-MATCH — lookup mastery
  • SUMIF, SUMIFS, COUNTIF, COUNTIFS — conditional aggregation
  • DATE functions: TODAY, DATEDIF, WORKDAY, NETWORKDAYS
03

Data Management & Tables

  • Sorting and filtering — advanced techniques
  • Excel Tables — structured references and auto-expand
  • Removing duplicates, text to columns, Flash Fill
  • Data Validation — dropdown lists and input restrictions
  • Conditional Formatting — rules, colour scales and data bars
04

Charts & Data Visualisation

  • Choosing the right chart type for the data
  • Formatting charts for professional presentation
  • Combo charts — bar and line on one axis
  • Sparklines — mini charts inside cells
  • Dynamic charts with drop-down selection
05

PivotTables & PivotCharts

  • Creating PivotTables from raw data
  • Grouping dates — by month, quarter and year
  • Calculated fields and calculated items
  • Slicers and Timelines for interactive filtering
  • PivotCharts — connected charts from PivotTables
06

Advanced Excel & Power Query Intro

  • Named ranges and dynamic arrays (SORT, FILTER, UNIQUE)
  • What-If Analysis: Goal Seek and Scenario Manager
  • Introduction to Power Query — cleaning and shaping data
  • Protecting sheets and workbooks
  • Excel Tips & Tricks: productivity shortcuts

Training Delivery Formats

🏢

On-Site at Your Office

Trainer travels to your location. Ideal for teams of 8–25 — maximum focus, zero travel cost for participants.

💻

Live Online (Virtual ILT)

Instructor-led training via Microsoft Teams with screen share and hands-on labs. Full trainer interaction throughout.

🔁

Modular / Split Sessions

Split across 2–3 half-days to minimise business disruption. Same content, more flexible scheduling.

Book Microsoft Excel Training

Tell us your team size and current level. We'll design the right programme for your organisation.

📊
Industry-Relevant Labs

Practice files based on your industry's actual data and reports

🎯
Level-Specific Content

Beginner, Intermediate or Advanced — curriculum adapted to your team

📋
Reference Materials

Printable formula cheat sheets and keyboard shortcut guides included

Speak to us directly

Training Enquiry