Google Sheets for beginners

What Google Sheets is

Google Sheets is a spreadsheet application that runs in a web browser and is also available through mobile apps. A spreadsheet gives you a grid for recording information, calculating with that information, and arranging it so patterns are easier to see. People use Sheets for budgets, class lists, schedules, inventory, survey results, project trackers, and many other jobs built around rows of related data.

A Sheets file is called a spreadsheet. One spreadsheet can contain several sheets, shown as tabs along the bottom. That distinction matters when a coworker says to open the spreadsheet but update the Budget sheet. The spreadsheet is the whole file; the sheet is one tab inside it. Begin with one clearly named sheet and add tabs only when the information has a real reason to be separated.

Cells, rows, columns, and ranges

Every box in the grid is a cell. Columns use letters across the top, and rows use numbers down the left side. A cell address combines both: B3 means column B, row 3. The active cell has a highlighted border. Whatever you type goes into that active cell, so look at the address box or border before entering a value. This habit prevents many accidental overwrites.

A row usually represents one record, such as one invoice, student, product, or task. A column usually represents one field shared by those records, such as amount, score, price, or status. Put column labels in the first row and keep one kind of information in each column. If column B is Amount, do not mix amounts, notes, and dates in it. Consistent columns make formulas, sorting, and filtering far more predictable.

A range is a group of cells. A colon joins the first and last address: B2:B10 means every cell from B2 through B10, while A2:C10 covers a rectangle three columns wide. You can select a range by dragging, by holding Shift while moving with the arrow keys, or by typing its address into a formula. Ranges are central to spreadsheet work because most useful formulas calculate across more than one cell.

• Cell: one box, identified by a column letter and row number.
• Row: a horizontal line of cells, often used for one record.
• Column: a vertical line of cells, often used for one field.
• Range: a continuous group of cells, written from the first address to the last.

Enter and clean up data

Click a cell, type a value, and press Enter to place the value and move down. Press Tab to move right instead. Double-click a cell or use the formula bar when you need to edit part of an existing entry. Escape cancels an edit before it is applied. These small movements become much faster than reaching for the mouse after every value, especially when you are filling a compact table.

Sheets can hold text, numbers, dates, times, checkboxes, and formulas. What looks similar on screen may behave differently in calculations. The text $25 and the numeric value 25 with currency formatting are not the same kind of value. Prefer a number with a number format when you plan to add, average, sort, or compare it. Formatting changes how a value appears; it should not replace a usable underlying value.

Keep the source data tidy before adding calculations. Use one header row, avoid blank rows inside the table, and do not merge cells in the data area. Merged headings may look polished, but they make selection and sorting harder. If a value belongs to every row, repeat it in its own column instead of using a visual label above several records. A clean rectangle is the most reliable starting point for formulas and filters.

Write your first formulas

A formula starts with an equals sign. To add the values in B2 and B3, click an empty cell and type =B2+B3, then press Enter. Sheets calculates the result and keeps the formula behind it. Change either source value and the result updates. This link between inputs and results is the main reason to use a formula instead of calculating elsewhere and typing the answer by hand.

You can use the familiar arithmetic operators: plus for addition, minus for subtraction, an asterisk for multiplication, and a slash for division. Parentheses control the order. The formula =(B2+C2)*D2 adds B2 and C2 before multiplying by D2. Without the parentheses, multiplication happens first. When a formula grows difficult to read, split the work into a few clearly labeled columns instead of compressing every step into one cell.

Cell references change when you copy a formula. If D2 contains =B2*C2 and you copy it down one row, D3 becomes =B3*C3. This relative behavior is useful because the same calculation can follow each record. A dollar sign can lock a row or column when one reference must stay fixed, such as a tax rate stored in F1. The formula =B2*$F$1 keeps F1 fixed as it moves down.

Errors are information, not a reason to replace the formula with a typed result. #DIV/0! usually means a division used zero or an empty denominator. #REF! means a reference is no longer valid. #N/A often means a lookup or filter found no match. Read the formula, confirm its references, and inspect the source cells. Correcting the cause keeps the sheet dependable when new data arrives.

Functions and formulas

A formula is the complete expression that begins with an equals sign. A function is a named operation used inside a formula. In =SUM(B2:B10), the whole entry is a formula and SUM is the function. Functions package common work into a recognizable form. SUM adds values, AVERAGE returns the arithmetic mean, COUNT counts numeric values, and IF chooses between results based on a logical test.

Function syntax tells you what goes inside the parentheses. SUM(value1, [value2, ...]) requires the first value or range, while the square brackets show optional additional arguments. You do not type the square brackets. A comma separates arguments, and a colon defines a continuous range. That distinction explains why =SUM(B2,B10) adds two cells while =SUM(B2:B10) adds the entire range.

Start with functions whose purpose you can explain in one sentence. Use SUM for a total, AVERAGE for a mean, COUNT for numeric entries, and COUNTA for all filled values. Then add conditional functions such as IF, COUNTIF, and SUMIF. Lookup and array functions become much easier after ranges and basic conditions feel ordinary. The goal is not to memorize a catalog; it is to recognize the operation your data needs.

Functions can be nested, meaning one function supplies an argument to another. Sheets calculates the innermost function first. Nesting is useful, but depth is not a sign of quality. A helper column with a clear heading may be safer than four functions packed together. Choose a structure another person can inspect. If you cannot describe the calculation without rereading it several times, simplify the sheet.

Sort and filter a table

Sorting changes row order based on the values in one or more columns. Select the complete table, including every column that belongs to each record, before sorting a range. If you sort only the Amount column and leave the Invoice column behind, the amounts can become attached to the wrong invoices. Tell Sheets whether the range has a header row, then choose the column and ascending or descending order.

A filter keeps the rows in place but hides records that do not meet the selected condition. You might show only tasks with an Open status or invoices above a chosen amount. Create the filter over the full table so the row remains one unit. The filter icon in each header lets you select values, define conditions, or sort. Remove the filter when you need to see every row again.

Shared files need extra care. A regular filter is visible to other people with access, and editors can change it. A filter view applies the filtered view separately and can be named and saved. Use a filter view when several people need different views of the same data. Regardless of the tool, confirm the visible row count before drawing a conclusion; a hidden filter can make a complete table look incomplete.

Sorting and filtering are ways to inspect data, not replacements for clean structure. If one cell contains several statuses or a header spans multiple rows, the controls cannot reliably interpret the table. Return to one record per row and one field per column. Once that shape is stable, the same table can support manual filters, formulas such as FILTER and SORT, and later summaries.

Share a spreadsheet safely

The Share control lets the owner give specific people access or create a link, subject to account and organization settings. The main roles are Viewer, Commenter, and Editor. A viewer can read the file, a commenter can leave feedback without changing cell values, and an editor can change the spreadsheet. Give the lowest level that fits the job. Someone checking a report usually does not need edit access.

Before inviting editors, make the sheet understandable without a private explanation. Use a clear file name, descriptive tab names, a stable header row, and notes for unusual inputs. Keep raw data separate from presentation areas when practical. If a formula column should not be typed over, explain that near the heading and consider protection settings available in Sheets. Clear structure prevents more mistakes than color alone.

Sharing does not make every change harmless. Editors may be able to alter formulas, sort ranges, or change permissions, depending on the file and folder settings. Check who has access when a project changes. Remove people who no longer need the file, and avoid broad link access for information that should stay limited. Work or school administrators may also restrict external sharing.

Comments are useful for questions tied to a cell or range. Put the data itself in cells and use comments for discussion, not as the only place where an important value exists. When a decision is final, update the relevant field so the table remains the current record. A spreadsheet works best when its structure shows the state of the work without requiring someone to reconstruct a conversation.

What to learn next

Practice the core actions until they no longer compete for attention: select a cell, enter or edit a value, identify a range, write a formula, and copy it down. Then learn SUM, AVERAGE, COUNT, and simple IF statements. Those skills cover a large share of beginner work and provide the vocabulary needed for lookup, conditional, and array functions later.

Build one small sheet around a real question. A weekly expense table can use Date, Category, Description, and Amount columns, followed by a SUM total and a filter by category. A task list can use Owner, Due date, Status, and Notes, then sort by due date and filter open work. A concrete table exposes gaps faster than reading isolated tips.

Accuracy comes from checking your work. Change one input and confirm the expected result changes. Compare a small formula with a total you can calculate mentally. Inspect the first and last cells in every range. Clear any active filter before saying how many records exist. These checks are quick, and they teach you how the spreadsheet responds rather than asking you to trust a formula because it looks plausible.

The first Sheets Exercises lesson starts in a browser grid with no account required. It asks you to enter data, use a range, and complete a short calculation with immediate deterministic feedback. Continue through the free module for shortcuts, SUM and AVERAGE, cell references, sorting, and filtering. Each lesson adds one small skill to the same basic mental model.