Excel Basics

Meet the spreadsheet grid

Think of Excel like a city map: columns are labeled with letters (A, B, C), rows with numbers (1, 2, 3), and each cell has an address like B3. That address system is what makes Excel powerful—you can store data, then point to it exactly.

Imagine tracking a school club fundraiser:

• A1: Item
• B1: Quantity
• C1: Price
• D1: Total

Then rows below might contain:

• A2: Cookies
• B2: 12
• C2: 3.50

Excel can hold text, numbers, and dates in the same sheet. The formula bar lets you see or edit what is inside the selected cell. The key habit: click a cell, read its address, and know whether you're entering data or a formula.

Entering data and using formulas

A spreadsheet becomes useful when cells can calculate. In Excel, formulas always begin with =. If B2 contains 12 and C2 contains 3.50, then in D2 you can type:

=B2*C2

That multiplies quantity by price, giving 42. You can also add values:

=SUM(D2:D6)

This totals all values from D2 through D6. Excel treats formulas like instructions, not plain text. If you type B2*C2 without the =, Excel just sees words.

A good mental model: data cells are ingredients; formula cells are recipes. Change an ingredient, and the recipe updates automatically. That is the real magic of spreadsheets—one edit can update an entire budget, schedule, or inventory list in seconds.

Formatting makes data readable

Raw numbers are like groceries left in bags—usable, but messy. Formatting organizes them so people can understand them fast. If a cell contains 3.5, you can format it as Currency to display $3.50. A date like 4/20/2026 can be shown in different date styles without changing the underlying value.

Useful formatting tools include:

• Bold headers to separate labels from data
• Borders to define tables
• Fill color to highlight important rows
• Number formats like Currency, Percentage, and Date
• AutoFit to resize columns so text isn't cut off

For example, if C2:C6 stores prices and D2:D6 stores totals, formatting both as Currency makes your sheet instantly clearer. Excel isn't just about correct answers—it's about presenting information so others can trust and use it.

Manipulating spreadsheets efficiently

Once data is in place, Excel helps you work faster. You can copy and paste formulas, drag the fill handle to repeat patterns, and sort or filter data to find what matters. Suppose rows 2 to 10 list fundraiser items. If D2 contains =B2*C2, drag the fill handle down to D10 and Excel adjusts each row automatically.

You can also:

• Insert or delete rows and columns
• Rename worksheets like January Sales or Volunteer Hours
• Sort by highest total to see top-selling items
• Filter to show only Cookies or only sales above $50

The beginner superpower is this: build a clean table, use formulas once, then let Excel repeat the work. A spreadsheet is less about typing more—and more about designing smart structure once.