Last week, my friend scrambled to track grocery spending with pen and paper. Numbers smudged. Totals missed the mark. She wasted hours. Then she tried a basic Excel spreadsheet. It took minutes to list items, add prices, and see her budget at a glance.
You face the same hassle with lists, budgets, or reports. Pen and paper fails for quick changes or math. Excel fixes that. This guide shows you how to create simple spreadsheets in Excel using 2026 basics. You’ll build an expense tracker step by step. New tools like Copilot insights and smart formula hints make it even easier for beginners.
We’ll start with opening Excel and adding data. Next comes formatting for a clean look. Then formulas for math. After that, sorting, tables, and charts. Finally, saving and practice tips.
Launch Excel and Fill It with Your Data Fast
Open Excel 2026 on your Windows PC. Search for it in the Start menu. Or find the icon on your desktop. Click to launch a blank workbook.
The screen shows a grid. Cells sit at row-column spots like A1 or B2. Rows number down the left. Columns letter across the top. The Home tab sits on the Ribbon at the top. Save right away. Go to File, then Save As. Pick a folder and name like “MyBudget.xlsx”.
Click any cell. Type your data. Press Enter to drop down. Or Tab to slide right. Start headers in row 1. Type “Item” in A1. “Price” in B1. “Quantity” in C1. “Total” in D1.
Grab the fill handle. It’s a tiny square at the cell’s bottom right. Drag down to copy patterns. Enter 1 in A2, 2 in A3. Drag to auto-fill numbers. Excel spots sequences like months too.
Check the status bar at the bottom. It sums selected numbers. New Copilot tools help clean messy data later. For now, watch for extra spaces. Hit Backspace to fix. Ctrl+Z undoes mistakes fast. See Microsoft’s basic tasks guide for more entry tips.
Get Comfortable with the Excel Grid and Tools
Cells hold your info. Rows run horizontal. Columns go vertical. Ignore most Ribbon buttons at first. Stick to Home tab basics.
Scroll without losing headers. Go to View tab. Click Freeze Panes. Pick Freeze Top Row. Now headers stay put.
Hover over format options. Excel 2026 previews changes live. No guesswork. Beginners often feel lost by button overload. Focus on one tab. Practice builds speed.
Enter and Copy Data Like a Pro from the Start
Click A2. Type “Coffee”. B2 gets “5.00”. C2 says “2”. Tab moves you along.
Drag fill handle on C2 down. It copies quantities. Patterns fill smart. Type “Jan” in E1, “Feb” in E2. Drag for months.
For full steps on new workbooks, check this Microsoft support page. You enter data fast now.
Format Your Spreadsheet So It Looks Sharp and Reads Easy
Raw data confuses. Format it first. Select cells by dragging mouse. Or hold Shift and arrow keys.
On Home tab, bold headers. Click Bold button. Center align with Center icon. Right-click cells. Pick Format Cells for currency.
Add borders. Home tab, Borders dropdown. Choose All Borders. Fill colors highlight rows. Click Fill Color. Pick light shade.
Freeze panes keeps headers visible. Smart previews show results before you click. Select exact ranges. Over-formatting muddies sheets.
Pro sheets scan quick. Colors guide eyes. Your expense tracker pops now.
Bold Headers and Align Everything Neatly
Select row 1. Hit Bold. Everything centers neat. Budget sheets read smooth.
Drag over A1:D1. Align buttons work instant. Neat rows beat messy lists.
Add Colors, Borders, and Money Symbols Quick
Headers get light green fill. Data rows stay white. Borders outline cells.
Price column: select B2:B10. Number group, Currency format. Dollars appear. Hover previews save clicks.
Unlock Easy Math with Formulas and Basic Functions
Math powers spreadsheets. Start in empty cell with equals sign. =A2+B2 adds prices and quantity? No. Put =B2*C2 in D2 for total.
Drag formula down. It adjusts to D3, D4 auto. Relative references shift smart.
Functions pack power. =SUM(D2:D10) totals column. =AVERAGE(B2:B10) finds mean price.
New Advanced Formula Environment hints as you type. Spots errors. Suggests fixes. Type =SUM. Get auto-complete.
Lock cells with $. =B2*$C$1 uses fixed quantity. Ctrl+Enter applies to selection.
Forget equals? Excel treats as text. Red error? Check parentheses. Like =(A2+B2)*C2.
Build grand total. =SUM(D2:D10) in D11. Ties to your tracker. See simple formula guide from Microsoft.
Master Addition, Multiplication, and Averages First
D2: =B2*C2 multiplies. Drag fills row. Addition: =SUM(A1:A5).
Averages smooth data. =AVERAGE(C2:C10). Drag copies easy.
Absolute refs lock. $B$2 stays put when dragged.
Try Handy Functions for Smarter Calculations
SUM totals fast. AVERAGE evens numbers.
IF checks: =IF(B2>10,”High”,”Low”).
CONCAT joins: =A2&” costs $”&B2.
| Function | What It Does | Example |
|---|---|---|
| SUM | Adds range | =SUM(B2:B10) |
| AVERAGE | Means range | =AVERAGE(C2:C10) |
| IF | Conditions | =IF(A2>100,”Over”,”OK”) |
| CONCAT | Joins text | =A2&” “&B2 |
Auto-complete speeds this. Copilot cleans data first.
Sort Data, Build Tables, and Add Charts That Wow
Data grows messy. Sort fixes it. Select full range, A1:D11. Home tab, Sort & Filter. A to Z on Item column.
Filters add arrows. Click to pick values. Select all columns first. Wrong range sorts partial.
Turn range to table. Select data. Quick Analysis button appears. Pick Table. Auto-formats. Filters built-in.
New Agent Mode shines. Highlight table. Copilot pane on Home. Type “Show pie chart of totals.” It builds insights, forecasts.
Charts visualize. Insert tab, Recommended Charts. Bar shows expenses. Drag to new sheet.
Tables expand auto. Charts update with data.
Sort and Filter to Find What You Need Instantly
Sort buttons alphabetize. Filters hide rows. Click arrows. Uncheck extras.
Full selection prevents mix-ups.
Create Auto-Updating Tables and Quick Charts
Quick Analysis creates tables fast. Agent Mode adds AI summaries.
Recommended Charts pick best fit. Your tracker turns visual.
Save Your Work, Print It, and Practice Real Projects
File, Save As. Use .xlsx. Backups matter. Cloud via OneDrive auto-saves.
Print preview fits page. Adjust margins.
Practice expense tracker. Headers A1:D1. Data in rows. D column =B*C. Sum at bottom. Format bold. Table it. Chart totals.
Shortcuts help. F2 edits cells. F1 pulls help. Arrow keys navigate.
File, New for templates. Daily builds skill. Fix errors. Ignore none.
Ready to Track Expenses Like a Pro
You now launch Excel, enter data, format clean, add math, sort, table, and chart. Copilot and formula hints make 2026 beginner-friendly.
Handle budgets or lists easy. Start your expense tracker today.
Share your first sheet in comments. Grab free templates from File > New. Subscribe for formula deep dives. You’ve got this.