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

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 2 of 45Reading13 min

The Excel Interface: Ribbon, Cells & Sheets

The Excel Interface: Ribbon, Cells & Sheets¶

When you open Excel you see a grid of cells and a toolbar at the top. Let's name the parts.

The Excel workspace: ribbon at the top, the cell grid below, and sheet tabs at the bottom

The Key Areas¶

PartWhat it is
RibbonThe tabbed toolbar (Home, Insert, Formulas…)
Name BoxShows/jumps to the active cell address (e.g. B2)
Formula BarShows and edits the active cell's contents
Cell gridThe worksheet of rows and columns
Sheet tabsSwitch between worksheets in the workbook
Status barQuick stats (Sum, Average, Count) at the bottom

Workbook → Worksheet → Cell¶

Workbook (the .xlsx file) └─ Worksheet (a tab/sheet) └─ Cell (one box, e.g. C5)
  • A workbook is the whole file.
  • A worksheet (or "sheet") is one tab inside it.
  • A cell is a single box, addressed by column letter + row number → C5 is column C, row 5.

Columns, Rows & the Active Cell¶

  • Columns run vertically and are labeled with letters: A, B, C … Z, AA, AB …
  • Rows run horizontally and are numbered: 1, 2, 3 …
  • The active cell has a green border; whatever you type lands there.
Tip

The Name Box (far left, above the grid) always shows the active cell's address. Type an address like Z100 into it and press [[Enter]] to jump straight there.

Your First Workbook¶

  1. 1.Press CtrlN to create a new workbook.
  2. 2.Click cell A1 and type your name.
  3. 3.Press Enter — the active cell moves down to A2.
  4. 4.Save with CtrlS (modern format: .xlsx).

Previous

What Is Excel & Where It's Used

Next

Navigating & Selecting Like a Pro

Use ← → arrow keys to navigate between lessons