Excel Essentials — From Zero to Confident

Go from blank spreadsheet to confident user. Cells and formulas, the functions that matter (SUM, IF, COUNTIF, XLOOKUP), clean formatting, sorting and filtering, PivotTables, and charts. Hands-on and jargon-free — no prior experience needed.

0.00 USD

Start this course →

What you'll study

Start Here

• How this course works

Domain 1 — Spreadsheet Foundations

• Workbooks, worksheets, cells, and the grid
• Entering data: text, numbers, dates
• Fill, copy, and save formats

Domain 2 — Formulas & Functions

• Formulas, operators, and order of operations
• Relative vs absolute references ($)
• Core functions: SUM, IF, COUNTIF, XLOOKUP

Domain 3 — Formatting & Presentation

• Number formats that prevent confusion
• Conditional formatting and Excel Tables
• Freeze panes, layout, and printing

Domain 4 — Data Tools & Charts

• Sort, filter, and data validation
• PivotTables: summarize in seconds
• Charts: turning numbers into a picture

Expanded: Core Functions & Everyday Math

• SUM, AutoSum & adding up ranges
• AVERAGE, COUNT vs COUNTA, MIN/MAX & order of operations

Expanded: Logical Functions & Decisions

• IF and comparison operators
• Nested IF, IFS, AND/OR/NOT & IFERROR

Expanded: Lookup & Reference Functions

• VLOOKUP & HLOOKUP
• XLOOKUP & INDEX/MATCH

Expanded: Conditional Aggregation (SUMIF, COUNTIF & friends)

• SUMIF and SUMIFS
• COUNTIF, COUNTIFS, AVERAGEIF & AVERAGEIFS

Expanded: Text & Rounding Functions

• LEFT, RIGHT, MID, LEN, FIND/SEARCH, TRIM & case
• CONCAT/TEXTJOIN, TEXT, and the ROUND family

Expanded: References, Ranges & Named Ranges

• Relative, absolute & mixed references ($)
• Ranges, named ranges & 3-D references

Expanded: Formatting & Conditional Formatting

• Cell formatting & number formats
• Conditional formatting

Expanded: Tables, Sorting, Filtering & Data Validation

• Excel Tables & structured references
• Sorting, filtering & data validation

Expanded: Charts, PivotTables & PivotCharts

• Charts - types and when to use them
• PivotTables & PivotCharts

Expanded: Productivity, Errors, Printing & Protection

• Freeze panes, navigation & keyboard shortcuts
• Common errors, printing/layout & protecting sheets

Practice and exam readiness

• Final Mastery Check
• Expanded Mock Exam
• Spaced-repetition flashcard deck (SM-2) for daily review
• Shareable, verifiable completion certificate

Related courses

• Digital Marketing Essentials — Modern Strategy, Channels & AI
• Negotiation Essentials — Confident, Fair Deals
• OneDrive Essentials — Cloud Files, Synced & Shared
• Phishing & Social Engineering Defense — Essentials
• Presentation Skills

Create a free account to preview lessons. Browse all courses.