ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Excel Basics Practice Workbook
2
Start here if you have never used Excel before. Work through the numbered tabs from left to right.
3
4
WELCOME 👋
5
What this workbook teachesYou will practise typing, editing, selecting cells/rows/columns, formatting, formulas, sorting, filtering, and useful keyboard shortcuts.
6
How to use itClick the tabs at the bottom of Excel in order: 1 → 2 → 3 → 4 → 5 → 6 → PRACTICE.
7
What is a cell?A cell is one box in the spreadsheet. Each cell has an address. For example, A1 means column A, row 1.
8
How do I select a cell?Move your mouse over a box and click it once. A border appears around the selected cell.
9
How do I type?Click a cell, type your text or number, then press Enter on your keyboard.
10
How do I undo a mistake?Press Ctrl + Z. You can press it more than once to undo several recent changes.
11
ImportantYou cannot permanently break this practice workbook. Experiment, make mistakes, and use Ctrl + Z when needed.
12
13
YOUR LEARNING PATH
14
StepLessonWhat you will learn
15
1Enter & EditType information, change it, delete it, copy it, and undo mistakes.
16
2Rows & ColumnsLearn exactly how to select, insert, resize, and work with rows and columns.
17
3FormattingMake a simple table easier to read using bold, fill, borders, alignment, and number formats.
18
4Simple FormulasUse =SUM, =AVERAGE, multiplication, and AutoFill.
19
5Sort & FilterOrganise a list and show only the information you need.
20
6ShortcutsPractise beginner keyboard shortcuts that save time.
21
7Practice Challenge
Use what you learned to complete a small real-world spreadsheet.
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100