Microsoft Excel Essential Training

Course Content

Introduction to Microsoft Excel

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.

Basic Formulas & Functions
Objective: Perform calculations using formulas.

Intermediate Functions
Objective: Use logic and lookup functions.

Data Management & Tables
Objective: Manage and clean data efficiently.

Charts & Data Visualization
Objective: Visualize data effectively.

Advanced Functions
Objective: Work with complex formulas.

Pivot Tables & Pivot Charts
Objective: Summarize and analyze large datasets.

Collaboration & Productivity
Objective: Work efficiently in teams.

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

Student Ratings & Reviews

No Review Yet

Microsoft Excel Essential Training

Course Content

Introduction to Microsoft Excel

What is Microsoft Excel?

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.

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.

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.

IF function

Nested IF statements

VLOOKUP & HLOOKUP

Introduction to XLOOKUP

Logical operators (AND, OR)

Data Management & Tables Objective: Manage and clean data efficiently.

Creating tables

Sorting & filtering

Removing duplicates

Data validation (dropdown lists)

Freeze panes

Charts & Data Visualization Objective: Visualize data effectively.

Chart types (Bar, Line, Pie)

Creating charts

Customizing charts

Sparklines

Dashboard basics

Advanced Functions Objective: Work with complex formulas.

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.

Creating Pivot Tables

Grouping data

Calculated fields

Pivot Charts

Slicers & filters

Collaboration & Productivity Objective: Work efficiently in teams.

Sharing workbooks

Comments & notes

Track changes

Protecting sheets/workbooks

Cloud integration (OneDrive)

Earn a certificate

Student Ratings & Reviews

Data Entry & Formatting
Objective: Learn how to organize and format data professionally.

Basic Formulas & Functions
Objective: Perform calculations using formulas.

Intermediate Functions
Objective: Use logic and lookup functions.

Data Management & Tables
Objective: Manage and clean data efficiently.

Charts & Data Visualization
Objective: Visualize data effectively.

Advanced Functions
Objective: Work with complex formulas.

Pivot Tables & Pivot Charts
Objective: Summarize and analyze large datasets.

Collaboration & Productivity
Objective: Work efficiently in teams.