New Shortcuts Learnt in This Section

[Enter] Move one cell down

[Ctrl] [Enter] Stay on the same cell

[Ctrl] C Copy cell / value

[Ctrl] V Paste cell / value

[F2] Edit cell content (same as double clicking on a cell)

[Esc] Reset cell value (while in edit mode)

[Tab] Move to the cell on the right

[ALT] [Enter] Add a line break inside the formula bar

[ALT] = - Auto Sum

[F2] [Ctrl] [Enter] Copy formula without formatting

[Ctrl] ; - Time Stamp current date

[Ctrl] [Shift] ; - Time Stamp current time

[Ctrl] # - Change date formatting to D-MMM-YY

[Ctrl] E - FlashFill

[Ctrl] N - Open Blank Workbook

[Ctrl] G - Go to Special

[Shift] [F2] - Insert a note / comment

Useful Features

Auto Fill For Index numbers, Weekdays, Months & more

If youd like to get a list of months, type in the first month and drag the selection down. Check the auto fill options for more choices.

Flash Fill to Modify & Speed up Data Entry

Use Flash Fill to get a list of email address, split names to two columns or combine names from two columns into one. Just start typing or use the shortcut key Ctrl E or go to Home / Fill / Flash Fill.

Go to Special to Find Special Cells

Use the shortcut key Ctrl G then Alt S to bring up Go to Special. Alternatively go to Home / Find & Select. Use this feature to quickly find formula cells, constants, comments and data validation.

Data Validation

Remember: Your downloadable course notes cover the most important points. Make sure you keep them handy.

Here's how far you've come

Keep Going!