CoachnestCoachnest
Sign InGet Started
Back to course

Microsoft Excel Mastery: From Beginner to Data Pro

…
—
Contents
1

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

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 5 of 10·Chapter 5 — Logical & Lookup Functions
Lesson 24 of 45Quiz10 min

Chapter 5 — Quiz

Previous

XLOOKUP & INDEX/MATCH (Modern Lookups)

Next

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

Use ← → arrow keys to navigate between lessons