How to Learn Excel as a Beginner: a 7-Step Path

To learn Excel from scratch, work in this order: the interface and data entry, simple formulas and cell references, sorting and filtering, conditional functions (IF, COUNTIF, SUMIF), lookups with VLOOKUP, keeping your data clean, then charts and PivotTables. Each step builds on the one before. Skip cell references, for example, and every formula after that becomes hard to follow.

The whole path uses a single practice sheet. You build it in step 1, and every later step adds an exercise to it. All you need is Excel: the desktop app or Excel for the web, which is free with a Microsoft account.

How much time to plan

Our advice: 20 to 30 minutes a day, one step a week. That gets you through the path in about seven weeks. Short, regular sessions spent inside Excel, not just reading or watching videos, work better than a full day once a month. You have finished a step when you can redo its exercise without looking at the instructions.

Step 1: find your way around and enter data

By the end of this step you should know:

• the difference between a workbook (the file) and its worksheets (the tabs at the bottom);
• how cells are named by column and row: B3 is column B, row 3;
• how to read the ribbon (Home, Insert, Data…) and the Formula Bar, which shows what is really in the selected cell;
• how to copy a value or formula down with the fill handle (the small square at the bottom right of the selected cell);
• how to apply a number format (Currency, Date) from the Home tab.

Exercise. On a blank sheet, type in this sales log for a small stationery shop. Format column E as Currency. You will use this sheet in every step that follows.

Quick check: a date Excel has understood is right-aligned, like a number. If it sticks to the left, Excel has stored it as text.

Step 2: simple formulas and cell references

A formula always starts with =. It can add cells together (=E2+E3) or call a function. The first two to learn are SUM and AVERAGE. The AutoSum button on the Home tab writes the SUM formula for you.

Next comes the point that trips up most beginners. When you copy a formula down, its references shift (E2 becomes E3, then E4). That is a relative reference. To keep a reference fixed, add $ signs: $I$1 is an absolute reference. On Windows, F4 adds the $ signs to the reference your cursor is in.

Exercise.

1. In I3, work out the total: =SUM(E2:E9) returns £85.50.
2. In I4, work out the average sale: =AVERAGE(E2:E9) returns 10.6875, shown as £10.69 with two decimal places.
3. Type 10% in I1 (the commission rate) and "Commission" in F1. In F2, enter =E2*$I$1 and copy it down to F9. F2 shows £1.25 and F3 £0.40.

Now redo point 3 with =E2*I1, without the $ signs. From F3 onwards the results are wrong (F3 shows 0), because the copied formula points to I2, I3… instead of the rate in I1. Seeing this mistake once teaches more than reading about it ten times.

Step 3: organise, sort and filter

Select A1:F9, then go to Insert > Table. Excel turns the range into a table: filter buttons appear on the headers, and new rows typed underneath are added to it automatically. Data > Sort and Data > Filter also work on a plain range.

Exercise.

1. Filter the City column on "London": 4 rows remain.
2. Clear the filter, then sort by Amount from largest to smallest: the two £18.00 diary sales move to the top.

Two habits prevent most problems at this stage: a single header row with no merged cells, and no blank rows in the middle of your data. A blank row cuts off the range Excel picks up for sorting and filtering, and merged cells often stop a sort from working.

Step 4: conditional functions (IF, COUNTIF, SUMIF)

This is where Excel starts saving you time: counting or adding up only the rows that meet a condition, instead of hunting for them by eye.

• IF returns one value when a condition is true and another when it is false.
• COUNTIF counts the cells that meet one criterion.
• SUMIF adds up the amounts on rows that meet one criterion.
• COUNTIFS counts with several criteria at once.

Exercise.

1. Type "£10 or more" in G1 (the table grows to include it), then in G2: =IF(E2>=10,"yes","no"), copied down to G9 if Excel has not done it for you. G2 shows "yes", G3 "no". You end up with 5 "yes" and 3 "no".
2. Number of sales in London: =COUNTIF(C2:C9,"London") returns 4.
3. Emily's sales total: =SUMIF(B2:B9,"Emily",E2:E9) returns £34.50 (12.50 + 18.00 + 4.00).
4. Harry's sales in Leeds: =COUNTIFS(B2:B9,"Harry",C2:C9,"Leeds") returns 2.

To go further with each function, see our guide to COUNTIF with examples, our SUMIF guide and our guide to COUNTIFS with multiple criteria. If a formula returns 0 when you expect a result, check why COUNTIFS is not working.

Step 5: look up a value in another table (VLOOKUP)

VLOOKUP fetches information from another list using a key: a product's price from its name, an employee's department from their staff number.

Exercise. Next to your sales, build a small price list:

=VLOOKUP("Diary",K2:L4,2,FALSE) returns £18.00. The 2 means the second column of K2:L4, and FALSE asks for an exact match. Then replace "Diary" with D2 and copy the formula down: each sale picks up the price of its product (remember the $ signs from step 2 on the range: $K$2:$L$4).

The full walkthrough, including #N/A errors and what causes them, is in our tutorial Excel VLOOKUP explained simply. In Microsoft 365 and Excel 2021 or later, XLOOKUP does the same job with fewer restrictions.

Step 6: keep your data reliable

Formulas are only as good as the data they use. Three tools prevent typing mistakes and tidy up a file someone sends you:

• Drop-down lists (Data > Data Validation) restrict a cell to set choices. Our tutorial: how to create a drop-down list step by step.
• Removing duplicates (Data > Remove Duplicates). See our guide to removing duplicates in Excel. To check them first, highlight them with conditional formatting.
• Cleaning text: removing non-alphanumeric characters or removing parentheses from an imported column.

Exercise.

1. Type Emily, Harry and Priya in N2:N4. Select B2:B9, open Data > Data Validation, choose "List" and enter the source =$N$2:$N$4. Try typing "Paul" in B3: Excel rejects it.
2. Copy the sale in row 9 (A9:G9) and paste it into rows 10 and 11. Click inside the table, then Data > Remove Duplicates with every column ticked: Excel removes the 2 copies and you are back to 8 sales. The total in I3 never changed, because it only covers E2:E9.

Step 7: summarise with a chart and a PivotTable

A PivotTable summarises hundreds of rows in a few clicks, with no formulas to write. This is the right moment to learn it: you now know how to prepare clean data, which is exactly what a PivotTable needs.

Exercise.

1. Click inside your sales, then Insert > PivotTable. Put Seller in Rows and Amount in Values. You should get Emily £34.50, Harry £26.00, Priya £25.00, Grand Total £85.50. That total matches step 2: that is your check.
2. Select the result, then Insert > Recommended Charts and pick a column chart. Our guide to making a chart in Excel explains when a line or pie chart works better.

Emily's figure in the PivotTable matches your SUMIF from step 4. Getting the same number two different ways is a good habit to keep. To group dates by month, show percentages or refresh after adding rows, follow our step-by-step PivotTable guide.

Mistakes that hold beginners back

• Typing a total by hand instead of using a formula: it does not update when a row changes.
• Numbers stored as text, often after pasting from a web page or another program: they sit on the left of the cell and SUM ignores them.
• Merging cells inside a data table: sorting and filtering stop working properly.
• Several tables touching each other on one sheet: leave at least one empty column between them, or better, give each table its own sheet.
• Learning an advanced function before cell references: without step 2, every formula you copy becomes a source of errors.

After the path: learn what your job needs

Once you are comfortable with the 7 steps, learn the functions that match your real tasks rather than working through a general list:

• age, length of service or the time between two dates (HR, admin): the DATEDIF function;
• weighted marks or average purchase price: weighted averages;
• how spread out a series of measurements is: standard deviation.

You will find all our tutorials by topic in the Excel basics and Excel formulas sections.

Free resources and paid courses

The free official source is Microsoft's Excel help & learning site: getting started, formulas and functions, PivotTables, all grouped by topic. It is a useful companion to this path when you want the exact description of a menu or a function.

A paid course can make sense if your employer funds it or if you would rather have a trainer to answer your questions. Before you sign up, check that the syllabus covers at least steps 2 to 7 of this path, with hands-on exercises.