Keyboard Shortcuts

MS Word

F5 – Goto Page

F7 – Spelling and Grammar Check

CTRL+H – Replace

CTRL+(left/right) – Move one word in that direction

MS Excel

F2 – Edit

F5 – Goto Cell

F7 – Spelling and Grammar Check

CTRL+H – Replace

CTRL+HOME – Jump to cell A1

General Windows Programs

F1 - Help

CTRL+X – Cut

CTRL+C – Copy

CTRL+V – Paste

CTRL+Z – Undo

CTRL+S – Save

CTRL+N – New

CTRL+F – Find

CTRL+A – Select All

CTRL+B – Bold

CTRL+I – Italic

CTRL+U - Underline

Cursor Keys, End, Home – move the cursor around

Page Up, Page Down – Move up or down a page

Wheel on the mouse – Scroll up or down

CTRL+Scroll (on mouse) – Zoom window

General Tips

MS Excel

All formulas start with an equal sign, like this:  =A1+A2

Functions:

· Addition:                             +

· Subtraction:                       -

· Multiplication:                   *

· Division:                               /

· Concatenation:                                 &

o To combine or concatenate two values

o 1 + 1 = 2

o 1 & 1 = 11

=SUM()  - Will sum (add) whatever values or cells are inside the parentheses.

=AVERAGE()  - Will provide an average of whatever values or cells are inside the parentheses.

=COUNT()   - Will count whatever numerical values or cells are inside the parentheses. (Only counts numbers)

=MAX() – Get the Maximum of the number of whatever values or cells are inside the parentheses.

=MIN() – Get the Minimum of the number of whatever values or cells are inside the parentheses.

F2 to Start Edit mode.

ESC to cancel Edit mode

Use a leading apostrophe to force a number to be treated as text.