Microsoft Excel – Beginner to Advance
Microsoft Excel is a versatile spreadsheet application created by Microsoft that helps users manage, examine, and present data effectively. It is widely used in various industries and is a key component of the Microsoft Office suite, offering powerful features for calculations, automation, reporting, and financial analysis.
Excel primarily works by organizing information into rows and columns, enabling users to apply formulas, perform calculations, generate charts, and develop financial models. Available on both Windows and macOS platforms, Excel is commonly used for a wide range of personal, academic, and professional purposes.
Course Highlight / Content
🔰 Module 1: Excel Basics (Beginner)
-
Introduction to MS Excel
-
Workbook & Worksheet
-
Rows, Columns, Cells
-
Cell Address & Range
-
Data Types (Text, Number, Date)
-
Save, Save As, Open
-
Excel Interface Overview
📊 Module 2: Data Entry & Formatting
-
Cell Formatting
-
Font, Size, Color
-
Alignment
-
Wrap Text
-
Merge & Center
-
-
Number Formatting
-
Currency
-
Percentage
-
Date & Time
-
-
Conditional Formatting (Basic)
🧮 Module 3: Basic Formulas & Functions
-
Formula Basics
-
Arithmetic Operators (+, -, *, /)
-
AutoSum
-
Basic Functions
-
SUM
-
AVERAGE
-
COUNT
-
MAX
-
MIN
-
📋 Module 4: Data Management
-
-
Sort (Single & Multiple Level)
-
Filter (Auto Filter, Custom Filter)
-
Data Validation
-
Dropdown List
-
-
Remove Duplicates
-
Text to Columns
-
Flash Fill
-
📈 Module 5: Charts & Visualization
-
Column Chart
-
Bar Chart
-
Line Chart
-
Pie Chart
-
Area Chart
-
Chart Formatting
-
Sparklines
🧠 Module 6: Logical & Text Functions
Logical Functions
-
IF
-
AND
-
OR
-
IFERROR
Text Functions
-
LEFT
-
RIGHT
-
MID
-
LEN
-
TRIM
-
UPPER / LOWER / PROPER
-
CONCAT / CONCATENATE
🔍 Module 7: Lookup & Reference Functions
-
-
VLOOKUP
-
HLOOKUP
-
XLOOKUP
-
INDEX
-
MATCH
-
📅 Module 8: Date & Time Functions
-
TODAY
-
NOW
-
DATE
-
DATEDIF
-
DAY / MONTH / YEAR
📑 Module 9: Advanced Excel Tools
-
Conditional Formatting (Advanced)
-
Pivot Table
-
Pivot Chart
-
Slicers & Timelines
-
What-If Analysis
-
Goal Seek
-
Scenario Manager
-
Data Table
-
🔐 Module 10: Workbook Management
-
-
Protect Sheet
-
Protect Workbook
-
Hide / Unhide Rows & Columns
-
Freeze Panes
-
Page Setup
-
Print Titles
-
Print Area
-
⚙️ Module 11: Excel Automation (Optional)
-
Introduction to Macros
-
Record Macro
-
Macro Security
-
Basic VBA Concepts
📂 Module 12: Practical Applications
-
Sales Report
-
Attendance Sheet
-
Salary Sheet
-
Invoice Format
-
Stock Management Sheet
-
MIS Report
🎓 Module 13: Shortcuts & Productivity
-
Common Keyboard Shortcuts
-
Excel Tips & Tricks
-
Error Handling
-
Best Practices
🧠 Module 14: How to use AI in Excel
- Chatgpt
- Cloude
- Microsoft Copilot
-
Introduction to MS Excel
-
Workbook & Worksheet
-
Rows, Columns, Cells
-
Cell Address & Range
-
Data Types (Text, Number, Date)
-
Save, Save As, Open
-
Excel Interface Overview
-
Cell Formatting
-
Font, Size, Color
-
Alignment
-
Wrap Text
-
Merge & Center
-
-
Number Formatting
-
Currency
-
Percentage
-
Date & Time
-
-
Conditional Formatting (Basic)
-
Formula Basics
-
Arithmetic Operators (+, -, *, /)
-
AutoSum
-
Basic Functions
-
SUM
-
AVERAGE
-
COUNT
-
MAX
-
MIN
-
-
-
Sort (Single & Multiple Level)
-
Filter (Auto Filter, Custom Filter)
-
Data Validation
-
Dropdown List
-
-
Remove Duplicates
-
Text to Columns
-
Flash Fill
-
-
Column Chart
-
Bar Chart
-
Line Chart
-
Pie Chart
-
Area Chart
-
Chart Formatting
-
Sparklines
Logical Functions
-
IF
-
AND
-
OR
-
IFERROR
Text Functions
-
LEFT
-
RIGHT
-
MID
-
LEN
-
TRIM
-
UPPER / LOWER / PROPER
-
CONCAT / CONCATENATE
-
-
VLOOKUP
-
HLOOKUP
-
XLOOKUP
-
INDEX
-
MATCH
-
-
TODAY
-
NOW
-
DATE
-
DATEDIF
-
DAY / MONTH / YEAR
-
Conditional Formatting (Advanced)
-
Pivot Table
-
Pivot Chart
-
Slicers & Timelines
-
What-If Analysis
-
Goal Seek
-
Scenario Manager
-
Data Table
-
-
-
Protect Sheet
-
Protect Workbook
-
Hide / Unhide Rows & Columns
-
Freeze Panes
-
Page Setup
-
Print Titles
-
Print Area
-
-
Introduction to Macros
-
Record Macro
-
Macro Security
-
Basic VBA Concepts
-
Sales Report
-
Attendance Sheet
-
Salary Sheet
-
Invoice Format
-
Stock Management Sheet
-
MIS Report
-
Common Keyboard Shortcuts
-
Excel Tips & Tricks
-
Error Handling
-
Best Practices
- Chatgpt
- Cloude
- Microsoft Copilot
Price Offline Class
Price Online Class
Click here to buy Recorded Session @ 999
Click here to buy Live Session @ 999
Duration

Every session is divided into three sections.
- Doubt Section (15 min) : Before Session starts, Recap and doubt Sessions
- Learning Section (45 min) : Learning Discussion as per syllabus.
- Practice Section (30 min) : Practice Evaluation once Discussion is over.
Review
Vibrant Career Academy
Near City Railway Station, Bareilly U.P. India
Ph. 9536264400, 9410884400


