How to Use Microsoft Excel: The Beginner's Guide (First Sheet, First Formulas, and Your First PivotTable)

CodexFuse Team · 2026-10-28T12:34:13.527Z · 10 min read

Learning how to use Microsoft Excel is mostly a matter of learning a small set of skills in the right order: the screen, clean data, five core formulas, sorting and filtering, charts, and one PivotTable. Excel is the spreadsheet most schools and offices in the United States expect you to know, and you do not need to master all of it to be useful — a beginner who can build a clean table, add it up, and summarize it already handles most real office work. This guide walks you through that complete first-week arc, from your first blank spreadsheet to your first PivotTable, plus the lookup formula that replaces VLOOKUP and the honest line on Copilot. When you get to lookups, our XLOOKUP guide covers that one formula in full.

What Is the Fastest Way to Learn How to Use Microsoft Excel?

The fastest way to learn how to use Microsoft Excel is to practice one practical skill a day on a real file, in this order: enter clean data, learn five core formulas, sort and filter, format clearly, build one chart, and finish with one PivotTable. One beginner guide puts basic comfort at two to four weeks of daily practice, and that matches how most people actually learn it — by building something real, not by memorizing menus. The seven-day plan below is the whole system in miniature.

1. Day 1: Open a blank workbook, enter a small table, and format the headers in bold.
2. Day 2: Use SUM, AVERAGE, MIN, and MAX on that table until the formulas feel automatic.
3. Day 3: Practice IF formulas and absolute references with a single rate cell.
4. Day 4: Sort, filter, and convert the list into an Excel Table with Ctrl + T.
5. Day 5: Build one chart from the table and explain out loud what it shows.
6. Day 6: Create one PivotTable that summarizes the same data by category.
7. Day 7: Rebuild the same file from scratch, without looking at your notes.

How Do You Create Your First Spreadsheet in Excel?

To create your first spreadsheet in Excel, open the app, choose Blank workbook, click a cell and type, then save with Ctrl + S. That is the whole first-file flow, and it works the same on Windows and Mac. Give the file a descriptive name the first time you save it, so you can find it again — "January sales.xlsx" beats "Book1.xlsx" every time.

If you do not have the desktop app, Excel for the web runs free in a browser with a Microsoft account, and it covers everything in this guide. The desktop app is the paid part: it needs a Microsoft 365 subscription, a one-time Office purchase, or a school or work account. Both save .xlsx files that open in the other, so starting in the browser costs you nothing.

Turn on AutoSave the first time you work in the web version, and use File > Options > Save to set it in the desktop app. AutoSave means a crash or a closed laptop never costs you an afternoon of typing, and it lets several people edit the same file at once.

What Are the Parts of the Excel Window?

The Excel window is built around workbooks, worksheets, rows, columns, and cells, and each cell has an address such as A1 or D12 that formulas use to find values. A workbook is the whole file, like a book; a worksheet is one sheet inside it, like a single page; a cell is one box where a value lives. Learn where the parts below sit before you write formulas, because hunting for a button you use daily is the slowest way to learn.

Microsoft's own limits put the size of one worksheet at 1,048,576 rows by 16,384 columns, and a single cell can hold up to 32,767 characters. You will never need that much room as a beginner, but the numbers explain why sloppy habits scale badly: a small mistake in a big list becomes a large mistake fast.

How Do You Enter Clean Data in Excel?

Clean data means one type of information in each column, field names in the first row, and no merged cells, blank rows, or totals inside the list you want to sort. Put Date, Customer, Product, Units, and Revenue in row 1, then one record per row below it. Everything else in Excel — filters, charts, formulas, PivotTables — works better when the data is shaped this way, and most beginner frustration traces back to skipping this step.

Five habits keep a sheet clean. Do not merge cells inside a data table. Do not leave blank rows in the middle of a list. Do not type numbers as text. Do not mix date formats in one column. Do not put totals inside the same list you want to sort — totals belong below the list or in a summary area.

If your data arrives as a text file instead of a typed list, do not retype it: convert a CSV file to Excel and clean it there. Once the data is in, the text functions TRIM, UPPER, LEFT, and TEXT fix the usual mess — extra spaces, mixed case, and numbers stored as text — and IFERROR hides ugly error messages instead of letting them spread across the sheet.

What Are the Five Excel Formulas Beginners Should Learn First?

The five Excel formulas beginners should learn first are SUM, AVERAGE, MIN and MAX, COUNT and COUNTA, and IF, because together they answer nearly every question a simple report asks. Every formula starts with an equals sign, and every one of them points at cells by address, so =SUM(B2:B10) adds the ten values in column B from row 2 to row 10. Learn these five until they feel automatic before you touch anything fancier.

Here is the set worked out on a real five-day sales table, so you can check your own answers against it. Each day's revenue is units times price, and the totals at the bottom are the formulas doing their job.

=SUM of the revenue column gives $1,617.50, =AVERAGE gives $323.50 a day, and =MAX picks out Friday's $440.00 as the best day. The IF formula adds the judgment: =IF(E2>=300,"Target met","Below target") marks four of the five days as met and only Wednesday, at $237.50, as below target. If a formula shows #N/A, #VALUE!, or #DIV/0!, read it as a clue, not a failure — check the cell references first, then check whether a number is stored as text.

What Are Relative and Absolute Cell References?

A relative reference such as A1 changes when you copy the formula, while an absolute reference such as $A$1 stays fixed, and knowing the difference is what stops copied formulas from silently breaking. Copy =A2+B2 down one row and it becomes =A3+B3; that is usually what you want for a column of calculations. But a tax rate, a discount, or an exchange rate lives in one cell, and every row must point at that same cell.

Put a 10% discount in cell F1, then write =B2*$F$1 in the next column and copy it down. The dollar signs lock the reference, so every row multiplies by the same F1 instead of sliding down to F2, F3, and F4. Press F4 while editing a reference to cycle through the four forms — $F$1, F$1, $F1, F1 — until you have the one you need.

How Do You Sort, Filter, and Turn Data Into an Excel Table?

To sort or filter safely, select the full data range first, then sort — or better, convert the list into an Excel Table with Ctrl + T and let the table handle it. Tables expand automatically when you add new data, put filter buttons in the header row, and let formulas use column names instead of cell addresses, so =SUM(Sales[Amount]) reads like plain English. Always sort with the whole range selected, or one column will sort while the rest stays put and your rows will no longer match.

Filters answer practical questions without a single formula: which invoices are unpaid, which products sold more than 100 units, which customers ordered this month, which expenses are above budget. Click a filter arrow in the header, pick a value or a condition, and the list narrows to the matching rows. This is the moment Excel stops feeling like storage and starts feeling useful.

How Do You Make a Chart in Excel?

To make a chart in Excel, select the data including its headers, open the Insert tab, and pick the chart type that matches the question: a column chart for comparisons, a line chart for trends over time, and a bar chart for ranked items. A good chart has a clear title, readable labels, and one direct purpose — if it does not answer a question, remove it. Skip 3D charts; they look flashy and often distort the message.

On the five-day sales table above, a column chart of revenue by day shows Friday as the tallest bar at $440.00 and Wednesday as the shortest at $237.50, which is the whole story at a glance. A line chart of the same data shows the dip and recovery across the week instead. Pick the chart after you know the question, not before.

How Do You Make Your First PivotTable in Excel?

A PivotTable summarizes a large list without writing formulas: you drag fields into rows, columns, and values, and Excel does the adding and counting. It sounds advanced, but it is a beginner skill once the data is clean — never build one from data with merged cells, blank rows, or mixed types in a column, because the summary will inherit every one of those problems. The five steps below use the same sales table from earlier.

1. Click anywhere inside the table, then select Insert > PivotTable.
2. Confirm the table range Excel detected and choose where the PivotTable goes.
3. Drag Product into the Rows area.
4. Drag Revenue into the Values area, set to Sum.
5. Read the summary: revenue by product, with the total at the bottom.

The result for our five days is a three-line report that would take several formulas to build by hand. Pens sold 215 units for $537.50, Notebooks sold 195 units for $780.00, and Binders sold 40 units for $300.00, for the same $1,617.50 total the SUM formula gave. Add Region to Rows or Month to Columns and the same table becomes a regional or monthly report — that is the whole point of a PivotTable, and it is why offices value the skill.

What Is XLOOKUP, and When Should You Use It?

XLOOKUP is the modern replacement for VLOOKUP: it searches a range and returns a match without column numbers, works left-to-right and right-to-left, and handles missing values cleanly with its optional fourth argument. The basic form is =XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found]), so =XLOOKUP("Pens", A2:A6, E2:E6, "Not found") returns the Pens revenue instead of an error when the item is missing. Use it whenever you need to pull a price, a name, or a status from another table into the one you are working on.

One version line matters: XLOOKUP exists only in Microsoft 365 and Excel 2021 or newer. If your copy of Excel is older, it has VLOOKUP only, and the INDEX and MATCH combination is the flexible fallback for lookups there. Our XLOOKUP guide walks through the full syntax, the common errors, and the cases where the older functions still make sense.

What Is Copilot in Excel, and Is It Free?

Copilot in Excel is Microsoft's AI assistant inside the spreadsheet: click the Copilot icon on the Home tab, type a request in plain English, and it can write a formula, build a PivotTable, create a chart, or clean a dataset. Ask it to "write a formula that shows month-over-month growth" or "remove duplicate rows" and it does the work, and in Agent Mode it can run multi-step tasks. Since February 2026, Copilot Chat in Excel has also worked with files stored locally on your computer, not only with files saved to OneDrive.

It is not free. You need a qualifying Microsoft 365 subscription to access Copilot, so never budget for AI help you have not paid for. The free automation that every beginner can use instead is Flash Fill: type the pattern once, press Ctrl + E, and Excel fills the rest of the column — splitting first and last names, reformatting phone numbers, or pulling email domains out of addresses, with no subscription and no code.

Excel vs Google Sheets: Which Should a Beginner Pick?

Excel vs Google Sheets comes down to where you work and what you pay for: Google Sheets is free and runs in a browser, while Excel is a paid program that also has a free online version, and the basic ideas are the same in both. A cell is a cell, SUM is SUM, and a clean table matters exactly as much in either app. If your school or office runs on Microsoft 365, learn Excel first; if your team lives in Google Workspace, Sheets will feel identical at the beginner level.

The skills transfer almost one to one. Formulas, sorting, filters, charts, and PivotTables exist in both, with different names in a few corners — Sheets calls its summary tool a pivot table too, and its lookup function is the same XLOOKUP in newer versions. Our Google Sheets beginner guide covers the free side in the same first-week order as this guide, so you can compare the two apps step by step instead of guessing.

What Are the Most Useful Excel Shortcuts for Beginners?

Shortcuts save time, but beginners often try to memorize too many, so start with the few that remove daily delays and learn the rest through use. The five below cover copying, undoing, building tables, adding numbers, and jumping across data — and learning just these five can save 20 to 30 minutes a day, according to one 2026 guide. Keep the list on a sticky note for a week instead of trying to memorize it.

What Mistakes Should Excel Beginners Avoid?

The mistakes that cost Excel beginners the most time are all avoidable, and they share one root: treating the sheet like a typed document instead of a database. Merged cells inside a data table break sorting and PivotTables. Numbers stored as text look right and calculate wrong. Blank rows in the middle of a list split it into pieces Excel treats separately. Totals typed inside the list get sorted along with the data. Mixed date formats in one column make every date formula unreliable.

The second group of mistakes is about scope. Do not try to learn every feature at once — that is how people get stuck. Do not chase every new driver, add-in, or formula release for a sheet that already works. And do not rebuild the same monthly report by hand: once a report works, save it as a template, turn the list into a Table, and let the formulas update themselves next month.

If you are building the same kind of document in Word as well, the Microsoft Word beginner guide covers that app in the same plain-English order — open, type, format with styles, save, share — so the two apps feel like one workflow instead of two separate skills.

Sources

• Microsoft Support, "Excel worksheet and workbook limits" — 1,048,576 rows by 16,384 columns per worksheet; 32,767 characters per cell; column width 255 characters; row height 409 points; 100 undo levels. https://support.microsoft.com/en-us/office/excel-worksheet-and-workbook-limits-c13798fc-f1d5-4e73-998d-c02268bc65ae
• UnderConstructionPage, "How to Learn Excel: Essential Skills for Beginners" (published October 21, 2026) — 1,048,576 rows / 16,384 columns; two to four weeks to basic comfort; the seven-day practice plan; core formulas SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, IF, XLOOKUP; PivotTable five-step task; clean-data rules; shortcut starter set. https://underconstructionpage.com/how-to-learn-excel-essential-skills-for-beginners/
• Guvi, "Work Smarter with Microsoft Excel: The Complete 2026 Guide" — XLOOKUP as the modern VLOOKUP replacement, working both directions; the ten-formula starter list; Flash Fill with Ctrl + E; Copilot needs a qualifying Microsoft 365 subscription; Copilot Chat works with local files since February 2026; the five highest-value shortcuts. https://www.guvi.in/blog/work-smarter-with-microsoft-excel/
• CourseBond, "Work Smarter in 2026: A Beginner's Guide to Microsoft Excel" — relative vs absolute references (A1 vs $A$1); Excel Tables with Ctrl + T and structured references; text-cleaning functions TRIM, UPPER, LEFT, TEXT, IFERROR. https://coursebond.com/work-smarter-in-2026-a-beginners-guide-to-microsoft-excel/
• ArdiLand Institute of Technology, "Microsoft Excel for Absolute Beginners" — workbook, worksheet, cell, row, column, formula bar, name box, ribbon, and sheet tabs defined for first-time users. https://ardiland.com/blog/Microsoft-Excel-for-Absolute-Beginners-Learn-the-Basics-Step-by-Step
• Blessed Records, "Spreadsheet Basics: Getting Started With Excel and Google Sheets" (October 2026) — Google Sheets is free and browser-based; Excel is a paid program with an online version; the basic ideas are the same in both. https://www.blessedrecordsent.com.ng/spreadsheet-basics-getting-started-with-excel-and-google-sheets.html

FAQ

Is Microsoft Excel free?

Excel for the web is free with a Microsoft account — open office.com in a browser and start typing, with files saved to OneDrive. The desktop app is the paid part: it needs a Microsoft 365 subscription, a one-time Office purchase, or a school or work account. Both save .xlsx files that open in the other.

How long does it take to learn Excel?

One beginner guide puts basic comfort at two to four weeks of daily practice, and that matches the plan in this guide: one practical skill a day, from clean data and five core formulas through sorting, charts, and a first PivotTable. You do not need to learn every feature — a small set used daily covers most real office work.

What is the difference between a workbook and a worksheet?

A workbook is the whole Excel file, like a book, and a worksheet is one sheet inside it, like a single page. You switch between worksheets with the tabs at the bottom of the window, and you can rename them, add more, or color-code them to keep a workbook organized.

How many rows and columns can an Excel worksheet hold?

One worksheet holds 1,048,576 rows by 16,384 columns, according to Microsoft Support, and a single cell can hold up to 32,767 characters. The older XLS format from before 2007 capped out at 65,536 rows and 256 columns, so save in the modern .xlsx format to keep the full grid.

What is XLOOKUP, and which Excel versions have it?

XLOOKUP is the modern lookup function that replaces VLOOKUP: it finds a value in one range and returns the matching value from another, works in both directions, and handles missing values cleanly. It exists only in Microsoft 365 and Excel 2021 or newer — older versions have VLOOKUP only, and INDEX with MATCH is the flexible fallback there.