MS Excel Online Course – Basic to Advanced | Learn Excel for Data Analysis & Business

✅ Course Contents / Syllabus
1. Excel Basics
Introduction to Excel & Interface Overview
Workbook vs Worksheet
Entering & Editing Data
Cell References (Relative, Absolute, Mixed)
Formatting Cells (Font, Color, Borders)
Basic Navigation & Shortcuts

2. Data Handling
Sorting & Filtering Data
Find & Replace
Data Validation
Conditional Formatting Basics
Using Named Ranges

3. Formulas & Functions (Intermediate)
Basic Arithmetic Formulas (+, -, *, /)
SUM, AVERAGE, MIN, MAX, COUNT
IF Statements & Nested IF
Logical Functions: AND, OR, NOT
Text Functions: LEFT, RIGHT, MID, CONCATENATE
Date & Time Functions
Lookup Functions: VLOOKUP, HLOOKUP, INDEX, MATCH

4. Data Analysis Tools
Pivot Tables & Pivot Charts
Sorting & Grouping Data
Using Slicers & Timelines
Subtotals & Consolidation

5. Charts & Visualization
Creating Charts (Column, Bar, Line, Pie, Combo)
Chart Formatting & Customization
Sparklines
Conditional Charts

6. Advanced Excel Features
Advanced Formulas & Array Formulas
Named Ranges & Dynamic Ranges
Data Tables & Scenario Manager
What-If Analysis (Goal Seek, Data Tables, Solver)
Macros Basics & VBA Introduction
Protecting Worksheets & Workbooks

7. Practical Applications
Business Reports Automation
Financial Statements
Dashboard Creation
Data Cleaning & Analysis Projects
Real-life Case Studies