Excel for Beginners PDF: What to Learn First, in Order

If you are searching for an Excel for beginners PDF, what you really need is a short list of skills, in the right order, that you can practice in a free copy of Excel: the parts of the screen, cells and ranges, typing data, simple formulas like SUM, sorting and filtering, and printing or saving to PDF. All of that is laid out on this page, with a practice exercise you can do in ten minutes.

You do not need to buy anything. Excel for the web is free with a Microsoft account, and Google Sheets is free with a Google account. Nearly everything a beginner learns works the same way in both.

What a good beginner Excel PDF should cover

Most beginner handouts pack in too much. These are the topics that matter first, in the order that makes each one easier:

1. The screen: ribbon, Name Box, formula bar, sheet tabs and status bar.
2. The vocabulary: workbook, worksheet, cell, range.
3. Moving and selecting with the keyboard.
4. Entering data so Excel recognizes numbers and dates.
5. Your first formulas: SUM, AVERAGE, and simple arithmetic.
6. Sorting and filtering a list.
7. A basic chart.
8. Saving, file formats, and printing to PDF.

If a free PDF you find skips straight to pivot tables or macros, put it aside for later. Those build on everything above.

The Excel screen and the words that matter

Open a blank workbook and look from top to bottom.

• Ribbon: the strip of buttons organized into tabs (Home, Insert, Page Layout, Formulas, Data, Review, View). When you cannot find a button, type what you want into the search box at the top of the window.
• Name Box: the small box above column A. It shows the address of the selected cell, and you can type an address like Z500 there to jump to it.
• Formula bar: the long box marked fx. It shows what is actually inside a cell. A cell might display 1715 while the formula bar shows =SUM(B2:B4).
• Status bar: the bottom strip. Select some numbers and it shows their Sum, Average and Count with no formula at all. It is the fastest way to sanity check a total.

Four words you will use constantly:

• Workbook: the whole file, usually saved as .xlsx.
• Worksheet: one tab inside the workbook. A workbook can hold many.
• Cell: one box, named by column letter then row number. Column C, row 5 is C5, never "5C".
• Range: a block of cells written as top left, colon, bottom right. A1:D10 is 4 columns by 10 rows, 40 cells.

Your first formula: a ten-minute practice run

Say you are Ana, starting a simple sheet to track three monthly bills. Open a blank workbook and follow along.

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

Step 7 is the whole point of spreadsheets. You write a rule once and the answer stays correct whenever the inputs change. Ana can add a row for her internet bill next month, widen the range to B2:B5, and the total keeps up. Try =AVERAGE(B2:B4) in another cell for a second formula.

Name the file something you will recognize later. A pattern like 2026-10 Monthly Bills v1 sorts files by date automatically because the year comes first.

Shortcuts and habits that save beginners hours

These keys work in Excel and Google Sheets. On a Mac, use Command where Windows says Ctrl.

A few habits worth building from day one:

• Save right away, before you type much, and keep saving. If your file is in OneDrive, AutoSave and version history protect you. Google Sheets saves after every change.
• Know your file formats. .xlsx is a normal workbook. .csv is plain text that holds only values, so formulas, colors and extra sheets are lost if you save your work as CSV. When you open a CSV export from a bank or website, save a copy as .xlsx before doing real work.
• Be careful with .xlsm files. They contain macros. Only open them from people you trust.

How to save your own Excel sheet as a clean PDF

Once you have a sheet worth sharing, a PDF is the safest way to send it to someone who should read it but not edit it. The trick is setting it up so it fits the page.

1. Preview first. Press Ctrl+P. Check the page count before anything else. A one-page report that says "1 of 14" needs fixing.
2. Set the print area. Select the range you want, then Page Layout > Print Area > Set Print Area. Stray notes off to the side will no longer print.
3. Turn wide data sideways. Choose Landscape orientation.
4. Fix the scaling. In the print settings, choose "Fit All Columns on One Page." Every column fits the page width and rows flow onto as many pages as needed. In Google Sheets, the same option is called "Fit to width."
5. Repeat the header row. Page Layout > Print Titles, then set "Rows to repeat at top" to row 1. In Google Sheets, freeze the header row and tick "Repeat frozen rows."
6. Save as PDF. In Excel for Windows, use File > Save As (or Export) and choose PDF. In Google Sheets, use File > Download > PDF.

Before you export, remove test numbers and personal notes, and hide helper columns the reader does not need. If you have to shrink the text far below normal size to fit, hide columns or split the report instead, because tiny print is hard to read.

Common beginner mistakes and how to avoid them

• Typing numbers with extra text, like 1200 dollars. Excel then treats it as text and will not add it. Type the number and apply currency formatting instead.
• Typing a total by hand. A hand-typed total does not update. Use a formula so it changes when the data changes.
• Leaving blank rows inside a list. Keyboard selection and sorting stop at the gap, so you may total or sort only part of your data. Check the Count on the status bar after selecting.
• Never saving a named copy. "Book1" files get lost. Name and save in the first minute.
• Trying to learn everything at once. Basic formulas, sorting and printing cover a large share of everyday office work. Learn those well before moving on.

Common questions

Is there a free Excel for beginners PDF?

Microsoft publishes free beginner training and quick start material on its own support site, and many public libraries and community colleges offer free handouts. Whatever you use, practice alongside it in a real workbook. Reading about formulas without typing them rarely sticks.

How do I learn Excel as a complete beginner?

Start with the screen and vocabulary, then do a small practice sheet like the one above, then learn one new skill per session: a formula, sorting, filtering, a chart. Short, regular practice on data you care about, such as a budget or a work list, works better than long sessions on made-up examples.

Do I need to buy Excel to learn it?

No. Excel for the web is free with a Microsoft account and handles everything a beginner needs. Google Sheets is also free and works almost the same way for the basics, so the skills carry over if a job later requires the desktop version.

Is Google Sheets the same as Excel for beginners?

For beginner tasks they are very close: cells, ranges, formulas like SUM, sorting, filtering and charts all work similarly. The main differences are where files live and how saving works. If a job description names Excel, practice in Excel, but anything you learn in either one transfers.