+91 120 4208068 +91 9217299244
Module - Advanced Excel

Master Advanced Excel

Become an Excel power user. Learn Pivot Tables, VLOOKUP, HLOOKUP, VBA Macros, and create stunning Dashboards for data-driven decision making.

4 Days Training
15+ Topics Covered
5+ Advanced Functions
=VLOOKUP(A2, Data!B:D, 3, FALSE)
→ Returns matching value from column 3
4-Day Curriculum

Advanced Excel Learning Path

Master Excel from basics to advanced automation with our comprehensive day-by-day curriculum

Day 01

Excel Overview, Formatting & Basic Formulas

Microsoft Excel Overview
Formatting Excel Worksheets
Essential Shortcuts
Basic Formulas (SUM, AVG, COUNT)
' Basic Formulas
=SUM(A1:A10)
=AVERAGE(B1:B10)
=COUNT(C1:C10)
=IF(D1>100, "High", "Low")
Day 02

Sorting, Filtering & Charts

Sorting Data
Filtering Data
Column Charts
Pie Charts
Line & Area Charts
Chart Customization
' Conditional Sorting & Filtering
' Sort by multiple columns
' Apply Auto Filter for dynamic data
=SORT(A2:D100, 2, 1)
=FILTER(A2:D100, C2:C100>1000)
Day 03

Pivot Tables & Lookup Functions

Pivot Tables
LOOKUP Function
VLOOKUP (Vertical)
HLOOKUP (Horizontal)
MATCH Function
INDEX-MATCH Combo
' Lookup Functions
=VLOOKUP(A2, Data!B:D, 3, FALSE)
=HLOOKUP("Sales", A1:Z2, 2, FALSE)
=INDEX(B2:B100, MATCH(E2, A2:A100, 0))
Day 04

VBA, Macros & Dashboards

Introduction to VBA
Recording & Running Macros
Creating Dashboards
Interview Questions
' VBA Macro Example
Sub FormatReport()
  Range("A1:D1").Font.Bold = True
  Range("A:D").AutoFit
End Sub
Skills You'll Gain

Excel Expertise

Master these essential skills for Advanced Excel

Pivot Tables

Summarize and analyze large datasets with powerful pivot tables

Lookup Functions

Master VLOOKUP, HLOOKUP, and INDEX-MATCH combinations

Data Visualization

Create stunning charts and graphs to present data insights

VBA Programming

Automate repetitive tasks with Visual Basic for Applications

Macro Automation

Record and run macros to streamline your workflow

Dashboard Creation

Build interactive dashboards for executive reporting

Ready to Master Excel?

Join our comprehensive data analytics program and become an Advanced Excel expert

Enroll Now