What Is Microsoft Excel?
Microsoft Excel is the world's most widely used spreadsheet application. It organises data in a grid of rows and columns, and provides powerful tools for calculation, analysis, visualisation, and automation.
Excel is used everywhere:
- Finance — budgets, financial models, P&L statements, cash flow forecasts
- Data Analysis — cleaning, summarising, and exploring datasets
- Business Reporting — dashboards, KPI tracking, management reports
- HR — employee databases, payroll calculations, attendance tracking
- Marketing — campaign tracking, ROI analysis, customer segmentation
Understanding Excel deeply is one of the fastest ways to become more productive in any professional role.
The Excel Interface
When you open Excel, you see:
┌──────────────────────────────────────────────────────────────┐
│ [Quick Access Toolbar] [Title Bar] [Account/Help] │
├──────────────────────────────────────────────────────────────┤
│ [Ribbon: Home | Insert | Page Layout | Formulas | Data ...] │
├──────────────────────────────────────────────────────────────┤
│ [Name Box] │ [Formula Bar ] │
├─────┬────────────────────────────────────────────────────────┤
│ │ A B C D E F │
│ 1 │ │
│ 2 │ [Cell Grid] │
│ 3 │ │
│ ...│ │
├──────────────────────────────────────────────────────────────┤
│ [Sheet1] [Sheet2] [+] [Zoom: 100%] [View Controls] │
└──────────────────────────────────────────────────────────────┘
Key UI Elements
| Element | Description |
|---|---|
| Name Box | Shows the address of the selected cell (e.g., A1) |
| Formula Bar | Shows and edits the content of the active cell |
| Ribbon | Tabbed toolbar with all Excel commands |
| Column Headers | Letters (A, B, C … XFD — 16,384 columns) |
| Row Headers | Numbers (1, 2, 3 … 1,048,576 rows) |
| Cell | Intersection of a row and column (e.g., B3) |
| Sheet Tab | Switch between worksheets in the workbook |
| Status Bar | Shows sum, average, count of selected cells |
Workbooks, Worksheets, and Cells
Workbook vs Worksheet
- Workbook — the Excel file (
.xlsx) — contains one or more worksheets - Worksheet (Sheet) — a single tab within the workbook — the actual grid of cells
- Cell — a single box identified by its column letter and row number (e.g., C5)
Cell References
A1 → Column A, Row 1
B3 → Column B, Row 3
Z100 → Column Z, Row 100
AA1 → Column AA (after Z comes AA, AB, ...), Row 1
Navigating Between Sheets
- Click a sheet tab at the bottom to switch
- Right-click a sheet tab: rename, move, copy, delete, colour
- Add a new sheet: click the + icon beside the last tab
- Shortcut to navigate sheets:
Ctrl + Page Up/Ctrl + Page Down
Navigating the Grid
Keyboard Shortcuts for Navigation
| Action | Shortcut |
|---|---|
| Move one cell | Arrow keys |
| Jump to last used cell in direction | Ctrl + Arrow |
| Go to cell A1 | Ctrl + Home |
| Go to last used cell | Ctrl + End |
| Move to next sheet | Ctrl + Page Down |
| Move to previous sheet | Ctrl + Page Up |
| Open Go To dialog | Ctrl + G or F5 |
| Jump to a specific cell | Type in Name Box → Enter |
Selection Shortcuts
| Action | Shortcut |
|---|---|
| Select entire row | Shift + Space |
| Select entire column | Ctrl + Space |
| Select to last used cell in direction | Ctrl + Shift + Arrow |
| Select entire sheet | Ctrl + A |
| Extend selection | Hold Shift + Arrow / Click |
Entering Data
Types of Data
| Type | Example | Default Alignment |
|---|---|---|
| Text | Priya Sharma, Finance | Left |
| Number | 75000, 3.14 | Right |
| Date | 15/06/2026, Jun-2026 | Right |
| Formula | =A1+B1, =SUM(A1:A10) | Depends on result |
| Boolean | TRUE, FALSE | Center |
Entering and Confirming Data
- Type content → press Enter (moves down) or Tab (moves right)
- Press Escape to cancel before confirming
- Press F2 to edit the active cell
- Start a formula with
=
Type: 75000 → Enter → number entered
Type: Finance → Enter → text entered
Type: =A1*12 → Enter → formula entered
Entering Data in Multiple Cells at Once
- Select a range (e.g., A1:A5), type a value, press Ctrl + Enter → fills all selected cells
- Type in one cell, select more, press Ctrl + D (fill down) or Ctrl + R (fill right)
Workbook Basics
Creating, Saving, and Opening
| Action | Shortcut |
|---|---|
| New workbook | Ctrl + N |
| Open workbook | Ctrl + O |
| Save | Ctrl + S |
| Save As | F12 |
| Close workbook | Ctrl + W |
| Undo | Ctrl + Z |
| Redo | Ctrl + Y |
File Formats
| Format | Extension | Use Case |
|---|---|---|
| Excel Workbook | .xlsx | Standard modern format |
| Excel Macro-Enabled | .xlsm | Required if file contains macros |
| Excel Binary | .xlsb | Faster for very large files |
| CSV | .csv | Simple text, no formatting, universal |
.pdf | Share read-only formatted report |
The Ribbon
The Ribbon organises commands into tabs. Most-used tabs:
| Tab | Key Functions |
|---|---|
| Home | Font, alignment, number format, clipboard, conditional formatting |
| Insert | Charts, tables, pivot tables, images, shapes |
| Page Layout | Print settings, themes, margins |
| Formulas | Function library, name manager, formula auditing |
| Data | Sort, filter, connections, Power Query, data validation |
| Review | Spell check, comments, protection |
| View | Freeze panes, split, zoom, window arrangements |
Essential Shortcuts
Memorising these will save hours every week:
| Action | Shortcut |
|---|---|
| Bold | Ctrl + B |
| Italic | Ctrl + I |
| Underline | Ctrl + U |
| Copy | Ctrl + C |
| Cut | Ctrl + X |
| Paste | Ctrl + V |
| Paste Special | Ctrl + Alt + V |
| Find | Ctrl + F |
| Find & Replace | Ctrl + H |
| Format Cells dialog | Ctrl + 1 |
| AutoSum | Alt + = |
| Insert current date | Ctrl + ; |
| Insert current time | Ctrl + Shift + ; |
| Insert new row | Right-click row header → Insert |
| Delete row | Right-click row header → Delete |
AutoFill — Excel's Time-Saving Feature
Excel can detect patterns and extend them automatically:
- Type a value or start a pattern in a cell
- Hover over the bottom-right corner of the cell until you see a black + (Fill Handle)
- Click and drag down/right to fill
What AutoFill can extend:
- Numbers:
1, 2, 3→ drag →4, 5, 6, ... - Dates:
Jan-26→Feb-26, Mar-26, ... - Days:
Monday→Tuesday, Wednesday, ... - Months:
January→February, March, ... - Custom lists (you can add your own)
- Formulas: adjusts cell references automatically
Flash Fill (Excel 2013+)
Flash Fill detects patterns in adjacent columns:
Column A Column B (you type the first few)
Priya Sharma → Priya
Raj Patel → Raj
Meera Singh → (press Ctrl+E → Excel fills: Meera)
Flash Fill is brilliant for splitting names, reformatting dates, extracting text patterns — without formulas.
Understanding Cell References (Preview)
There are three reference types — covered in depth in Chapter 2:
| Type | Example | Behaviour when copied |
|---|---|---|
| Relative | A1 | Adjusts to new position |
| Absolute | $A$1 | Never changes |
| Mixed | $A1 or A$1 | One part fixed, one adjusts |
Common Beginner Mistakes
1. Typing a formula without the = sign
75000 + 50000 → treated as text "75000 + 50000"
=75000 + 50000 → calculates to 125000 ✓
2. Storing numbers as text
If a cell shows a green triangle in the corner, it may be a number stored as text.
Numbers stored as text won't sum correctly.
Fix: select cells → "!" warning icon → Convert to Number
3. Mixing data types in a column
Avoid mixing dates, text, and numbers in the same column — it breaks sorting, filtering, and formulas.
4. Hard-coding values that should be formulas
Bad: Cell C1 = 7500 (manually calculated 10% of 75000)
Good: Cell C1 = A1*0.10 (calculated dynamically)
5. Not saving frequently
Ctrl + S every few minutes. Enable AutoRecover in File → Options → Save.
Practice Exercises
- Open a new workbook, create a sheet named "Employees", and enter: Name, Department, Salary as column headers in row 1. Add 5 rows of data.
- Use AutoFill to fill numbers 1–20 in column A.
- Use Flash Fill to extract first names from full names in column B.
- Navigate to cell Z100 using the Name Box, then return to A1 with a keyboard shortcut.
- Save your file as
practice.xlsx, then also save a copy aspractice.csv.
Summary
In this chapter you learned:
- Excel organises data in cells identified by column (letter) and row (number)
- A workbook contains one or more worksheets; the file is saved as
.xlsx - Key UI elements: Name Box, Formula Bar, Ribbon, Sheet Tabs, Status Bar
- Essential keyboard shortcuts for navigation, selection, and editing
- AutoFill extends patterns; Flash Fill detects and replicates text patterns
- Three cell reference types: relative, absolute (
$A$1), and mixed - Formulas must start with
=; numbers stored as text won't calculate correctly
Next up: Data Entry & Formatting — enter data efficiently, format numbers and dates, and apply styles to make your spreadsheets professional.