SheetSkill
Learning pathLesson 4 of 5
Practice sheetEverything is checked as you go. Rules can be changed or deleted any time.
Click a cell, then type. Right-click for rows, columns, sort and filter.
A
B
C
D
E
F
G
H
I
J
K
L
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
Region
Rep
Product
Units
Sales
North
Asha
Pens
20
70
South
Ben
Folders
57
256.5
East
Chen
Ink
94
517
West
Dee
Paper
41
143.5
North
Eli
Pens
78
351
South
Fay
Folders
25
137.5
East
Gus
Ink
62
217
West
Hana
Paper
99
445.5
North
Ivo
Pens
46
253
South
Jo
Folders
83
290.5
East
Kai
Ink
30
135
West
Lia
Paper
67
368.5

Conditional formatting

A number, or a cell like =$H$1

AaBbCc 123

Rules on this sheet (0)

No rules yet. When several rules affect the same cell, the one higher in this list wins.

Find and Replace

Data Validation

Separate items with commas, or point at cells with = (a range or a name). Alt+↓ opens the list in a cell.

Sort

    Rows are sorted by the first level; rows that tie are sorted by the next level, and so on.

    Remove Duplicates

    Rows in count as duplicates when they match in every column you tick. The first one is kept.

    Name Manager

    No names yet. Select some cells and press New…, or type a name in the box left of the formula bar and press Enter.

    Use a name in any formula, e.g. =SUM(Prices). Ctrl+F3 opens this box.

    Edit chart

    Create Table

    A table gets a name, coloured rows, filter buttons and grows by itself when you type in the row below it. Formulas can then say =SUM(Table1[Sales]) instead of =SUM(D2:D20).

    Go To

    Format Cells

    SampleRegion

    No specific number format.

    Insert Hyperlink

    A cell reference like Sheet2!A1 links to a place in this workbook. Ctrl+click a link cell to open it.

    New note · A1

    Notes show as a red corner. Ctrl+Enter saves.

    Insert Function

    SUM(number1, [number2], …)
    Adds numbers