Course contents · Excel Basics

Excel structure and navigation

Open the practice in the trainer →

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

Putting things into a cell

Enterenter and move down
Ctrl+Enterenter and stay in the cell
Tabenter and move right
Shift+Enterenter and move up
Shift+Tabenter and move left

Shortcuts from the manual

Ctrl+←↑→↓jump to the edge of the current region
Ctrl+Homego to A1
Ctrl+Shift+↓select a column down to the end of the region
Alt+=AutoSum
Ctrl+1Format Cells
Ctrl+PageDown / PageUpnext / previous sheet
Ctrl+Z / Yundo / redo

The current region is all the data up to the first empty row/column. All these keys work in the trainer below.

Tasks in the trainer

  1. In B6 calculate the total monthly expenses. Try selecting B6 and pressing Alt+=.
  2. In C2:C5 calculate yearly expenses (monthly × 12). Enter the formula in C2 and copy it down (Ctrl+C → select C3:C5 → Ctrl+V, or select C2:C5 and press Ctrl+D, or drag the fill handle).
  3. In C6 — the yearly total.
  4. In B8 calculate the average monthly expense (B2:B5).
  5. In B9 find the largest monthly expense item.

Solve the tasks in the trainer →

Check yourself

  1. Which key enters data and keeps the same cell selected?
  2. What is a “workbook” in Excel?
  3. How do you jump to cell A1 quickly?