LIVE CLASSES

Job Assistance

Master Microsoft Excel
from Basics to Advanced — Live Classes

A complete Excel course from absolute beginner to advanced power user — covering the interface, formulas, functions, VLOOKUP, INDEX-MATCH, XLOOKUP, PivotTables, PivotCharts, data visualisation, conditional formatting, data validation, Power Query, and Macros/VBA automation. Live classroom · Certificate · Job Assistance.

Excel VLOOKUP XLOOKUP INDEX-MATCH PivotTables Power Query Macros VBA Charts Data Validation

★★★★½ 4.8 1–2 Months Classroom English / Hindi / Marathi Certificate Job Assistance

LIVE INSTRUCTOR-LED COURSE

Excel Basics and Advanced

Interactive live sessions · Real-time Q&A · Job Assistance

Demo: Yes

Duration: 1–2 Months

Language: English / Hindi / Marathi

Location: Classroom

Certificate: Yes

Assessments: Yes

Job Assist: Yes

Select Your Batch:

May 5, 2025

Mon, Wed, Fri — 7:00 PM to 9:00 PM IST

8 seats left

May 17, 2025

Sat & Sun — 10:00 AM to 1:00 PM IST

18 seats left

June 2, 2025

Mon, Wed, Fri — 8:00 AM to 10:00 AM IST

Open

Enroll & Reserve Seat Request a Callback

7-Day Money-Back Guarantee

Live interactive classroom sessions

Session recordings after every class

Real-time Q&A with instructor

Private batch — max 30 students

Job assistance included

Industry-recognized certificate

1–2 Months Duration

Classroom Location

4.8/5 Rating

Included Job Assistance

About the Course

What This Course Covers

Microsoft Excel is the most widely used business tool in the world — essential for data analysis, financial modelling, reporting, and automation. This course takes you from zero knowledge to advanced Excel proficiency. You will master the interface, all essential formulas, powerful lookup functions (VLOOKUP, XLOOKUP, INDEX-MATCH), PivotTables and PivotCharts, data visualisation, conditional formatting, data validation, Power Query for ETL, and automation with Macros and VBA.

Note: 90% hands-on practical experience · 10% essential theory. Anyone who wants to learn from Basics to Advanced Level. Programmers looking to improve programming skills.

Excel Fundamentals

Interface, navigation, workbooks, worksheets, cells, rows, columns, basic data entry, formatting, and printing.

Formulas & Functions

Arithmetic, text, date, logical, statistical, and financial functions — building real-world formulas from scratch.

Lookup Functions

VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH, INDIRECT — the essential Excel functions for data retrieval.

PivotTables & PivotCharts

Summarise, analyse, and visualise large datasets with PivotTables, PivotCharts, slicers, and timelines.

Power Query & Data Tools

Import, clean, and transform data from multiple sources with Power Query — no formulas required.

Macros & VBA Automation

Record and write macros, automate repetitive tasks, and build custom solutions with VBA code.

Course Curriculum

What You'll Learn — Module by Module

Excel Basics — Interface & Navigation

Live sessions

Introduction to Microsoft Excel — Interface OverviewLIVE —

Workbooks, Worksheets, and NavigationLIVE —

Entering Data — Text, Numbers, DatesLIVE —

Selecting Cells, Rows, and ColumnsLIVE —

Copy, Cut, Paste, Paste SpecialLIVE —

Find & ReplaceLIVE —

Undo, Redo, and AutoFillLIVE —

Saving Files — .xlsx, .xlsm, .csv, PDF ExportLIVE —

Doubt Clearing Session + RecordingREC —

Formatting

Live sessions

Cell Formatting — Font, Size, Bold, Italic, ColorLIVE —

Number Formats — Currency, Percentage, Date, CustomLIVE —

Borders and Cell ShadingLIVE —

Merge & Center, Wrap Text, Text AlignmentLIVE —

Conditional Formatting — Highlight Rules, Data Bars, Color Scales, Icon SetsLIVE —

Format PainterLIVE —

Tables — Creating and Formatting Excel TablesLIVE —

Freeze Panes, Split, Hide/Unhide Rows and ColumnsLIVE —

Formulas & Essential Functions

Live sessions

Cell References — Relative, Absolute ($), MixedLIVE —

Arithmetic Operations in FormulasLIVE —

SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, COUNTBLANKLIVE —

ROUND, ROUNDUP, ROUNDDOWN, INT, TRUNC, MOD, ABS, POWER, SQRTLIVE —

IF, AND, OR, NOTLIVE —

Nested IF StatementsLIVE —

IFS Function (Excel 365/2019)LIVE —

SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFSLIVE —

COUNTIF, COUNTIFSLIVE —

IFERROR and IFNALIVE —

Text & Date Functions

Live sessions

LEFT, RIGHT, MID, LEN, FIND, SEARCHLIVE —

UPPER, LOWER, PROPER, TRIM, CLEANLIVE —

CONCATENATE, CONCAT, TEXTJOINLIVE —

TEXT Function for Custom FormattingLIVE —

TODAY, NOW, DATE, YEAR, MONTH, DAY, WEEKDAYLIVE —

DATEDIF, EDATE, EOMONTH, NETWORKDAYSLIVE —

Lookup & Reference Functions

Live sessions

VLOOKUP — Exact and Approximate MatchLIVE —

HLOOKUPLIVE —

XLOOKUP — Flexible Lookup (Excel 365)LIVE —

INDEX and MATCHLIVE —

INDEX-MATCH vs VLOOKUPLIVE —

Nested VLOOKUPLIVE —

CHOOSE and OFFSETLIVE —

INDIRECT — Dynamic ReferencesLIVE —

HYPERLINK FunctionLIVE —

Data Tools

Live sessions

Sorting — Single Column and Multi-LevelLIVE —

Filtering — AutoFilter and Advanced FilterLIVE —

Remove DuplicatesLIVE —

Data Validation — Dropdown Lists, Number Range, Date ValidationLIVE —

Text to ColumnsLIVE —

Flash FillLIVE —

What-If Analysis — Goal Seek, Data Table, Scenario ManagerLIVE —

SUBTOTAL FunctionLIVE —

Named RangesLIVE —

Charts & Data Visualisation

Live sessions

Creating Charts — Bar, Column, Line, Pie, Area, ScatterLIVE —

Formatting and Customizing ChartsLIVE —

Combination ChartsLIVE —

Dynamic Charts with Named RangesLIVE —

SparklinesLIVE —

Dashboard Design PrinciplesLIVE —

PivotTables & PivotCharts

Live sessions

Introduction to PivotTablesLIVE —

Creating a PivotTableLIVE —

Rows, Columns, Values, Filters in PivotTableLIVE —

Value Field Settings — Sum, Count, Average, % of TotalLIVE —

Grouping Dates in PivotTableLIVE —

Slicers and TimelinesLIVE —

Calculated Fields in PivotTableLIVE —

PivotChartsLIVE —

Refreshing and Updating PivotTablesLIVE —

Power Query (Get & Transform)

Live sessions

Introduction to Power QueryLIVE —

Importing Data — Excel, CSV, Web, DatabaseLIVE —

Power Query Editor InterfaceLIVE —

Removing Columns and RowsLIVE —

Filtering and Sorting in Power QueryLIVE —

Splitting Columns and Merging ColumnsLIVE —

Data Type Changes and Replacing ValuesLIVE —

Merge Queries (Join) and Append QueriesLIVE —

Custom Columns with M Language BasicsLIVE —

Refreshing Power QueryLIVE —

Macros & VBA

Live sessions

Introduction to Macros — Recording a MacroLIVE —

Running, Editing, and Deleting MacrosLIVE —

Macro Security SettingsLIVE —

VBA Editor (VBE) InterfaceLIVE —

Variables, Data Types, and Constants in VBALIVE —

Control Structures — If/Else, Select Case, For/Next, Do/LoopLIVE —

Working with Cells, Ranges, and Sheets in VBALIVE —

Subroutines and Functions in VBALIVE —

Error Handling in VBALIVE —

Creating Custom Functions (UDFs)LIVE —

Building a Simple Automation ToolLIVE —

Certificate Award SessionLIVE —

What You'll Learn

Excel interface, navigation & formatting

Conditional formatting & Excel Tables

All essential formulas & functions

IF, SUMIFS, COUNTIFS, AVERAGEIFS

VLOOKUP, XLOOKUP, INDEX-MATCH

Text & date functions

Data tools — validation, filtering, sorting

Charts & data visualisation

PivotTables, PivotCharts, slicers

Power Query — import, clean & transform

Macros & VBA automation

Live Classroom 1–2 Months Certificate

Enroll Now

FAQs

Frequently Asked Questions

Our counsellors are available Mon–Sat, 9am–7pm IST.

Call Us Now

Is a demo lecture available?

Yes. A free demo lecture is available. Contact us via WhatsApp or phone to schedule.

Do I need prior programming experience?

No prior experience is required. Anyone who wants to learn from Basics to Advanced Level is welcome.

Is this a classroom or online course?

This is a live, classroom-based course with in-person instruction.

What language are classes taught in?

Classes are conducted in English, Hindi, and Marathi.

Will I get a certificate?

Yes. An industry-recognized certificate is awarded on successful completion of all modules and assessments.

Is job assistance included?

Yes. Job assistance including resume preparation, mock interviews, and placement support is included.

Which version of Excel is used?

Excel 2019 and Excel 365 are used. Most features are compatible across both versions, and newer features like XLOOKUP are clearly highlighted.

Do I need prior experience with Excel?

No experience required. The course starts from the very beginning — opening Excel and entering data — and progresses to advanced automation.

Master Microsoft Excel
from Basics to Advanced — Live Classes

Excel Basics and Advanced

What This Course Covers

Excel Fundamentals

Formulas & Functions

Lookup Functions

PivotTables & PivotCharts

Power Query & Data Tools

Macros & VBA Automation

What You'll Learn — Module by Module

Excel Basics — Interface & Navigation

Formatting

Formulas & Essential Functions

Text & Date Functions

Lookup & Reference Functions

Data Tools

Charts & Data Visualisation

PivotTables & PivotCharts

Power Query (Get & Transform)

Macros & VBA

Our Students Are Getting Hired

Learn from an Industry Expert

Frequently Asked Questions

Is a demo lecture available?

Do I need prior programming experience?

Is this a classroom or online course?

What language are classes taught in?

Will I get a certificate?

Is job assistance included?

Which version of Excel is used?

Do I need prior experience with Excel?

Ready to Master Microsoft Excel?

Master Microsoft Excelfrom Basics to Advanced — Live Classes

Excel Basics and Advanced

What This Course Covers

Excel Fundamentals

Formulas & Functions

Lookup Functions

PivotTables & PivotCharts

Power Query & Data Tools

Macros & VBA Automation

What You'll Learn — Module by Module

Excel Basics — Interface & Navigation

Formatting

Formulas & Essential Functions

Text & Date Functions

Lookup & Reference Functions

Data Tools

Charts & Data Visualisation

PivotTables & PivotCharts

Power Query (Get & Transform)

Macros & VBA

Our Students Are Getting Hired

Learn from an Industry Expert

Frequently Asked Questions

Is a demo lecture available?

Do I need prior programming experience?

Is this a classroom or online course?

What language are classes taught in?

Will I get a certificate?

Is job assistance included?

Which version of Excel is used?

Do I need prior experience with Excel?

Ready to Master Microsoft Excel?

Master Microsoft Excel
from Basics to Advanced — Live Classes