You can become job-ready in Excel in a few weeks if you practise the right things, in the right order.
Week 1: basics
- Cells, rows, columns, formatting and number formats.
- SUM, AVERAGE, MIN, MAX, COUNT, and relative vs absolute references.
- Sorting, filtering and freeze panes.
Week 2: logic and text
- IF, AND, OR and IFERROR.
- COUNTIF, SUMIF and their multi-condition versions.
- TRIM, LEFT, RIGHT, MID and TEXTJOIN for cleaning data.
Week 3: lookups and analysis
- VLOOKUP and XLOOKUP, INDEX and MATCH.
- PivotTables and charts.
- Conditional formatting and data validation.
Week 4: job practice
- Business case studies with realistic data.
- Timed Excel interview questions and practical tests.
- Keyboard shortcuts for speed.
How to practise
Do not just watch videos. Type each formula yourself, change the data and see what happens. Short, daily practice (20 to 30 minutes) works better than one long weekend session.
Practise Excel formulas online for free on Cellgrids, then try the interview questions and case studies when you feel ready.
A four-week plan
Week 1: formatting, SUM, IF, absolute references. Week 2: VLOOKUP or XLOOKUP, SUMIFS, COUNTIFS. Week 3: PivotTables, charts, text and date functions. Week 4: practise on real data and mock tests.
Common mistakes
- Watching videos without practising.
- Learning rare functions before the basics.
- Never testing yourself under time.
Frequently asked questions
How long does it take to learn Excel for a job?
About four to eight weeks of daily practice covers most entry roles.
Which functions matter most?
IF, SUMIFS, COUNTIFS, XLOOKUP, INDEX MATCH, TEXT and PivotTables.
How do I show my skill?
A certificate and a small project with a dashboard.
Practice this online, free
Reading is only half of learning Excel. Cellgrids is a free place for online Excel practice: solve Excel formula exercises in a live spreadsheet, prepare for Excel interview questions, and work through business case studies built for data analytics and business analytics roles.
Practice these formulas: SUM, IF, VLOOKUP, SUMIFS.
Start Excel practice → Case studies
