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
Price
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.
