Final-year students
Placement season is close and your resume still has no project on it.
Finish with three pieces of work you can demo in an interview.
Data
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.
- 5 weeksEstimated time
- 5Modules
- 15Lessons
- 3Projects
- YesCertificate
- FreePrice
No credit card. No sign-up required to preview. See the full syllabus
Who this course is for
Three people take this course. The work is the same; the reason is different.
Fresh graduates
You have the degree, but the job ads ask for proof of skill.
Build a portfolio before the next hiring round, not after it.
Career switchers
You are experienced elsewhere, new to this field, and starting from zero.
Learn the vocabulary and ship one published project that proves the switch.
Proof, not notes
What you will build
Every module ends in something finished. These are the pieces you leave with.
A cleaned, pivot-ready copy of a real dataset
with a one-page note on what you removed and why
Skills used Data · EXCEL
Portfolio project
A region-by-month sales dashboard on
one printable page
Skills used Data · EXCEL
Portfolio project
A personal expense-and-savings tracker you
keep using after the course ends
Skills used Data · EXCEL
Portfolio project
The brief
Your final project
A personal expense-and-savings tracker you
keep using after the course ends
- Write down, in one sentence, what the finished thing does and who it is for.
- Build it with the tools this course taught. A borrowed project cannot be explained in an interview.
- Run it from a clean start on another machine, and fix whatever breaks.
- Publish it, and put the link at the top of your resume's project section.
What changes
What you will be able to do
Not definitions to recite — tasks you can open a laptop and complete.
Roles this supports MIS executive and back-office analyst roles · Operations, logistics and HR coordinator roles · Finance and accounting assistant roles
- 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
The syllabus
Course curriculum
5 modules · 15 lessons. Open a module to see its outcome and lesson titles.
Module 1 The sheet that survives a handover Structure, types and formatting that means something. Most broken spreadsheets are broken here, before a single formula is written.
- 01 A sheet is a model, not a table Free preview
- 02 Formatting that carries meaning
- 03 Absolute and relative references
Deliverable 3 practice tasks, one per lesson
Module 2 The formulas you will actually use Counting, deciding and looking things up. Twelve functions cover almost every office job; these are they.
- 04 Counting and adding on a condition
- 05 IF and nested IF without the panic
- 06 Looking things up — XLOOKUP and INDEX-MATCH
Deliverable 3 practice tasks, one per lesson
Module 3 From ten thousand rows to one page Cleaning, pivoting and presenting. This is the part of the course that turns into a portfolio piece.
Deliverable 3 practice tasks, one per lesson
Module 4 Tables and rules that keep a sheet correct Structured tables, validation and formula-driven formatting, so the sheet stays right without you.
- 10 Structured tables and named ranges
- 11 Data validation and drop-downs
- 12 Conditional formatting with formulas
Deliverable 3 practice tasks, one per lesson
Module 5 Bigger data without bigger effort Power Query, what-if analysis and one macro, so the weekly report is built once and run forever.
- 13 Power Query: clean once, refresh forever
- 14 What-if, Goal Seek and scenarios
- 15 LAMBDA and the weekly report you stop doing
Deliverable 3 practice tasks, one per lesson
Lesson explanations, worked examples and practice tasks are in the learning player, not on this page — so you can read the syllabus without scrolling through the whole course.
How the course works
Every lesson follows the same four steps. No passive video playlists.
- 1
Learn the concept
A short explanation in plain English, with the one idea the lesson depends on.
- 2
See a worked example
The same task done end to end, with the reasoning behind each step.
- 3
Complete the practice task
You write it yourself. The task is the lesson; the reading is only the setup.
- 4
Build and publish a project
Each module ends in work you can open, explain and attach to an application.
Way2Fresher Academy
Courses written for the fresher hiring market — not translated from a bootcamp built for another country.
- Plain English Every explanation is written to be read once, slowly, by someone new to the field.
- Project-first A practice task in every lesson and a project at the end of every module.
- No paywall The full syllabus, all lessons and the certificate are free. Nothing is held back for a paid tier.
3Portfolio projects
15Lessons
The work is the proof
A fresher interview cannot assess a certificate. It can assess a project you can open, explain and change on the spot — which is why every course here ends in one.
- A finished project brief with an evaluation checklist
- A shareable repository, dashboard or case study
- A certificate that records the work, once every lesson is done
Frequently asked questions
The answers that decide whether this is the right six weeks.
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 AltiGrad check if you are unsure whether Excel is the right six weeks for you.
Do I need coding experience?
No. This course is written for beginner learners and every lesson starts from the tool itself. If you can use a browser and a file, you can start lesson one today.
How long will it take?
About 5 weeks. The course holds 15 lessons, each built around one practice task, so the calendar depends on how many sessions you can keep each week.
Will I get a certificate?
Yes. Finish every lesson while signed in and a certificate with your name, the course, the date and the skills covered unlocks on this site. It is a record of work completed here, not an accredited qualification.
Start this course free.
No credit card. No sign-up required to preview. Lesson one is open now.
Excel for Freshers — From Spreadsheet to Shortlist
Start Course Free