Read Spreadsheet Skills free: the opening pages

Getting Comfortable with the Spreadsheet

You opened a spreadsheet, saw a wall of tiny gray boxes, a ribbon packed with icons you have never clicked, and a blinking cursor in a cell called A1. Maybe a job posting asks for "proficiency in Excel." Maybe your manager just sent you a file and said "can you update the numbers by Friday?" Maybe a class project needs a chart and you have no idea where charts even live. You are not behind. Almost everyone who uses spreadsheets well today started exactly where you are, staring at the same grid and wondering where to click first.

This section gives you a map. By the end of it you will know what every part of the screen is called, how Excel and Google Sheets differ, how to move around without getting lost, and how to save and organize a file so you never lose work. Every later chapter assumes you know this vocabulary, so take your time here.

Excel or Google Sheets: which one should you learn?

Short answer: learn the shared core once and you can work in both. About 90 percent of what you do day to day (typing data, writing formulas, sorting, filtering, charts, pivot tables) works the same way in both programs. The formulas in this guide are written so they work in both unless a note says otherwise.

Here is how they compare in practice:

Question	Microsoft Excel	Google Sheets
Where does it run?	Desktop app (Windows, Mac), plus Excel for the web and mobile	In a web browser, plus mobile apps
Cost to you	Paid through Microsoft 365, though Excel for the web is free with a Microsoft account	Free with a Google account
Where files live	On your computer, or in OneDrive or SharePoint	In Google Drive, always online
Saving	Manual save, or AutoSave when the file is in OneDrive	Saves automatically after every change
Collaboration	Strong when the file is in OneDrive, weaker with emailed copies	Built in from day one, very easy
Power features	Deeper: Power Query, Power Pivot, more chart types, macros	Lighter but growing; great for shared trackers
What employers mean by "Excel"	Usually the desktop app	Often accepted as equivalent for basic tasks

Use this decision rule:

1. If a job description names Excel, practice in Excel. Excel for the web is free and handles everything in this guide except a few advanced extras.
2. If you work with a team that lives in Google Workspace, practice in Google Sheets.
3. If you are not sure, start with whichever you can open today. The skills transfer.

Pro tip: You do not need to buy anything to follow this guide. Go to office.com and sign in with a free Microsoft account to get Excel for the web, or go to sheets.google.com with a Google account. Both are enough for every exercise in these chapters.

Workbooks, worksheets and cells: the three words that matter most

A spreadsheet file has a structure, and once you see it the screen stops being confusing.

• Workbook: the whole file. In Excel it is usually saved as .xlsx. In Google Sheets it is called a spreadsheet and lives in Drive.
• Worksheet (or sheet): one page inside the workbook. You see the sheet tabs along the bottom of the screen, named Sheet1, Sheet2 and so on. A workbook can hold many sheets.
• Cell: one box in the grid. Every cell has an address made of its column letter and row number. The cell where column C meets row 5 is C5.
• Range: a block of cells. You write a range as the top left cell, a colon, and the bottom right cell. A1:D10 means every cell from A1 down to D10, which is 4 columns by 10 rows, or 40 cells.
• Column: a vertical line of cells, labeled with letters (A, B, C ... Z, then AA, AB and onward).
• Row: a horizontal line of cells, labeled with numbers.

Read addresses as "column first, row second." Saying "cell 5C" will confuse people. Saying "C5" will not.

Example: Picture a sheet listing three expenses. Cell A1 holds the word "Item", B1 holds "Cost", A2 holds "Rent", B2 holds 1200, A3 holds "Groceries", B3 holds 450, A4 holds "Phone", B4 holds 65. The costs live in the range B2:B4. Later you will total that range with =SUM(B2:B4) and get 1715.

A guided tour of the Excel screen

Open a blank workbook in Excel. From top to bottom, here is what you are looking at.

1. Title bar. Shows the file name. If the file is in OneDrive you will see an AutoSave switch at the top left.
2. Ribbon. The wide strip of buttons, organized into tabs: File, Home, Insert, Page Layout (or Draw), Formulas, Data, Review, View. Each tab has groups. For example, the Home tab has the Clipboard, Font, Alignment, Number, Styles, Cells and Editing groups.
3. Search box (Tell Me). At the top of the window. Type what you want ("freeze panes", "remove duplicates") and Excel offers the command. When you cannot find a button, use this first.
4. Name Box. The small box at the left, just above column A. It shows the address of the selected cell. You can also type an address into it (for example Z500) and press Enter to jump there.
5. Formula bar. The long box to the right of the Name Box, marked with the letters fx. It shows what is truly inside the selected cell. If a cell displays 1715 but contains =SUM(B2:B4), the formula bar shows the formula.
6. Column headers and row headers. The gray letters across the top and numbers down the side. Click a header to select the whole column or row.
7. The grid. Where you work. The selected cell has a thick green border, and the small square at its bottom right corner is the fill handle, which you will use constantly.
8. Sheet tabs. At the bottom. Click the plus sign to add a sheet. Double click a tab to rename it. Right click for options such as color, move, copy and delete.
9. Status bar. The bottom strip. Select several cells with numbers and look here: Excel shows the Average, Count and Sum without any formula. Right click the status bar to add Min, Max and Numerical Count.
10. Zoom slider and view buttons. At the bottom right. Normal, Page Layout and Page Break Preview views live here.

The status bar is the fastest calculator you have. Before you write a formula to check a total, select the cells and glance at the bottom of the screen. It is how experienced people sanity check numbers in two seconds.

A guided tour of the Google Sheets screen

Open a blank spreadsheet at sheets.google.com. The layout is similar, with different names.

1. File name at the top left. Click "Untitled spreadsheet" to rename it. Beside it, a star (to favorite) and a cloud icon showing save status.
2. Menu bar: File, Edit, View, Insert, Format, Data, Tools, Extensions, Help. Sheets uses menus instead of a ribbon.
3. Toolbar: one row of icons under the menus for undo, print, zoom, currency, percent, decimals, font, bold, fill color, borders, merge, alignment, wrap, insert link, comment, chart, filter and functions.
4. Help search. Under the Help menu there is a "Search the menus" box (shortcut Alt+/ on Windows, Option+/ on Mac). It works like Excel's search box.
5. Name box and formula bar. Same idea as Excel, directly above the grid.
6. Grid, headers and sheet tabs. Same as Excel. Add sheets with the plus sign at the bottom left.
7. Explore or the quick sum box. Select numbers and the bottom right corner shows a Sum. Click it to switch to Average, Min, Max or Count.
8. Share button at the top right. This is where collaboration starts.

Moving around without the mouse

You can click your way around a small sheet, but real files have thousands of rows. These keys work in both programs (Mac users press Command where Windows says Ctrl, unless noted).

Key	What it does
Arrow keys	Move one cell
Enter / Shift+Enter	Move down / up after typing
Tab / Shift+Tab	Move right / left after typing
Ctrl+Arrow	Jump to the edge of the current block of data
Ctrl+Home	Jump to A1
Ctrl+End	Jump to the last used cell
Page Down / Page Up	Move one screen down or up
Ctrl+Page Down / Ctrl+Page Up	Next or previous sheet in Excel (in Sheets use Ctrl+Shift+Page Down / Up)

Try it: type a number in A1 and another in A1000. Click A1 and press Ctrl+Down Arrow. You land on A1000 instantly.

Selecting cells like you mean it

Almost every command acts on the selection, so selecting well is a core skill.

1. One cell: click it.
2. A range: click the first cell, hold Shift, click the last cell. Or click and drag.
3. To the end of the data: click a cell, then press Ctrl+Shift+Down Arrow. This selects everything below until the first blank cell.
4. A whole column: click the column letter, or press Ctrl+Space.
5. A whole row: click the row number, or press Shift+Space.
6. Cells that are not next to each other: select the first block, then hold Ctrl (Command on Mac) and select the next.
7. Everything: press Ctrl+A. Pressed inside a block of data, it selects that block. Press it again to select the whole sheet.

Warning: Ctrl+Shift+Down Arrow stops at the first empty cell. If your data has a gap in row 340, the selection stops at row 339 and you might sort or total only part of your data without noticing. Always glance at the status bar Count after selecting to confirm the number of cells matches what you expect.

Creating, saving and naming files so you can find them

Lost work is the most common beginner disaster, and it is completely preventable.

In Excel:

1. Press Ctrl+N for a new blank workbook.
2. Press Ctrl+S immediately, before you type much. Choose OneDrive if you have it, because that turns on AutoSave and version history.
3. Give the file a name that will make sense in six months.
4. Press Ctrl+S again every few minutes if AutoSave is off. Make it a reflex.

In Google Sheets:

1. Go to sheets.google.com and click Blank, or type sheets.new into your browser address bar.
2. Click "Untitled spreadsheet" and rename it right away. Untitled files pile up fast in Drive.
3. Move it into a folder: click the folder icon next to the file name.

Use a naming pattern so files sort in order. A reliable one is YYYY-MM topic version, for example 2026-10 Team Budget v2. Because the year comes first, files sort by date automatically.

File formats you will meet

Extension	What it is	When you see it
.xlsx	Standard Excel workbook	Almost every Excel file
.xlsm	Workbook with macros	Files that run automated scripts; only open from people you trust
.xls	Old Excel format (2003 and earlier)	Ancient files; save them as .xlsx
.csv	Comma separated values, plain text	Exports from websites, banks, CRMs; holds one sheet with no formatting or formulas
Google Sheets	Native online format	Files in Drive; download as .xlsx via File > Download

A CSV is important to understand. It holds only values. If you build formulas, colors and multiple sheets and then save as CSV, you lose all of it. When you open a CSV and do real work in it, save a copy as .xlsx (or import it into Sheets) before you start.

Action step: Create your practice workbook now. Name it Spreadsheet Practice. Rename Sheet1 to Basics by double clicking the tab. Add a second sheet called Formulas and a third called Projects. You will use this file throughout the guide.

Undo, redo and the safety net

You will make mistakes, and that is fine because spreadsheets forgive quickly.

• Ctrl+Z undoes the last action. Press it repeatedly to step back further.
• Ctrl+Y redoes in Excel on Windows. In Sheets and on Mac, use Ctrl+Shift+Z or Command+Shift+Z.
• Press Esc while typing in a cell to cancel the entry and restore the old content.
• In Google Sheets, File > Version history > See version history shows every saved version. You can restore any of them.
• In Excel with a OneDrive file, File > Info > Version History does the same.

Knowing the safety net exists makes you braver, and brave beginners learn faster. Click things. Try menus. If something goes wrong, undo.

The beginner's first ten minutes: a practice run

Do this exercise now in your Basics sheet. It uses only what you learned above.

1. Click A1, type Item, press Tab, type Cost, press Enter.
2. In A2:A4 type Rent, Groceries, Phone. In B2:B4 type 1200, 450, 65.
3. Select B2:B4 and read the Sum on the status bar. It should say 1715.
4. Click B5 and type =SUM(B2:B4) then press Enter. You should see 1715.
5. Click B5 again and look at the formula bar. You see the formula, not the number.
6. Change B3 to 500. Watch B5 update to 1765 on its own.
7. Press Ctrl+Z and watch it return to 1715.

That last step is the heart of why spreadsheets matter. You wrote a rule once, and the sheet keeps the answer correct every time the inputs change. Everything else in this guide builds on that idea: you set up data cleanly, write rules that refer to it, and let the program do the arithmetic.

In the next section you will learn how to type data so the spreadsheet understands it, because a surprising number of formula problems start with data that only looks right.

The sample ends here.