Excel does two main things: calculations (numeric, logical and text) and data analysis — turning raw data into useful information for decision makers.
What Excel is made of
- Columns are letters (A, B, C…), rows are numbers (1, 2, 3…).
- A cell is the intersection of a column and a row. Its address:
A1,B5. - Worksheet = all the cells; sheet tab = the sheet's name; workbook = all the sheets = the file.
Putting things into a cell
| Enter | enter and move down |
| Ctrl+Enter | enter and stay in the cell |
| Tab | enter and move right |
| Shift+Enter | enter and move up |
| Shift+Tab | enter and move left |
Shortcuts from the manual
| Ctrl+←↑→↓ | jump to the edge of the current region |
| Ctrl+Home | go to A1 |
| Ctrl+Shift+↓ | select a column down to the end of the region |
| Alt+= | AutoSum |
| Ctrl+1 | Format Cells |
| Ctrl+PageDown / PageUp | next / previous sheet |
| Ctrl+Z / Y | undo / redo |
The current region is all the data up to the first empty row/column. All these keys work in the trainer below.