Excel Basics and Formatting:
A Complete Beginner's Guide

Microsoft Excel is one of the most widely used tools for working with data. At first, Excel can look simple: a large grid made of rows and columns where you type numbers or text. But that simple grid is actually the foundation of a powerful system for organizing, calculating, analyzing, and presenting information.

You can use Excel for simple tasks such as:

• Making a personal budget
• Tracking expenses
• Creating a student marksheet
• Maintaining employee records
• Creating sales reports
• Managing inventory
• Calculating salaries
• Analyzing business data
• Creating charts and dashboards
• Cleaning and preparing data for analysis

At its simplest, Excel gives you a grid where you can place information:

Name    Age   City
Rahul   22    Mumbai
Priya   24    Pune
Aman    21    Delhi

You can tell Excel to calculate something like 10 + 20 + 30 and Excel can automatically produce 60.

Before learning cells and formatting, you should understand three basic terms:

• Workbook: An Excel file is called a workbook (e.g. Sales_Report.xlsx). Think of a workbook like a notebook.
• Worksheet: Inside a workbook, you can have one or more worksheets (e.g. January, February, March, Summary). Think of a worksheet like a page inside a notebook.
• Cell: A worksheet is made up of cells. A cell is the basic location where you enter information.

Sales_Report.xlsx
│
├── January
├── February
├── March
└── Summary

Excel organizes cells into rows and columns:

• Columns: Run vertically and are identified using letters (A, B, C, D... up to 16,384 columns ending at XFD).
• Rows: Run horizontally and are identified using numbers (1, 2, 3, 4... up to 1,048,576 rows).

The combination of a column letter and row number identifies a cell (e.g. A1 = Column A, Row 1; B3 = Column B, Row 3). This is called the cell reference.

 A          B          C
┌──────────┬──────────┬──────────┐
│ Product  │ Quantity │ Price    │ (Row 1)
├──────────┼──────────┼──────────┤
│ Laptop   │ 2        │ 50000    │ (Row 2)
├──────────┼──────────┼──────────┤
│ Mouse    │ 5        │ 1000     │ (Row 3)
└──────────┴──────────┴──────────┘

For example, typing =B2*C2 tells Excel to take the value from B2 (2) and multiply it by C2 (50000) to output 100000.

A cell can contain different kinds of information:

• Text: Names, cities, product names, or descriptions (e.g. "Rahul", "Mumbai", "Laptop").
• Numbers: Values that Excel can use in calculations (e.g. 100, 250, 50.75, -25).
• Dates: Date serial values (e.g. 12/08/2026, 15-Mar-2026).
• Times: Time values (e.g. 14:30:00).
• Formulas: Instructions beginning with = (e.g. =10+20 or =A1+B1).
• Logical Values: TRUE or FALSE.

The Formula Bar is the area where you can view or edit the exact contents or formula of the currently selected cell.

A single cell is referenced as A1, while a range of cells is referenced as A1:C5 (all cells from A1 through C5).

 A        B        C
┌────────┬────────┬────────┐
│ SELECT │ SELECT │ SELECT │ (Row 1)
├────────┼────────┼────────┤
│ SELECT │ SELECT │ SELECT │ (Row 2)
├────────┼────────┼────────┤
│ SELECT │ SELECT │ SELECT │ (Row 3)
└────────┴────────┴────────┘

Formatting means changing the appearance or display of your data without altering the underlying raw data itself.

UNDERLYING VALUE
 │
 ↓
 50000
 │
 │ (Formatting Applied)
 ↓
DISPLAYED VALUE
 │
 ↓
 ₹50,000

Good formatting creates visual structure and hierarchy:

• Font & Size: Title ➔ Section Heading ➔ Column Header ➔ Normal Data.
• Bold: Use bold selectively for important summaries (e.g. TOTAL rows).
• Font & Fill Color: Color should have clear meaning (e.g. green for profit, red for loss). Avoid turning every cell into a different color!
• Borders: Separate header rows and total rows to make worksheets easier to scan.
• Alignment: Left-align text; Right-align numbers; Center headers/dates.

Numbers are displayed differently depending on their format (General, Number, Currency, Accounting, Percentage, Date).

For example, 0.25 formatted as Percentage displays as 25%. Displaying fewer decimal places (e.g. 25.68 instead of 25.67891) changes only the display, while calculations continue using the full precision value!

Use AutoFit Column Width to prevent text truncations. Use Wrap Text to display multi-line descriptions inside a single cell without stretching column width.

               EXCEL WORKSHEET
                      │
            ┌─────────┴─────────┐
            ↓                   ↓
          DATA             PRESENTATION
       What it says        How it looks
       (Numbers/Text)      (Colors/Fonts/Borders)

Converting a range into an official Excel Table (Ctrl + T) provides automatic filter arrows, table styles, banded rows, and dynamic structured references.

Conditional Formatting highlights cells automatically when a specific condition is met (e.g. If Sales > 50000).

Clearing Formats: Clear Contents removes data but leaves formatting intact. Clear Formats removes formatting while keeping underlying values.

Professional Formatting Workflow:

RAW DATA ➔ Understand Data ➔ Identify Headers ➔ Check Data Types
  ➔ Fix Column Widths ➔ Format Numbers/Dates ➔ Format Headers ➔ FINAL WORKSHEET

Common Beginner Mistakes to Avoid:

• Mistake 1: Using manual spaces to align data.
• Mistake 2: Mixing text and numbers in the same column ("50000" vs "50k").
• Mistake 3: Using different date formats everywhere.
• Mistake 4: Too many rainbow colors.
• Mistake 5: Excessive cell merging inside data ranges.