Excel Basics & Formatting
Master the foundational canvas of data analysis: understand the workbook hierarchy, navigate the Excel interface, edit data with confidence, format numbers and currencies, use Wrap Text, and build clean professional worksheets.
Introduction: What Is Excel?
Microsoft Excel is the world's most widely used electronic spreadsheet software. A spreadsheet is an interactive grid of vertical columns and horizontal rows used to organize, format, calculate, and analyze quantitative data.
Whether tracking monthly department budgets, calculating student exam grade averages, managing inventory for an e-commerce store, or preparing raw datasets for SQL and Python pipelines, Excel is the universal starting point for data analysts worldwide.
Understanding the Excel Workbook
To work effectively in Excel, you must understand its fundamental hierarchy:
Workbook vs. Worksheet
A Workbook is the master container file saved on your computer. Inside the workbook, individual Worksheets(sheet tabs like "Sales", "Q1_Expenses") hold separate tables of data.
Rows, Columns & Cell Addresses
Columns are vertical (A, B, C...); Rows are horizontal (1, 2, 3...). The intersection is a Cell with a unique address (Column first: B4). A group of contiguous cells is a Range (A1:D10).
Understanding the Excel Interface
When you launch Excel, you are presented with a clean, standardized workspace designed for data navigation:
The primary command center organizing Excel features into task-oriented tabs (Home, Insert, Page Layout, Formulas, Data).
Entering and Editing Data
Entering data into Excel follows distinct keyboard rules:
| Data Type | Default Alignment | Examples | Important Rule |
|---|---|---|---|
| Text | Left-aligned | Customer Name, TX-892 | Excel treats any cell with letters as non-numeric text. |
| Numbers | Right-aligned | 1420, 99.50 | Never type dollar signs ($) or commas manually; apply number formatting instead. |
| Dates | Right-aligned | 2026-08-23, 23/08/2026 | Excel stores dates internally as sequential serial numbers starting from Jan 1, 1900. |
Typing immediately in a selected cell overwrites its existing contents completely. To edit part of a cell without deleting the rest, press F2 (Windows) or double-click the cell!
Rows, Columns, AutoFit & the Fill Handle
AutoFit Column Width
If numbers exceed column width, Excel shows ### errors. Double-clicking the thin divider between column headers (e.g. between Column A and B) automatically sizes the column to fit the widest entry.
The Fill Handle (AutoFill)
The small square at the bottom-right corner of the active cell. Dragging it down continues sequences (1, 2 → 3, 4, 5; Jan, Feb → Mar, Apr) or copies formulas effortlessly.
Number Formatting: Values vs. Displayed Appearance
Formatting changes how data looks, not what it is. If cell A1 contains 1250.5 and you click the Currency button, Excel displays $1,250.50. The underlying stored value is still 1250.5.
Wrap Text vs. Merge & Center Pitfalls
Wrap Text
Wraps long text into multiple lines within a single cell. Keeps your columns neat, maintains grid integrity, and allows full sorting and filtering.
Merge & Center
Combines multiple cells into one. Acceptable only for standalone report title banners at the top of a sheet. Never merge cells inside a dataset!
Freeze Panes & Clean Worksheet Architecture
Excel Formatting Best Practices Checklist
- Left-align text and right-align numbers for effortless scanning.
- Always format financial numbers with Currency ($) or Accounting formats.
- Use AutoFit to ensure no column displays clipped text or
###errors. - Use subtle header fills (slate, soft navy, or muted green) rather than harsh saturated neon colors.
- Keep data in a continuous uniform grid — never merge cells inside data rows.
- Use Freeze Top Row on tables longer than 20 rows to keep column labels visible.
🔥 Live Interactive — Excel Basics & Formatting Lab
Select cells in the interactive spreadsheet and test formatting tools (Bold, Alignment, Currency, Borders, AutoFit) in real time.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Product Name | Category | Quantity | Unit Price | Total Revenue |
| 2 | Mechanical Keyboard | Hardware | 14 | $89.50 | $1,253.00 |
| 3 | Wireless Mouse | Accessories | 28 | $29.99 | $839.72 |
| 4 | USB-C Fast Cable | Cables | 50 | $12.50 | $625.00 |
| 5 | 4K IPS Monitor | Hardware | 8 | $349.00 | $2,792.00 |
Apply professional formatting decisions step-by-step to transform a messy raw table into a publication-ready report.