Introduction to Excel

What is Excel?

Microsoft Excel is a spreadsheet application. Data sits in cells arranged in columns (A, B, C...) and rows (1, 2, 3...), and every cell can hold a number, text, or a formula that calculates from other cells. Excel is used for budgets, reports, data analysis and dashboards.

Workbook and Worksheets

• A file is a workbook (.xlsx) containing one or more sheets.
• Sheet tabs are at the bottom; right-click to rename, add or color them.
• A reference like Sheet2!A1 points to cell A1 on Sheet2.

The Excel Window

• Name Box - shows the active cell address; type a range to jump there.
• Formula Bar (fx) - shows and edits the cell content or formula.
• Ribbon tabs - Home, Insert, Page Layout, Formulas, Data, Review, View.
• Status bar - shows Sum/Average/Count of selected cells automatically.

Selecting Ranges

• One cell: click it. A range: click-drag, or Shift+click.
• Whole column/row: click the letter/number. Entire sheet: Ctrl+A.
• Ctrl+arrow jumps to the edge of data - perfect for long lists.

Basic Navigation Shortcuts

Tab        next cell right
Ctrl+Home  A1
Ctrl+End   last used cell
F2         edit the active cell
Ctrl+PageDown / PageUp   switch sheets

Key Points

• Everything in Excel lives in a cell address - formulas connect them.
• The Formula Bar is your control room for what a cell really contains.
• Learn ranges and navigation keys - they make every later step faster.