EXCEL Course
Excel Tutorial
Transform data into insights using Excel formulas, functions, and advanced analysis techniques.
Master Excel from basics to advanced data analysis, visualizations, dashboards, and automation with macros.
Structured Course Path
Follow this roadmap from basics to projects. Every topic includes a code example, output preview, FAQ, and tool integration.
Foundations
Excel Introduction
6 min - beginner
Start lesson
Interface and Navigation
7 min - beginner
Start lesson
Cells and Ranges
8 min - beginner
Start lesson
Data Entry
6 min - beginner
Start lesson
Basic Formatting
7 min - beginner
Start lesson
Number Formats
8 min - beginner
Start lesson
Conditional Formatting
6 min - beginner
Start lesson
Freeze Panes and Windows
7 min - beginner
Start lesson
Formulas and Functions
Formula Basics
8 min - beginner
Start lesson
Math Functions
6 min - beginner
Start lesson
Text Functions
7 min - beginner
Start lesson
Date and Time Functions
8 min - beginner
Start lesson
Logical Functions
6 min - beginner
Start lesson
Lookup Functions
7 min - beginner
Start lesson
Array Formulas
8 min - beginner
Start lesson
Error Handling
6 min - beginner
Start lesson
Data Analysis
Sorting and Filtering
9 min - intermediate
Start lesson
AutoFilter
10 min - intermediate
Start lesson
Pivot Tables
8 min - intermediate
Start lesson
Pivot Charts
9 min - intermediate
Start lesson
Data Validation
10 min - intermediate
Start lesson
Subtotals
8 min - intermediate
Start lesson
Data Consolidation
9 min - intermediate
Start lesson
Grouping and Outlining
10 min - intermediate
Start lesson
Charting and Visualization
Chart Types
8 min - intermediate
Start lesson
Creating Charts
9 min - intermediate
Start lesson
Chart Formatting
10 min - intermediate
Start lesson
Sparklines
8 min - intermediate
Start lesson
Dynamic Charts
9 min - intermediate
Start lesson
Dashboard Basics
10 min - intermediate
Start lesson
Map Charts
8 min - intermediate
Start lesson
Waterfall and Treemap Charts
9 min - intermediate
Start lesson
Advanced Workflows
Named Ranges
12 min - advanced
Start lesson
VLOOKUP Advanced
10 min - advanced
Start lesson
INDEX and MATCH
11 min - advanced
Start lesson
Scenario Analysis
12 min - advanced
Start lesson
Goal Seek
10 min - advanced
Start lesson
Solver Add-in
11 min - advanced
Start lesson
VBA Basics
12 min - advanced
Start lesson
Project: Financial Model
10 min - advanced
Start lesson