๐ŸŽ“ AI World: 2-Day Generative AI Masterclass โ€” Starts at just โ‚น4,999. Seats filling fast! ๐Ÿ“… 22โ€“23 Aug 2026 ยท Navi Mumbai Register now →
● 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
25000
+ Professionals Trained
2
Days Duration
500
+ Enterprise Clients
17
+ 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