Spreadsheet Basics for Beginners: Cells, Formulas and Charts
A spreadsheet arranges information in rows and columns and calculates results automatically. It is useful for budgets, lists, schedules and simple data analysis. This guide covers the basic ideas that apply to Microsoft Excel, Google Sheets and similar programs.
Cells, rows and columns
Each box is a cell, identified by its column letter and row number, such as B3. A cell can hold text, a number or a formula. Select a cell by clicking it, then type. Press Enter to move down, or Tab to move across.
Write a formula
A formula starts with an equals sign. For example, typing =B2+B3 adds the values in those two cells. Use the function SUM for a range, such as =SUM(B2:B10). Formulas update automatically when the numbers change, which is the main reason to use a spreadsheet.
Common functions
| Function | What it does | Example |
|---|---|---|
| SUM | Adds numbers | =SUM(B2:B10) |
| AVERAGE | Finds the average | =AVERAGE(B2:B10) |
| COUNT | Counts numbers in a range | =COUNT(B2:B10) |
| IF | Chooses a result based on a condition | =IF(B2>100,"High","Low") |
Keep the data clean
Put one kind of information in each column, with a heading at the top. Avoid merged cells in data tables, because they make sorting and formulas harder. Keep dates in a date format rather than as text so you can sort and calculate with them.
Sort and filter
Use the Sort and Filter buttons to arrange rows by a column, or to show only the rows that match a condition. Filters are useful for finding items in a long list without deleting anything.
Make a simple chart
Select the data, including the headings, then insert a chart from the Insert menu. Choose a bar chart for comparing items and a line chart for changes over time. Give the chart a clear title and label the axes.
Protect your work
Save a copy before large changes. If you share the file, check the sharing settings so that only the right people can edit it.
Frequently asked questions
Why does my formula show the formula text instead of a result?
The cell may be formatted as text. Change the format to General or Number, then type the formula again.
Should I learn Excel or Google Sheets?
The basics are the same. Excel has more advanced features for analysis. Google Sheets is free and works well for sharing and collaboration.
Freeze the header row
When a table is longer than the screen, freeze the top row so the column names stay visible as you scroll. In Excel, use View and then Freeze Panes. In Google Sheets, use View and then Freeze. This small step prevents mistakes when you enter numbers at the bottom of a long list.
Use absolute references for fixed values
When a formula must always point to the same cell, such as a tax rate in B1, add dollar signs so the reference does not move when you copy the formula down. Write =B2*$B$1 for the first row and copy it. This is one of the most useful habits for budgets and price lists.
Related reading
- How to Back Up Your Computer: A Simple 3-2-1 Plan: A simple backup plan for home computers using the 3-2-1 rule, with built-in tools on Windows and Mac and cloud storage for important files.
- How to Uninstall Programs Properly on Windows and Mac: The right way to remove programs from Windows and Mac, how to clean leftover files, and how to avoid removing something you still need.
- How to Use a VPN: What It Does and What It Does Not Do: What a VPN does for privacy and public Wi-Fi, what it cannot protect against, and how to choose and set up a reputable VPN service.