How to learn Excel

Learning Excel means getting comfortable with the grid of rows, columns and cells, then formatting, formulas and functions, tables, charts and PivotTables, in roughly that order. Four basics come first:

A printed spreadsheet with rows and columns of numbers
A spreadsheet of rows and columns, the grid this page teaches you to use.Photo: tomfield / Pixabay
  1. 1

    Rows, columns, cells

    Every value has an address, like B5.

  2. 2

    Formatting

    Numbers, dates and currency that read right.

  3. 3

    Formulas

    Start with = and point at cells.

  4. 4

    Tables and charts

    Sort, filter and show your data.

Learn it in Evernote. Clip a lesson, let the AI Assistant check your practice against it, and log the fix.

Start your learning notebook in Evernote

How to learn Excel in 6 steps

  1. 1

    Start with Microsoft's free help

    Microsoft Support's Excel help covers getting started, formulas and functions, formatting data, and analyzing with PivotTables.

  2. 2

    Learn how cells work

    A reference identifies a cell or a range, and B5 means column B, row 5. Every formula uses references, so learn to read them first.

  3. 3

    Write your first formulas

    Formulas in Excel always begin with the equal sign. Begin with =SUM and =AVERAGE on a sheet you care about, like a budget.

  4. 4

    Check every range

    One thing to check is a range that misses a row or a column. Click the formula and look at the highlighted cells.

  5. 5

    Turn data into a table and a chart

    Use the table and chart tools in Excel on the data you built, so you practice sorting, filtering and showing the result.

  6. 6

    Build something real every week

    A budget, a workout log, a list of bills. Real data makes you use features in the order you need them.

A 4-week Excel plan

About 20 minutes a day, one feature at a time
  1. 2Week 1Intro, rows and columns, cells. Enter a month of expenses.
  2. 3Week 2Formatting and formulas: SUM and AVERAGE on the expenses.
  3. 4Week 2, laterBreak a formula on purpose, then fix the range.
  4. Week 3Tables and charts: sort the expenses, chart them by category.
  5. 6Week 4Build a sheet from scratch for something you track, and add a PivotTable.

Free Excel practice log

One entry per session. Copy it, or save it to your Evernote account and keep your practice in the same note.

Date: [day] · Time spent: [minutes]

Topic: [one feature, like SUM or tables]

What I built: [sheet, in one line]

Formula I used: [the formula]

Fix next time: [one thing]

Trusted by Millions Worldwide

4.4

2,100+ reviews on G2

4.4

8,200+ reviews on Capterra

4.4

73,000+ reviews on App Store

248M

Registered users

Excel learning questions

How can I learn Excel for free?

Microsoft Support has free Excel help and a formulas tutorial workbook that walks through SUM, COUNT, AVERAGE and VLOOKUP.

What should I learn first in Excel?

Start with the grid. A reference identifies a cell or a range, and every formula uses references. Then learn formatting and your first formulas.

What is the most important Excel formula to learn?

Start with SUM, then AVERAGE. They teach the pattern every function follows: an equal sign, a name, then a range in parentheses.

How long does it take to learn Excel?

Short daily practice on a real sheet is a good way to learn the basics. PivotTables are a later topic in Microsoft Support's Excel help.

Why is my Excel formula wrong?

Check the range first: click the formula and see which cells are highlighted. A range that misses a row or column is one thing to look for, and so is a cell that holds text instead of a number.

What are PivotTables?

A way to summarize a large table, for example totals by category or month, without writing formulas. Microsoft Support has a section on analyzing with PivotTables.

How to learn Excel with Evernote

Keep one notebook for Excel: the lessons you clip, the formulas you practice, and a log of what to fix.

  1. 1

    Save formula lessons and video links.

    Clip the Microsoft Support page into your Excel notebook, and paste the video link into the same note.

  2. 2

    Check a formula.

    Add a screenshot of your sheet or the formula text to a note and ask the AI Assistant to check it against the lesson. It points out a range that misses a row.

  3. 3

    Log the session.

    Ask the Assistant to add it to a practice log table, with the feature you practiced, the formula and the range to check next time.

  • You can also ask the AI Assistant for a practice task that repeats every week.
  • You can also save screenshots of your sheets, and search finds the words in them later.

Keep the lessons, the practice and the progress together

Clip every lesson into one notebook, let the AI Assistant check your practice against it, and log what to fix next time.

Start for free