Course Content
Introduction to Microsoft Excel
0/8
What is Microsoft Excel?
02:41
Excel interface (Ribbon, Tabs, Toolbar)
Workbook vs Worksheet
Rows, Columns, Cells
Cell referencing (A1 style)
File operations (New, Save, Open)
Quiz
Challenge
Data Entry & Formatting
Objective: Learn how to organize and format data professionally.
0/6
Data types (Text, Number, Date)
Formatting cells (font, size, color)
Alignment and text wrapping
Number formatting (currency, percentage)
Borders and shading
Conditional formatting
Basic Formulas & Functions
Objective: Perform calculations using formulas.
0/4
Formula structure (= sign, operators)
Basic arithmetic (+, -, *, /)
Functions: (SUM, AVERAGE, MIN, MAX, COUNT, COUNTA)
Relative vs Absolute references ($A$1)
Intermediate Functions
Objective: Use logic and lookup functions.
0/5
IF function
Nested IF statements
VLOOKUP & HLOOKUP
Introduction to XLOOKUP
Logical operators (AND, OR)
Data Management & Tables
Objective: Manage and clean data efficiently.
0/5
Creating tables
Sorting & filtering
Removing duplicates
Data validation (dropdown lists)
Freeze panes
Charts & Data Visualization
Objective: Visualize data effectively.
0/5
Chart types (Bar, Line, Pie)
Creating charts
Customizing charts
Sparklines
Dashboard basics
Advanced Functions
Objective: Work with complex formulas.
0/4
INDEX & MATCH
SUMIF, COUNTIF, AVERAGEIF
Text functions (LEFT, RIGHT, MID, LEN)
Date functions (TODAY, NOW, DATEDIF)
Pivot Tables & Pivot Charts
Objective: Summarize and analyze large datasets.
0/5
Creating Pivot Tables
Grouping data
Calculated fields
Pivot Charts
Slicers & filters
Collaboration & Productivity
Objective: Work efficiently in teams.
0/5
Sharing workbooks
Comments & notes
Track changes
Protecting sheets/workbooks
Cloud integration (OneDrive)
Microsoft Excel Essential Training
Previous
Next
0% Complete