[Ctrl] [Page ] - Move to the next worksheet
[Ctrl] [Page ] - Move to the previous worksheet
[Ctrl] [Tab] - Switch between Excel Workbooks
[Ctrl] [] - Move to the bottom of the data region (Other arrow keys - move to the edge of the data region)
[Ctrl] [Shift] [] - Move to the bottom of the data region and highlight the range in between (Other arrow keys to move & highlight in respective direction)
[Ctrl] A - Select data in current region
[Home] - Move to the first cell in the same row
[Ctrl] [Home] - Move to cell A1
[Ctrl] [End] - Move to the last used cell on the worksheet
[Ctrl] [Backspace] - Show active cell
[Ctrl] O - Open a workbook (Open menu)
[Ctrl] S - Save a workbook
[Ctrl] W - Close a workbook
[Shift] [F11] - Insert a new worksheet
[Ctrl] [+] - Insert a new cell/row/column
[Ctrl] [-] - Delete a cell/row/column
[Shift] [Space] - Select the row
[Ctrl] [Space] - Select the column
[Ctrl] B - Bold
[Ctrl] 1 - Format cells dialog box
[F4] - Repeat last edit
Freeze Panes
Use Freeze Panes to lock rows and columns in place as you scroll down or across your sheet. Go to View > Freeze Panes > Freeze Panes. Depending on where your active cell is, the top rows and the left-hand side columns will be locked.
Paste Special Options
There are many useful paste special options. Here's an overview of the different Paste options:
Values - This pastes the values as displayed and not the formula (formula is removed)
Formats - Pastes only the cell formatting (no values)
Formulas and number formats - Pastes formulas and number formatting (not cell formatting)
Values and number formats - Pastes the value and number formatting (no formulas & no cell formatting)
Mathematical operations (Add, Subtract, etc.) - Allows you to paste one set of numbers over another set and perform the selected mathematical operation on them at the same time.
Paste Link - Pastes a link to the copied range.
Transpose - Switches data in columns to rows and vice versa.
Protect File with a Password
To protect your workbook with a password, go to Save As and from the Tools options, select General Options. Type in your password.
Protect the Structure of Your File
Protect the structure of your file from Review / Protect Workbook. This ensures the sheets are not moved, deleted or added.
Protect the Sheet
Protect the sheet to ensure users cannot change formulas or input in cells they shouldnt be inputting.
To lock some areas but leave others open, go to Format Cells (Ctrl + 1) / Protection & remove the checkmark for locked
Remember: Your downloadable course notes cover the most important points. Make sure you keep them handy.
Keep Going!