0% found this document useful (0 votes)
20 views31 pages

Excel Training File

The document outlines an Excel obstacle course designed to improve efficiency with keyboard shortcuts. Participants are instructed to complete various tasks using hotkeys without relying on the mouse, with specific hints provided for each obstacle. The course emphasizes the importance of not saving progress to ensure a fresh restart can be made if needed.

Uploaded by

Emir Rakhim
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
20 views31 pages

Excel Training File

The document outlines an Excel obstacle course designed to improve efficiency with keyboard shortcuts. Participants are instructed to complete various tasks using hotkeys without relying on the mouse, with specific hints provided for each obstacle. The course emphasizes the importance of not saving progress to ensure a fresh restart can be made if needed.

Uploaded by

Emir Rakhim
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Gur

### u

Qualificati Time Taken


Guru <15 Sec
Expert 16-30 Sec
Experience31-60 Sec
Capable 1 - 1.25 Mins
Amateur 1.26 - 2 Mins
Beginner > 2 Mins
WELCOME TO THE EXCEL OBSTACL
COURSE!
The objective of this game is to increas
efficiency with keyboard shortcuts (hot
order to eliminate pointing / clicking w
mouse or touchpad.

You will find that your Excel skills and s


greatly increase as you improve your b
through the course.
Note: Make sure you DON'T SAVE the c
upon exiting, otherwise you will not ha
ability to restart the course fresh. If yo
close out of the spreadsheet and don't
Reopen the original copy and restart.

Hit 'Start' Button to start the timer, the


the "Column Delete" tab for your first o
When complete, go to the next tab from
right.
There are instructions on each obstacle
as hotkey tips.
When complete, go to the next tab from
right.
There are instructions on each obstacle
as hotkey tips.

Good Luck!
OBSTACLE

to increase your
rtcuts (hotkeys) in
clicking with the

skills and speed will


ove your best time

SAVE the course


will not have the
resh. If you mess up,
and don't save.
d restart.

timer, then go to
your first obstacle.
ext tab from left to

ch obstacle as well
ext tab from left to

ch obstacle as well
Obstacle:
Delete the blue columns without using your mouse.

Hotkey hints:

CTRL and Spacebar Highlights entire column


CTRL and - (minus sign) Deletes entire column

Move on to the next tab when complete


Obstacle:
Delete the blue rows without using your mouse.

Hotkey hints:

Shift and Spacebar Highlights entire row


CTRL and - (minus sign) Deletes entire row

Move on to the next tab when complete


START
x x

x x

x x
x x

x x

x x
x

x
END
x

x
Obstacle:
Switch from one sheet to another by using CTRL and Pg Up and Pg Dn
Hotkey hints:
CTRL and Pg Dn (advances one sheet)
CTRL and Pg Up (goes back one sheet)
Advance to next sheet (CTRL and P
(CTRL and Pg Dn)
Obstacle:
Switch from one sheet to another by using CTRL and Pg Up and Pg Dn
Hotkey hints:
CTRL and Pg Dn (advances one sheet)
CTRL and Pg Up (goes back one sheet)
Advance to next sheet (CTRL and P
(CTRL and Pg Dn)
Obstacle:
Switch from one sheet to another by using CTRL and Pg Up and Pg Dn
Hotkey hints:
CTRL and Pg Dn (advances one sheet)
CTRL and Pg Up (goes back one sheet)
Advance to next sheet (CTRL and P
(CTRL and Pg Dn)
A B C D
A
A
A
A
A
A
A
A
A
A
A
A
A
A
Obstacle:
Copy down the cells in columns B, C and D

Hotkey hints:

CTRL and D (copies down)

The end result should look like


this ------->
A A A A A A A A
B
C
D
A

Obstacle:
Copy down the cells in columns B, C and D

Hotkey hints:

CTRL and D (copies down)

The end result should look like


this ------->
35 93 1 98
82 68 98 33 Obstacle:
33 9 50 27 Place totals of each colum
94 63 94 94
32 4 89 26 Hotkey hints:
96 68 38 19
ALT and + (sums the num
77 85 83 38
34 36 61 58 The end result should loo
66 85 40 99 this ------->
19 32 77 37
24 65 66 59
91 54 89 73
83 87 9 57
39 100 23 57
97 53 54 53
38 94 43 46
50 87 32 71
60 42 18 67
30 36 63 74
Totals
Obstacle:
Place totals of each column (A through D) in row 20.

Hotkey hints:

ALT and + (sums the numbers directly above the cursor)

The end result should look like


this ------->
5041
3754
5784
3015
8942
7347
2112
3768
8003
8865
8673
814
4609
5072
8903
4007
4833
7712
7437
4344
6374
871
1516
9374
6957
2701
2819
2 9 4 5 1 9
4 6 5 3 5 9
7 2 4 8 9 3
3 4 1 1 9 7
1 5 3 3 7 4
6 4 2 6 4 7
9 4 5 9 6 9
3 9 7 1 1 9

You might also like