Business & Productivity · Guide
How to learn Excel from scratch
A realistic order to learn Excel in, how long each stage takes, and the single habit that separates people who get good from people who keep googling the same formula.
The Nextversity teamBusiness & Productivity schoolUpdated August 10, 20266 min read
On this page
- The short answer
- Stage 1: the boring foundation (2 to 3 hours)
- Stage 2: the formulas that cover most days (4 to 6 hours)
- Stage 3: data, not just cells (4 to 6 hours)
- Stage 4: the two things that get called advanced (10 to 15 hours)
- Stage 5: only if you need it
- The habit that decides whether this works
- When not to start a course
The short answer
Learn Excel in this order: navigation and cell references, then core formulas, then sorting and filtering, then tables, then lookups, then pivot tables, then charts. Give it 20 to 30 minutes a day for six weeks and you will be past the level most job descriptions mean by "strong Excel skills".
The order matters more than the source. Almost every stalled Excel learner has the same problem: they jumped to pivot tables before they understood what a cell reference does, so nothing sticks and every task feels like a fresh search.
Stage 1: the boring foundation (2 to 3 hours)
Do not skip this. It is the difference between using formulas and understanding them.
- Moving around: Ctrl+arrow keys, Ctrl+Home, selecting ranges with Shift.
- Rows, columns, insert, delete, hide.
- Formatting that means something: number formats, dates, percentages, currency.
- Relative and absolute references.
A1moves when you copy a formula.$A$1does not.A$1and$A1lock one part. Almost every formula that goes wrong when filled down is this.
Practice: take any list you already have and format it properly. Boring, and it pays for itself in an hour.
Stage 2: the formulas that cover most days (4 to 6 hours)
Six functions do most of the work:
- SUM, AVERAGE, MIN, MAX for the basics
- IF for decisions:
=IF(B2>100,"Over","Under") - COUNTIF and SUMIF for conditional counting and totals
- TRIM, LEFT, RIGHT, TEXTJOIN for tidying text
- TODAY and DATEDIF for dates
- IFERROR to keep a sheet readable when something is missing
Learn what each one takes as arguments rather than memorizing the whole line. Excel's tooltip tells you the arguments as you type, so the skill is knowing which function to reach for.
Stage 3: data, not just cells (4 to 6 hours)
- Sorting and filtering, including sorting by more than one column
- Format as Table (Ctrl+T), which brings filters, banded rows and named ranges with it
- Removing duplicates and basic cleaning
- Conditional formatting to see the shape of a column at a glance
At this point you can handle a real dataset that someone emails you. That is a genuine milestone, and it usually arrives faster than people expect.
Stage 4: the two things that get called advanced (10 to 15 hours)
Lookups. XLOOKUP if your version has it, VLOOKUP and INDEX/MATCH if not. This is the skill that lets you join two lists together, and it is the single most requested Excel skill in job listings.
Pivot tables. Summarize thousands of rows in about four drags. They look intimidating and they are genuinely easy once someone shows you the field layout. Ten minutes of instruction saves ten hours of manual summing.
Pivot tables are the closest thing Excel has to a magic trick, and they are one of the easiest things in the whole program to learn. The reputation is entirely undeserved.
Add charts on top when the summary needs to be seen rather than read.
Stage 5: only if you need it
Power Query for repeatable imports and cleaning. Macros and VBA for automating a job you do the same way every week. Both are excellent and neither is a beginner requirement. Learn them when you have a specific repeated task, not because a list told you to.
If your data has outgrown a spreadsheet, the honest next step is SQL rather than a bigger workbook.
The habit that decides whether this works
Use your own data. Practice files are useful for the first week and then they stop teaching you anything, because the hard part of real work is that real data is messy.
Pick one thing you currently do by hand every week and rebuild it properly. That single project will teach you more than twenty videos, because it forces you to hit the edge cases nobody demonstrates. Microsoft's Excel support pages are a good reference when you get stuck mid-project, and Microsoft Learn has free guided modules if you genuinely have no data of your own.
Twenty focused minutes a day beats a four-hour Sunday. The four-hour Sunday happens twice.
When not to start a course
If you already have a course open that you have not finished, finish it first. If you need one answer today, search for that answer and get on with your work. And if your job is really a data analysis job rather than a spreadsheet job, look at Excel data analysis or SQL rather than a general Excel path.
If you want the whole skill in order, the introduction course starts from a blank sheet and the Excel certificate carries through lookups, pivot tables and reporting. Both are in the Business & Productivity school, and one subscription opens every course we have, so switching paths never costs you anything.
The people who get good at Excel are not the ones who watched more. They are the ones who rebuilt one boring report and never did it by hand again.
Questions people ask
How long does it take to learn Excel?
Around 10 to 15 hours of practice gets you comfortable with the everyday tools: formatting, sorting, filtering and basic formulas. Reaching the level most office jobs mean by advanced Excel, including lookups and pivot tables, is usually 40 to 60 hours spread over a couple of months.
Can I learn Excel on my own?
Yes, and most people do. The limiting factor is not information, it is structure. Pick one path and finish it rather than collecting tutorials, and use your own real data as soon as you can.
What should I learn in Excel first?
Navigation and cell references first, then SUM, AVERAGE, IF and COUNTIF, then sorting and filtering, then tables. Lookups and pivot tables come next. Macros can wait until you have a repeated job worth automating.
Is Excel still worth learning?
Yes. It is still the default tool for handling data in most workplaces, and it is often the fastest route to a usable answer. It is also the on-ramp to SQL and Power Query when the data outgrows a sheet.
Do I need a course or are free videos enough?
Free videos are fine for a single question. A course is worth it when you want the whole skill in order, with practice files and something to show at the end. If free tutorials have not stuck yet, more of them is unlikely to be the fix.