Before entering a single number or formula, you need to understand what Excel is, why it is the world's most powerful spreadsheet tool, and how its desktop is structured. This foundation module gives you a complete map of the Excel environment — so every feature covered in subsequent modules has a home you can find instantly.
Microsoft Excel is the world's most widely used spreadsheet application. It organises data in a grid of rows and columns, performs complex calculations instantly, visualises data in charts, and automates repetitive tasks — all in one file called a workbook.
Excel is part of the Microsoft 365 suite and integrates seamlessly with Word, PowerPoint, Outlook, Access, Power BI, Teams, and SharePoint.
| Capability | Examples |
|---|---|
| Data Entry & Storage | Employee lists, inventory records, sales data, financial transactions, attendance registers |
| Calculations & Formulas | SUM, AVERAGE, IF, VLOOKUP, date/time arithmetic, percentage, compound interest |
| Data Analysis | Sorting, filtering, pivot tables, what-if analysis, conditional formatting |
| Charts & Visualisation | Column, bar, line, pie, scatter, combo, waterfall, sparklines, data bars |
| Reporting & Dashboards | Pivot tables, pivot charts, slicers, interactive dashboards, KPI trackers |
| Data Validation & Forms | Drop-down lists, input restrictions, error messages, checkboxes |
| Protection & Security | Cell locking, sheet protection, workbook encryption, password control |
| Automation | Macros, VBA code, Power Query, Power Pivot, automatic calculations |
| Integration | Link to Word documents, import from Access/CSV, export to PDF, share via OneDrive |
| Format | Extension | When to Use |
|---|---|---|
| Excel Workbook | .xlsx | Standard format for all new workbooks — no macros |
| Macro-Enabled Workbook | .xlsm | Workbooks that contain VBA macros |
| Excel Template | .xltx | Reusable workbook templates |
| Excel Binary | .xlsb | Very large files — faster to open/save |
| Comma Separated Values | .csv | Data exchange with other systems — plain text, no formatting |
| Legacy Excel | .xls | Older Excel 97–2003 format — avoid for new work |
.pdf | Export for distribution — cannot be edited |
When Excel opens without a specific file, it shows the Start Screen — a launch pad for creating or opening workbooks.
| Area | What It Does |
|---|---|
| Blank Workbook | Opens a fresh workbook with one empty sheet — the starting point for all new spreadsheets |
| Template Gallery | Pre-built workbooks for budgets, invoices, calendars, trackers — download and customise |
| Recent Files | Quick access to the last 50 files you worked on — click any to reopen |
| Pinned Files | Pin important files to the top of Recent (hover over a file → click the 📌 pin icon) |
| Open | Browse to a specific file location (This PC, OneDrive, network drive, USB) |
Once a workbook is open, you see the Excel desktop. Every element has a name and a specific purpose — learning the correct terminology makes following instructions in later modules much faster.
| Element | Location | What It Does |
|---|---|---|
| Title Bar | Very top of screen | Shows the filename and application name. The Minimize (–), Restore/Maximize (□), and Close (X) buttons are on the right. |
| Quick Access Toolbar (QAT) | Top-left, above the Ribbon | Customisable row of icon buttons for your most-used commands (Save, Undo, Redo by default). Click the ▾ to add more buttons. |
| Ribbon Tabs | Horizontal bar below title | File, Home, Insert, Page Layout, Formulas, Data, Review, View — and contextual tabs that appear when a table, chart, or image is selected. |
| Ribbon Groups | Below the active tab | Commands organised into named groups (e.g., Home → Clipboard, Font, Alignment, Number, Styles, Cells, Editing). Each group has related tools. |
| Name Box | Left of the formula bar | Shows the address of the active cell (e.g., A1, B5, D12). Type a cell address here and press Enter to jump there instantly. Also used to name ranges. |
| Formula Bar | Right of the Name Box | Displays the content of the active cell — whether that is a value, text, or formula. This is where you see and edit formulas in full. The fx button opens Insert Function. |
| Column Headers | Grey letters across the top of the grid | A, B, C … Z, AA, AB … XFD — 16,384 columns total. Click a column header to select the entire column. Drag the border between headers to resize the column width. |
| Row Numbers | Grey numbers down the left side | 1, 2, 3 … 1,048,576 rows total. Click a row number to select the entire row. Drag the border between row numbers to resize the row height. |
| Cells | The main grid area | The intersection of a column and a row — addressed as Column+Row (e.g., B3 = Column B, Row 3). Over 17 billion cells per sheet. The active cell has a green border. |
| Select All Button | Top-left corner, above row 1 and left of column A | Click this triangle to select every cell in the entire worksheet instantly. Keyboard equivalent: Ctrl+A |
| Sheet Tabs | Bottom of the workbook area | Each tab is one worksheet (Sheet1, Sheet2, etc.). Click to switch sheets. Right-click for rename, colour, insert, delete, move, copy options. The + button adds a new sheet. |
| Scroll Bars | Right side (vertical) and bottom (horizontal) | Navigate around large worksheets. Scroll with the mouse wheel (vertical) or Shift+wheel (horizontal). |
| Status Bar | Very bottom of the window | Shows mode (Ready / Enter / Edit), and when cells with numbers are selected: Average, Count, Sum (and Min, Max if enabled). View buttons and Zoom slider are on the right. |
| Zoom Slider | Bottom-right of the Status Bar | Drag left to zoom out (see more cells), drag right to zoom in (see larger text). Ctrl+scroll wheel also zooms. |
Every cell has a unique address — a combination of its column letter and row number:
A range is a group of cells. Ranges are written with a colon between the first and last cell:
| Range | Meaning |
|---|---|
A1:A10 | Cells A1 through A10 — a vertical column of 10 cells |
A1:E1 | Cells A1 through E1 — a horizontal row of 5 cells |
B2:D6 | A rectangle of cells from B2 to D6 — 3 columns × 5 rows = 15 cells |
A:A | The entire column A (all 1,048,576 rows) |
1:1 | The entire row 1 (all 16,384 columns) |
A1:A10,C1:C10 | Two separate ranges selected together (non-contiguous) — use a comma to separate |
| Limit | Value |
|---|---|
| Maximum columns per sheet | 16,384 (A through XFD) |
| Maximum rows per sheet | 1,048,576 |
| Maximum cells per sheet | 17,179,869,184 (over 17 billion) |
| Maximum sheets per workbook | Limited only by available RAM (typically hundreds to thousands) |
| Characters per cell | 32,767 |
Occasionally Excel switches to R1C1 reference style — where columns are numbered (1, 2, 3) instead of lettered (A, B, C). This happens when the option is accidentally enabled. The cell reference style changes from "A1" to "R1C1".
=R[-1]C instead of =A1.
How to fix it:
| Shortcut | Navigation Action |
|---|---|
| ↑ ↓ ← → | Move one cell in any direction |
| Enter | Confirm entry and move down to the next cell |
| Tab | Confirm entry and move right to the next cell |
| Shift+Enter | Move up |
| Shift+Tab | Move left |
| Ctrl+Home | Jump to cell A1 (top-left of the sheet) |
| Ctrl+End | Jump to the last used cell in the sheet |
| Ctrl+→ | Jump to the last cell with data in the row (or first empty cell) |
| Ctrl+↓ | Jump to the last cell with data in the column |
| Page Up / Page Down | Move one screen up or down |
| Ctrl+G or F5 | Go To — jump to any specific cell address by typing it |
| Name Box click → type address → Enter | Jump directly to any cell — e.g., type D50 and press Enter to go to cell D50 |
The Ribbon is the command centre of Excel. Each tab contains a different set of tools grouped logically. You will use these constantly — knowing which tab holds which tool is essential.
| Tab | What It Contains | You Use It For |
|---|---|---|
| File | New, Open, Save, Save As, Print, Share, Export, Account, Options | All file operations and Excel settings — also called the Backstage View |
| Home | Clipboard, Font, Alignment, Number, Styles, Cells, Editing | 90% of everyday formatting — font, alignment, number format, cell colour, insert/delete rows, sort and filter |
| Insert | Tables, Illustrations (pictures, shapes, SmartArt), Charts, Sparklines, Filters (Slicers), Links, Text (Headers/Footers, WordArt), Symbols | Adding new elements to the spreadsheet — charts, images, tables, hyperlinks, symbols |
| Page Layout | Themes, Page Setup (Margins, Orientation, Size, Print Area), Scale to Fit, Sheet Options | Preparing for printing — setting margins, paper size, gridlines, headers, repeat rows/columns |
| Formulas | Function Library (Insert Function, AutoSum, Recently Used, Financial, Logical, Text, Date, Math, etc.), Defined Names, Formula Auditing, Calculation | All formula and function tools — inserting functions, naming ranges, tracing precedents/dependents, toggling calculation mode |
| Data | Get & Transform Data, Queries & Connections, Sort & Filter, Data Tools (Data Validation, Remove Duplicates, Text to Columns), Forecast, Outline | Importing, transforming, sorting, filtering, validating, and analysing data |
| Review | Proofing (Spelling, Thesaurus), Accessibility, Insights, Language, Comments, Notes, Protect (Sheet, Workbook) | Checking content, adding comments, and protecting sheets and workbooks with passwords |
| View | Workbook Views (Normal, Page Break Preview, Page Layout, Custom Views), Show (Ruler, Gridlines, Formula Bar, Headings), Zoom, Window (Freeze Panes, Split, Arrange) | Controlling how the spreadsheet appears on screen — freezing panes, splitting windows, zooming |
| Developer (hidden by default) | Macros, Visual Basic, Record Macro, Form Controls, XML, ActiveX Controls | VBA macros, form controls, and advanced automation — must be enabled first |
| Contextual Tabs (appear automatically) | Table Design, Chart Design, Chart Format, Picture Format, Drawing Format, etc. | Appear in the Ribbon only when a specific object (table, chart, image, shape) is selected — provide object-specific tools |
The search bar at the top of the Ribbon (magnifying glass icon, or press Alt+Q) lets you type any command name and find it instantly — without knowing which tab it lives on. Type "freeze" → it shows the Freeze Panes option. Type "pivot" → it offers to create a pivot table. This is the fastest way to find a rarely used feature.
| Term | What It Is | Analogy |
|---|---|---|
| Workbook | The entire Excel file (saved as .xlsx) — contains all the worksheets | A physical binder |
| Worksheet (Sheet) | A single tab/page of cells within the workbook | A page inside the binder |
| Cell | One individual box on the worksheet — holds one value, formula, or text entry | One cell in a grid |
| Shortcut | Action |
|---|---|
| Ctrl+Page Down | Move to the next sheet (right) |
| Ctrl+Page Up | Move to the previous sheet (left) |
Excel saves a recovery version of your workbook every 10 minutes by default. If Excel crashes:
| Action | Shortcut | Notes |
|---|---|---|
| Undo | Ctrl+Z | Reverses the last action. Press repeatedly to undo multiple steps (up to 100 levels). Click the dropdown ▾ on the Undo button to undo multiple steps at once. |
| Redo | Ctrl+Y | Re-applies an action that was undone. Also used to repeat the last action (e.g., repeat formatting on the next cell). |
The QAT sits above the Ribbon — add your most-used commands for one-click access:
Q1: Your column headers are showing numbers (1, 2, 3) instead of letters (A, B, C). What is this called and how do you fix it?
✓ This is called the R1C1 reference style. To fix it: File → Options → Formulas → untick "R1C1 reference style" → OK. Column headers immediately revert to A, B, C.
Q2: You are working in cell D15. What shortcut takes you directly back to cell A1 without using the mouse?
✓ Press Ctrl+Home. This jumps to cell A1 from anywhere in the worksheet.
Q3: What is the difference between a Workbook and a Worksheet?
✓ A Workbook is the entire Excel file (.xlsx) — like a binder. A Worksheet (or Sheet) is one individual page/tab within that workbook — like a page inside the binder. One workbook can contain many worksheets.
Q4: What does the range B3:E7 refer to?
✓ It is a rectangular block of cells starting at B3 (column B, row 3) and ending at E7 (column E, row 7). This includes 4 columns (B, C, D, E) and 5 rows (3, 4, 5, 6, 7) = 20 cells total.
Q5: You accidentally deleted an entire column of data. What keyboard shortcut restores it?
✓ Press Ctrl+Z (Undo). This immediately reverses the last action and restores the deleted column. Continue pressing Ctrl+Z to undo additional previous actions if needed.
Q6: Which Ribbon tab would you use to: (a) change the font colour of a cell; (b) insert a chart; (c) set page margins for printing; (d) remove duplicate rows from a list?
✓ (a) Home tab — Font group → Font Color. (b) Insert tab — Charts group. (c) Page Layout tab — Page Setup group → Margins. (d) Data tab — Data Tools group → Remove Duplicates.