CoachnestCoachnest
Sign InGet Started
Back to course

Microsoft Excel Mastery: From Beginner to Data Pro

…
—
Contents

What Is Excel & Where It's Used

Reading10mFree
2

The Excel Interface: Ribbon, Cells & Sheets

Reading13mFree
3

Navigating & Selecting Like a Pro

Reading12m
4

Tour of the Excel Workspace

Video11m
5

Chapter 1 — Quiz

Quiz8m
6

Data Types: Text, Numbers, Dates & Booleans

Reading13m
7

Formatting Cells: Fonts, Borders & Colors

Reading14m
8

Number Formats: Currency, Percent & Custom

Reading13m
9

Working with Excel Tables

Reading14m
10

Chapter 2 — Quiz

Quiz8m
11

Your First Formulas & the Order of Operations

Reading14m
12

Relative, Absolute & Mixed References

Reading16m
13

Copying, Filling & AutoFill

Reading12m
14

Building a Calculation Sheet

Video13m
15

Chapter 3 — Quiz

Quiz9m
16

SUM, AVERAGE, COUNT, MIN & MAX

Reading14m
17

Function Syntax, Arguments & AutoComplete

Reading12m
18

Rounding & Math: ROUND, INT, ABS, MOD

Reading12m
19

Chapter 4 — Quiz

Quiz8m
20

IF, Nested IF & IFS

Reading15m
21

Conditional Aggregates: SUMIF, COUNTIF, AVERAGEIF

Reading14m
22

VLOOKUP & the Power of Lookups

Reading16m
23

XLOOKUP & INDEX/MATCH (Modern Lookups)

Reading16m
24

Chapter 5 — Quiz

Quiz10m
25

Text Functions: LEFT, RIGHT, MID, LEN, TRIM

Reading14m
26

Dates & Times: TODAY, DATEDIF, EOMONTH

Reading14m
27

Combining Text, Logic & Dates

Video12m
28

Chapter 6 — Quiz

Quiz8m
29

Sorting & Filtering Data

Reading13m
30

Data Validation & Dropdown Lists

Reading14m
31

Conditional Formatting & Removing Duplicates

Reading14m
32

Chapter 7 — Quiz

Quiz9m
33

PivotTables: Summarize Thousands of Rows in Seconds

Reading16m
34

Grouping, Slicers & Calculated Fields

Reading14m
35

Building a PivotTable Analysis

Video14m
36

Chapter 8 — Quiz

Quiz9m
37

Chart Types & When to Use Each

Reading14m
38

Formatting Charts & Sparklines

Reading13m
39

Building an Interactive Dashboard

Reading16m
40

Chapter 9 — Quiz

Quiz9m
41

Named Ranges & What-If Analysis

Reading14m
42

Introduction to Macros & VBA

Reading15m
43

Shortcuts, Printing & Sharing

Reading13m
44

Automating a Report

Video12m
45

Chapter 10 — Final Quiz

Quiz10m
←→navigate lessons
Chapter 1 of 10·Chapter 1 — Getting Started with Excel
Lesson 1 of 45Reading10 min

What Is Excel & Where It's Used

What Is Excel & Where It's Used¶

Microsoft Excel is a spreadsheet application: a giant grid where you store, calculate, analyze, and visualize data. If a problem involves numbers, lists, or tables, Excel can probably help.

A modern data dashboard built in a spreadsheet, showing charts and KPIs

Who Uses Excel?¶

Note

Excel is used by an estimated 750 million+ people worldwide — accountants, analysts, marketers, scientists, students, and small-business owners.

FieldTypical use
FinanceBudgets, forecasts, models
SalesPipelines, commissions, reports
OperationsInventory, scheduling, tracking
MarketingCampaign metrics, A/B results
EducationGrades, research data
PersonalExpenses, planners, lists

Why Learn Excel?¶

  1. 1.It's everywhere. Nearly every office runs on spreadsheets.
  2. 2.It's a career skill. "Proficient in Excel" appears in millions of job listings.
  3. 3.It scales with you. The same app handles a grocery list and a financial model.

What You'll Build in This Course¶

By the end you'll create a Sales Dashboard from raw data:

  • Clean and format a messy dataset
  • Calculate totals, averages, and growth with formulas
  • Look up values across tables with XLOOKUP
  • Summarize thousands of rows with a PivotTable
  • Visualize results with charts and a one-page dashboard

Every lesson uses real spreadsheet examples and images so you can follow along. Let's open Excel. 📊

Back to

Course Overview

Next

The Excel Interface: Ribbon, Cells & Sheets

Use ← → arrow keys to navigate between lessons