📊 We use cookies & analytics to improve your experience. Learn more
Latest

Free course · Beginner

Excel for Freshers — From Spreadsheet to Shortlist

🏛 Way2Fresher Academy ⏱ 5 weeks ⭐ 4.8 👥 15,600 learners 🎓 Certificate

Free 5 modules · 15 lessons Start now →

What you will learn

  • Lay out a sheet that survives being handed to somebody else — headers, types, no merged cells in the data
  • Write the formulas offices actually use: SUM, AVERAGE, COUNTIF, SUMIF, IF, XLOOKUP, INDEX-MATCH, TEXT and ROUND
  • Clean a real export — duplicates, stray spaces, dates that arrived as text — without retyping it
  • Summarise thousands of rows with a pivot table in minutes instead of hours
  • Build a one-page dashboard a manager reads in thirty seconds
  • Answer "how did you get this number?" all the way down to the cell it came from

Course curriculum

5 modules · 15 lessons · a worked example and a practice task in every lesson

Module 1The sheet that survives a handover1 of 53 lessons

Week 1 — structure, types and formatting that means something. Most broken spreadsheets are broken here, before a single formula is written.

  1. A sheet is a model, not a table

    One row per record, one column per field, a header row that never moves, and no blank rows in the middle. That is the whole rule, and it is what makes sorting, filtering and pivoting work later.

    The lesson

    A spreadsheet is a small model of a business: one row per record, one column per field, one header row, and the totals kept away from the data. Every function, pivot and chart in this course assumes that shape, so the sheet you build first is the one that makes the rest possible.

    Set the column order once — id, date, category, amount, notes — and never move it. Format dates as dates and amounts as numbers, which you can check by the fact that real numbers sit on the right of the cell by default. A number stored as text is invisible to SUM and to every pivot.

    The mistake is a merged header across three cells and a blank row between months. A merged cell breaks sorting and a blank row splits the data into two tables, so the pivot quietly ignores half the sheet. Colour the headers instead, and never leave a gap.

    Spreadsheet
    id | date       | category | amount | notes
1  | 2026-01-04 | travel   | 240.00 | auto
2  | 2026-01-05 | food     | 180.00 |

Rules: one header row . no blank rows . no merged cells .
       totals kept OUTSIDE the data .
       dates are dates and numbers are numbers.

A number stored as text sits on the LEFT and is invisible to SUM.

    Example A sales sheet with a blank row between months sorts the months alphabetically and breaks every total below it. The blank row was a design choice, and it was the wrong one.

    Practice Take any sheet you already have and rewrite it as one clean block: single header row, no blanks, no merged cells in the data area, and one column per fact.

  2. Formatting that carries meaning

    Number formats, freeze panes and conditional formatting are not decoration. They are how a reader knows a column is money, a date or a percentage without being told.

    The lesson

    Formatting in a work sheet is not decoration, it is communication: bold for a header, a thousand separator on money, one or two decimals on percentages, and a consistent date format. A reader should be able to tell a total from an input by looking, without a legend.

    Two habits do most of it. Freeze the top row and the first column so the headers stay visible while you scroll. And use conditional formatting for the one thing you need to see fast — amounts under a threshold in red, blank cells highlighted — rather than colouring rows by hand, which goes stale as the data changes.

    Three sets of numbers are worth knowing: number, currency and percentage. A percentage cell that shows 0.15 instead of 15% makes every reader stop and recalculate, and one cell formatted wrongly among hundreds is what gets a sheet distrusted.

    Spreadsheet
    Freeze the header row and first column:
  View -> Freeze Panes -> Freeze Panes

Conditional formatting for the one thing you must see fast:
  Amount < 100   -> red
  Blank cells    -> yellow fill

Number formats:  #,##0   .   Rs#,##0   .   0.0%
(0.15 shown as 0.15 and not 15% makes every reader recalculate.)

    Example Formatting 12000 as currency changes what the reader assumes; colour-scaling a margin column makes the bad rows find themselves. Merged cells, by contrast, break sorting and look identical in every screenshot on the internet.

    Practice Format one sheet properly: freeze the header row, set currency and percentage formats, and add a conditional format that highlights any value below target.

  3. Absolute and relative references

    The dollar sign in $B$2 is the difference between a formula you write once and a formula you write forty times. This is the single most common gap in a fresher sheet.

    The lesson

    A reference without dollars — A2 — moves when you copy the formula down, which is what you want for rows. A reference with dollars — $A$2 — stays fixed, which is what you want for a rate, a target or a lookup table that lives in one place. Two characters decide which.

    Mixed references are the useful in-between: $A2 locks the column but lets the row move, and A$2 does the reverse. They are how a multiplication table is filled from one formula, and how a formula dragged across months keeps pointing at the same starting cell.

    The mistake is writing a formula without dollars, copying it down, and getting errors that look like missing data. Click the cell with the error, press F2, and watch which references moved — the wrong arrow is the whole bug, and it becomes obvious in two seconds.

    Spreadsheet
    =A2*$B$1        the rate in B1 stays fixed as you copy down
=B2*(1+$C$2)    the tax rate stays fixed
=$A2            column locked, row moves
=A$2            row locked, column moves

Copy a formula without dollars and get errors?
Click the cell, press F2, and watch which reference moved.

    Example A rate stored in $B$1 and referenced from C2 as =B2*$B$1 copies down correctly. Written as =B2*B1 it drifts to B2, B3, B4 and produces plausible wrong numbers — the worst kind of wrong.

    Practice Build a small invoice sheet with one tax rate cell, then copy the formula down twenty rows and check that every result still points at that one cell.

Show all modules on one page

About Excel for Freshers — From Spreadsheet to Shortlist

Open a messy export of ten thousand rows and turn it into one page a manager can act on — with formulas you can explain line by line.

Commerce, BBA, BSc and engineering students who have "MS Office" on the resume but have never built a sheet somebody else depends on. Also for anyone whose work already runs on Excel and who wants to stop doing by hand what a formula can do.

What you will be able to do at the end

  • Lay out a sheet that survives being handed to somebody else — headers, types, no merged cells in the data
  • Write the formulas offices actually use: SUM, AVERAGE, COUNTIF, SUMIF, IF, XLOOKUP, INDEX-MATCH, TEXT and ROUND
  • Clean a real export — duplicates, stray spaces, dates that arrived as text — without retyping it
  • Summarise thousands of rows with a pivot table in minutes instead of hours
  • Build a one-page dashboard a manager reads in thirty seconds
  • Answer "how did you get this number?" all the way down to the cell it came from

How the course is structured

3 modules and 9 lessons, arranged so each one ends with something you have built. Every lesson carries a worked example and a practice task — the practice is the course, the reading is only the setup. Plan for 5 weeks · about 5 hours a week.

The full syllabus — every lesson, its example and its practice task — is in the Course curriculum below. Nothing is locked and nothing needs an account.

Your weekly routine

  • Three 75-minute sessions a week: one lesson, then its practice task on your own data.
  • One 30-minute review on the weekend rebuilding that week's practice from a blank sheet.
  • Keep every sheet in one workbook called something you would show an interviewer.

What you will have built by the end

  • A cleaned, pivot-ready copy of a real dataset — with a one-page note on what you removed and why
  • A region-by-month sales dashboard on one printable page
  • A personal expense-and-savings tracker you keep using after the course ends

Where this leads for a fresher

  • MIS executive and back-office analyst roles
  • Operations, logistics and HR coordinator roles
  • Finance and accounting assistant roles
  • The Excel round inside almost every services-company fresher test

Titles vary between companies; the evidence does not. A deployed project, a set of queries you can explain, or a case study with real testing behind it is what a fresher interview has to work with.

Frequently asked questions

Do I need a paid Excel or Microsoft 365 subscription?

No. Excel on the web is free with a Microsoft account, and everything in this course except XLOOKUP works in Google Sheets too. INDEX-MATCH is taught precisely because it works everywhere.

I only have a phone. Can I do this course?

Reading and the quizzes, yes; the practice tasks, not really. Formulas and pivots need a keyboard and a mouse. Plan for one hour at a shared computer or a college lab three times a week.

Is this course free?

Yes. Every lesson, example and practice task is free to read here, and there is nothing to buy to finish it.

How is this different from the hundreds of Excel videos online?

Two things. It is written in order — you finish with one workbook you built, not a memory of the videos you watched — and it ends with a printed dashboard, which is the artefact you take into an interview. Take the free Career Pulse check if you are unsure whether Excel is the right six weeks for you.

Not sure which of these you need first? The free Career Pulse check scores your skills, communication and goal clarity in about three minutes and tells you which gap to close first. Take the free check.