A Microsoft Excel spreadsheet is, at its core, a grid. Columns run across the top labeled A, B, C and so on. Rows run down the side labeled 1, 2, 3 and beyond. Every box where a column and row meet is a cell, and every cell has an address — A1, B7, F23 — that you can reference in formulas.
That grid sits inside a worksheet, and a worksheet sits inside a workbook, which is the .xlsx file you save to your computer. Most spreadsheets people work with day to day are one worksheet inside one workbook, but you can stack many worksheets together using the tabs at the bottom of the screen.
People reach for Excel for one simple reason: numbers, lists, and tables become much more useful when you can sort them, filter them, add them up, and chart them automatically. A grocery list in a notebook is fine. A grocery list in Excel can total your monthly food spend, group items by store, flag anything over $20, and produce a chart of what you bought each week.
That jump from passive data to active analysis is what Excel does, and it does it for everything from home budgets to billion-dollar financial models. If you want a structured way to test yourself on the basics, the Excel practice test covers cells, formulas, formatting, and shortcuts in one go.
This guide walks through what a Microsoft Excel spreadsheet is, how it's structured, what you can do with one, how to build one from scratch, and where common beginners trip up. The aim is plain English and worked examples. You don't need any prior spreadsheet experience to follow along. By the end you'll know the parts of the interface, the difference between a formula and a function, how to format a clean sheet, and how to save and share your work.
When you launch Excel and click Blank workbook, you land in front of the standard layout. The big grid in the middle is your worksheet. The column headers (A through XFD) sit across the top. The row numbers (1 through 1,048,576) run down the left side. The active cell — the one with the thick green border — is wherever your cursor is sitting.
Whatever you type goes into that active cell, and whatever you see in the formula bar near the top is the real content of that cell. The formula bar matters because a cell can display a calculated result (say, 500) while actually containing a formula (=A1+B1) underneath. Always glance at the formula bar to see what's truly there.
The ribbon stretches across the top. It's organized into tabs — Home, Insert, Page Layout, Formulas, Data, Review, View, plus a few more depending on your version. Each tab groups related commands. Home holds formatting and basic editing tools. Insert is where charts, tables, pictures, and pivot tables live. Formulas opens the function library. Data covers sorting, filtering, and importing. The View tab controls how Excel looks on screen. You don't need to memorize where every button lives. Use the search box (Tell me what you want to do) at the top of the ribbon when you can't find something.
At the bottom of the screen, the sheet tabs let you switch between worksheets. Right-click any tab to rename it, duplicate it, change its color, or delete it. The status bar at the very bottom shows useful information about whatever cells you have selected: a quick count, sum, and average appear automatically. That live status-bar math is one of the most underrated features in Excel — you can answer a quick question about a column of numbers without typing any formula at all, just by highlighting the range.
Get these six terms straight and the rest of Excel makes sense: workbook (the .xlsx file), worksheet (a tab inside the workbook), cell (one box in the grid), range (a group of cells, written like A1:A10), formula (anything starting with =, performs a calculation), function (a pre-built shortcut like SUM, AVERAGE, IF that you use inside a formula).
Let's build a simple monthly expense tracker so the moving parts have somewhere to land. Open Excel, choose Blank workbook, and click cell A1. Type the word Date and press Tab. In B1 type Category and press Tab. In C1 type Description and press Tab. In D1 type Amount and press Enter. You now have a header row. Headers should always sit in row 1, never row 2 or row 3, because many Excel features (filtering, tables, pivot tables) expect the first row to label what each column contains.
Now click A2 and type a date — 5/1/2026 — and press Tab. In B2 type Groceries, Tab, in C2 type Costco run, Tab, in D2 type 142.50, Enter. Repeat for a few more rows with different categories: Gas, Utilities, Rent, Dining, Subscriptions. Don't worry about formatting yet. Get the data in first; clean it up after. This is the most important habit in spreadsheet work — entry and formatting are separate jobs. Trying to do them at the same time slows you down and creates fragile sheets that break when you copy data into them.
Once you have ten or fifteen rows, select your header row by clicking the number 1 on the left. Press Ctrl+B to bold it. With the same row still selected, go to Home and pick a light fill color from the paint bucket — a pale gray or pale blue works well.
Now select your Amount column (click the letter D at the top), right-click, choose Format Cells, and pick Currency with 2 decimal places. Every number in column D now displays as $142.50 instead of 142.5. Save the file with Ctrl+S (Windows) or Cmd+S (Mac). Give it a clear name like "2026 expenses" and pick a folder you'll remember.
The next step is where Excel earns its keep. Click cell D20 (or whatever row sits two rows below your last entry). Type =SUM(D2:D15) and press Enter. The cell now displays the total of all your expenses. Change any amount in column D and the total updates instantly. That's a formula doing the work for you. You never have to add a column of numbers by hand again.
Row 1 only. Bold, with a fill color. Each column gets one clear label. No merged cells in the header — they break sorting and filtering.
Every cell in a column should hold the same type: dates in the date column, numbers in the amount column, text in the description column. Mixed types break formulas.
Excel treats blank rows as the end of your data range. Sorting, filtering, and totals all stop at the first empty row. Keep your data contiguous.
Put summary formulas (SUM, AVERAGE, COUNT) below your data or on a separate summary sheet. This lets Excel auto-update as you add new rows.
A formula is any cell entry that starts with an equals sign and performs a calculation. =2+2 is a formula. =A1+B1 is a formula. =A1*0.07 is a formula. The equals sign tells Excel: "don't treat this as text; calculate it." Without that equals sign your cell just shows the literal characters you typed.
A function is a pre-built calculation Excel ships with — a named shortcut that takes inputs and returns a result. SUM, AVERAGE, IF, VLOOKUP, COUNTIF, XLOOKUP, INDEX, MATCH are all functions. You use functions inside formulas. For example, =SUM(A1:A10) is a formula that uses the SUM function. =IF(A1>100,"High","Low") is a formula that uses the IF function. The function is the engine; the formula is the whole sentence around it. Excel has over 500 built-in functions, but in practical day-to-day work, most people use roughly twenty.
The five functions you'll use most are SUM, AVERAGE, COUNT, MIN, MAX. Master those before you reach for anything fancier. After that, the next tier is IF, COUNTIF, SUMIF, VLOOKUP, XLOOKUP, TEXT, CONCAT, DATE, NOW. Once those feel natural, you can grow into pivot tables, array formulas, and the more advanced lookup and reference functions. Resist the urge to learn every function at once. Build something real, run into a problem, look up the function that solves it, and move on. That's how almost every long-time Excel user actually learned — one problem at a time.
The most-used function in Excel. =SUM(A1:A10) adds every number from A1 to A10. The keyboard shortcut Alt+= auto-inserts a SUM formula with a smart guess at the range, which is one of the single biggest time savers in Excel. Use SUM for monthly totals, running balances, sales aggregations, expense reports — anything where you need a total.
Returns the arithmetic mean of a range. =AVERAGE(B2:B30) gives the average of those values. AVERAGE ignores blank cells but counts zeros. If you want to skip zeros, you need AVERAGEIF with a condition. Common uses: average grade, average ticket price, average response time, average daily revenue.
COUNT counts cells containing numbers. COUNTA counts non-empty cells of any type. =COUNT(D2:D100) tells you how many rows actually have numeric data. =COUNTA(A2:A100) tells you how many rows are filled in at all. Use these in dashboards to track sample sizes, response rates, completed tasks.
=MIN(E2:E50) returns the smallest value in the range; =MAX(E2:E50) returns the largest. Use these for highest sale, lowest grade, fastest time, biggest expense. Often paired side by side in summary dashboards. Combine with INDEX/MATCH to find not just the value but the row it came from.
The foundation of conditional logic. =IF(A1>100,"High","Low") tests whether A1 is greater than 100 and returns "High" or "Low" accordingly. Nest IF inside IF for multiple conditions, or use IFS (Excel 2019+) for cleaner multi-condition logic. The Excel formulas practice quiz drills these in test format.
Formatting is what turns a grid of raw numbers into something a human can actually scan and understand. There are five formatting decisions to get right on every spreadsheet you build. First, the header row: bold, with a light fill color and centered text. Second, number formats: currency for money, dates as actual dates (not text), percentages as percentages with one or two decimals.
Third, column widths: wide enough to show the full content but no wider. Double-click the column divider to auto-fit. Fourth, alignment: text left-aligned, numbers right-aligned, headers centered. Fifth, gridlines: turn them off when printing or sharing as a PDF (View > Show > uncheck Gridlines).
Conditional formatting is one of the single biggest readability upgrades in Excel. Select a range, go to Home > Conditional Formatting, and choose a rule. Highlight cells greater than a threshold in red. Add data bars that show relative values as in-cell bars. Use a color scale that turns small values green and large values red (or the reverse). Conditional formatting updates automatically as your data changes, so a budget where over-budget rows turn red stays accurate without manual fiddling. Used well, it makes patterns visible at a glance.
Tables are the second big upgrade. Select your data range, press Ctrl+T, and confirm "My table has headers." Excel converts the range into a Table with built-in filter dropdowns, alternating row colors, and automatic expansion when you add new rows. Formulas in table columns auto-fill down the entire column. References can use named columns (=Table1[Amount]) instead of cell addresses (=D2:D200), making formulas far more readable. Converting raw ranges to Tables is a habit that pays off in nearly every spreadsheet you build.
Once your data is clean, charts and pivot tables are how you turn it into insight. To create a chart, select your data including headers, go to Insert, and pick a chart type. Bar and column charts work for category comparisons. Line charts work for trends over time.
Pie charts work for proportions of a whole (use them sparingly — they're often less clear than a bar chart). Excel previews the chart before you commit, so it's quick to flip through types and see which fits. Once inserted, a chart updates automatically when its source data changes, which makes charts ideal for recurring monthly or weekly reports.
Pivot tables are where Excel goes from spreadsheet to analysis tool. Select your data, go to Insert > PivotTable, and Excel drops a new sheet with a drag-and-drop interface for summarizing data by any column. Drag Category into Rows and Amount into Values, and you get total spending by category instantly. Drag Date into Columns grouped by month, and you get a month-by-month breakdown. Pivot tables take five minutes to learn and save hours on every reporting task. They feel intimidating before you try them and obvious after.
Power Query (Data > Get Data) is the next step up. It lets you import data from CSVs, databases, websites, and other Excel files, then clean and reshape it with a recorded sequence of steps. Once the query is built, refreshing it pulls new data through the exact same cleaning pipeline. This is how analysts handle messy monthly exports without redoing the cleanup every time. You don't need Power Query for a personal budget, but it's worth knowing it exists for the day your data outgrows a manual workflow.
Sorting and filtering are the everyday tools. Click any cell in your data, go to Data > Filter, and dropdown arrows appear on every column header. Click any arrow to filter by value, date range, or text match. Click Data > Sort to sort by one or more columns. Always make sure your data has a header row and no blank rows before sorting — otherwise Excel may sort only part of the range, leaving rows mis-matched in a way that's hard to undo.
Save with Ctrl+S on Windows or Cmd+S on Mac. The first save asks where to put the file and what to name it. The default format is .xlsx, which is what you want for nearly every modern use case. Only save as .xls (older format) if you're sending the file to someone running Excel 2003 or earlier, which is rare. Save as .csv if you need a plain-text comma-separated export — useful for importing into databases or other tools, but you lose formatting, formulas, and multiple sheets in the process.
For sharing, the cleanest path is to save to OneDrive or SharePoint and use File > Share. Cloud-saved spreadsheets let multiple people edit at the same time, with each person's cursor visible in real time. Permissions can be Edit, Comment, or View. You can also share a link that anyone with the URL can open. Cloud-saved files have automatic version history (File > Info > Version History), which is your safety net when someone accidentally deletes a section or pastes the wrong data over a working column.
If you prefer to email the file directly, File > Share > Send as Attachment works for both .xlsx and PDF. PDF is the safest format for sharing a finished report — the recipient can't accidentally change anything, formatting stays exactly as you set it, and they don't need Excel installed to open it. For a budget or summary you've finalized, send the .xlsx for editing and a PDF for reference.
Excel Online at office.com is the free browser-based version. It covers the vast majority of everyday spreadsheet needs — entering data, formulas, formatting, charts, and basic pivot tables. It's missing some advanced features (Power Query, certain macros, some specialized add-ins) compared to the desktop version, but for a personal budget or a simple shared list, it's more than enough. All you need is a free Microsoft account. Files save to OneDrive automatically and sync across devices.
The single biggest skill jump in Excel comes from learning shortcuts. Mouse users top out at intermediate. Shortcut users get fast. The starter set is small: Ctrl+S to save, Ctrl+Z to undo, Ctrl+C and Ctrl+V to copy and paste, Ctrl+X to cut, Ctrl+F to find, Ctrl+H to find and replace.
Then add navigation: Ctrl+Home to jump to A1, Ctrl+End to jump to the last used cell, Ctrl+arrow to leap to the edge of your data, Ctrl+Shift+arrow to select to the edge. Then add editing: F2 to edit the active cell, Alt+Enter to add a line break inside a cell, Alt+= for AutoSum, Ctrl+; for today's date, Ctrl+Shift+: for the current time.
The next tier covers selection and structure: Ctrl+Space to select an entire column, Shift+Space to select an entire row, Ctrl+A to select the current data range (press twice for the whole sheet), Ctrl++ to insert a row or column, Ctrl+- to delete one. Ctrl+T converts a range to a Table. Ctrl+Shift+L toggles filters on or off. Ctrl+1 opens the Format Cells dialog (the single most useful keyboard shortcut in Excel for advanced formatting).
Practice these in real work, not flashcards. Pick three shortcuts each week, force yourself to use them instead of the mouse, and they'll stick within a few days. The keyboard speedup compounds — what used to be a five-step mouse operation becomes one keystroke, and it adds up to hours saved every month for anyone who works in spreadsheets daily.
A Microsoft Excel spreadsheet is more than a fancy table. It's a structured workspace where data, calculations, and visualizations live together and update each other automatically. The path from beginner to confident user is short if you focus on the right things: cells and ranges, the five core functions, basic formatting, Tables and pivot tables, and a handful of keyboard shortcuts. Everything else — macros, VBA, complex array formulas, Power Query, Power BI integration — builds on that foundation.
The most important thing you can do after reading this guide is open Excel and build something. A monthly budget. A reading list. A workout log. A tracker for any recurring data in your life. Spreadsheets reward practice in a way that videos and articles can't substitute for. Each new file you build will teach you a feature you didn't know you needed, and after five or six real projects, the interface stops feeling intimidating. You'll start reaching for Excel instinctively the next time you need to track, sort, or analyze anything — which is the whole point.
Excel rewards a craftsman's approach: clean inputs, consistent formatting, formulas in the right place, and a habit of saving often. Build that discipline early and your spreadsheets will be reliable, scannable, and reusable. Skip the discipline and you'll end up with sheets that work today and break tomorrow when you try to add new data or share them with a colleague.
The basics in this guide are enough to handle 80 percent of what most people ever need from Excel, and the remaining 20 percent is best learned one problem at a time, in the context of work you actually care about.