You do not need an expensive course to begin using Excel at work. Start with a small spreadsheet that answers a real question, check the results manually, and add complexity only when you understand the basics.
How to learn useful Excel skills step by step
- Create a small practice file using fictional information.
- Use consistent column names and data types, with one record per row.
- Learn to sort and filter the whole dataset without separating related cells.
- Calculate totals and a conditional total, then verify them manually.
- Add a deliberate error and learn how to detect it.
- Write a short explanation of the result and the spreadsheet’s limits.
Microsoft provides free browser access to Excel through Microsoft 365 for the web with a Microsoft account. This does not include a free desktop license, every premium feature, or a course certificate. Check the version available to you before following instructions for advanced tools.
Check Microsoft’s free Excel web access
You will go to https://www.microsoft.com
Build a practice order sheet
Enter the following invented records in cells A1:D5. They contain no real customers or business transactions. The question is: what is the order total, and how much belongs to the North team or remains open?
| OrderID | Team | Status | Amount |
|---|---|---|---|
| 1001 | North | Open | 120 |
| 1002 | South | Closed | 80 |
| 1003 | North | Closed | 200 |
| 1004 | South | Open | 100 |
Keep the amount cells numeric. Currency formatting changes how a value is displayed; typing a currency label or a note into the same cell can prevent reliable calculation. Use a separate notes column if you need commentary.
One row should represent one order. Do not insert a subtotal into the middle of the records or use merged cells inside the dataset. Keep explanatory text and summary calculations outside the source rows.
Calculate three results and check them
In a separate summary area, try these formulas in an English-language setup:
=SUM(D2:D5)
=SUMIF(B2:B5,"North",D2:D5)
=SUMIF(C2:C5,"Open",D2:D5)The expected answers are 500, 320, and 220. Check them by adding the relevant rows yourself. The conditional formula tests one range and adds the corresponding values from another; those ranges need to align.
Function names and list separators can differ with language and regional settings. If a formula is rejected, inspect those settings before assuming the calculation is wrong. Microsoft’s own SUMIF documentation explains the syntax.
Review Microsoft’s SUMIF examples and syntax
You will go to https://support.microsoft.com
Sort and filter without damaging the records
Use the dataset as a complete table or selected range with headers. If you sort only the Amount column independently, an amount can become attached to the wrong order. After sorting, check a known order ID against its original team, status, and amount.
Filter to show Open orders and inspect the two relevant records. A filtered view and a calculation are different operations: do not assume hiding rows automatically changes a normal SUM or SUMIF formula. Choose and verify a suitable calculation if you need a visible-rows-only result.
Next, add a fifth fictional order below the original range. Check whether your formulas include it. A fixed range ending at row 5 does not magically cover a new row 6. Learning to use Excel tables and appropriate references is a useful next step.
Practice finding errors deliberately
- Duplicate an order ID. Decide whether it is a duplicate or a legitimate separate record before deleting anything.
- Change North to “North ” with an extra space. Observe how inconsistent labels can affect a conditional calculation.
- Leave an amount blank. Decide whether it means zero, unknown, or an incomplete record.
- Enter an amount as text. Check the total and inspect the stored value rather than trusting its appearance.
Keep an untouched practice copy so you can compare versions. In real work, follow the organization’s backup and approval procedures before changing a shared file.
Turn practice into a work sample
Include the question, invented dataset, formulas, manual checks, and one limitation. Explain what happened when a new row or inconsistent label appeared. A small file that another person can follow is stronger evidence than a complicated template you cannot explain.
Do not upload real payroll, customer, health, or confidential company information to a public portfolio or personal account. Use synthetic data unless you have explicit permission and an appropriate process.
Decide what to learn or buy next
If you can perform the exercise independently, move to tables, data validation, lookup methods, or summaries relevant to your role. If formulas still fail, repeat a small example and identify the exact gap.
Our course-selection checklist helps assess a structured course, while free-versus-paid learning guide distinguishes useful feedback from unnecessary subscriptions. For a later database task, compare SQL practice. This plan builds a skill; it does not award a Microsoft certification or guarantee a job.