Excel and Spreadsheets for Jobs: Free Course
Go from your first formula to a polished dashboard using free tools, with the lookups and pivots every office expects.
About this course
A free, job-focused Excel course covering the skills offices actually test: formulas, IF and nested logic, VLOOKUP and XLOOKUP, SUMIFS and COUNTIFS, text and date cleaning, pivot tables, charts and a one-page dashboard. Every formula comes with a predict-the-result exercise so you build real intuition, and everything works in free tools: Excel on the web, Google Sheets or LibreOffice.
Who it's for
Students, freshers and office professionals who want job-ready spreadsheet skills.
What you will learn
- Move around a spreadsheet with confidence: cells, ranges, the Name Box and formatting that makes data readable
- Write formulas with SUM, AVERAGE, COUNT, MIN and MAX, and understand relative, absolute and mixed references
- Use IF, nested IF, AND, OR and IFERROR to build decision logic
- Clean text and dates with TRIM, LEFT, RIGHT, MID, TEXT and date functions
- Look up data with VLOOKUP, XLOOKUP and INDEX MATCH, and summarise with SUMIFS and COUNTIFS
- Build pivot tables and charts and combine them into a one-page dashboard
- Answer the Excel questions that come up in office and data entry job tests
Course syllabus: 4 weeks, 36 lessons
Week 1: Spreadsheet Foundations & First Formulas
- Spreadsheet Se Darna Band. Tumhara Pehla Formula.
- Cells, Rows, Columns & the Name Box
- Formatting That Makes Data Readable
- SUM, AVERAGE, COUNT, MIN, MAX
- Writing Your Own Arithmetic Formulas
- The Formula Bar, Errors & Editing
- Relative References & Filling Down
- Absolute References ($): Lock a Cell
- Mixed References & Week-1 Build
Week 2: Logic, Text & Conditional Math
- IF: The Decision Formula
- Nested IF & IFS: Multiple Grades
- AND, OR, NOT inside IF
- Text Functions: CONCAT, LEFT, RIGHT, MID, LEN, TRIM
- Dates & TODAY: Age, Tenure, Deadlines
- Find & Replace, Flash Fill, Split Text
- COUNTIF & COUNTIFS: Count by Condition
- SUMIF, AVERAGEIF & Their Plural Forms
- Week-2 Build: A Conditional Report
Week 3: Lookups & Data Tools
- VLOOKUP: Excel's Most Famous Formula
- VLOOKUP Gotchas + HLOOKUP
- XLOOKUP & INDEX-MATCH: The Modern, Flexible Way
- Sort & Filter: Find What Matters
- Data Validation: Dropdowns & Rules
- Remove Duplicates & Find Duplicates
- Conditional Formatting: Colour the Story
- Named Ranges & Cleaner Formulas
- Week-3 Build: A Lookup-Powered Sheet
Week 4: Pivot Tables, Charts & Your Dashboard Capstone
- Pivot Tables: Summarise Anything in 10 Seconds
- Pivot Table Power: Group, Sort, % of Total
- Slicers & Pivot Charts: Interactive Summaries
- Charts: Bar, Line, Pie, and When to Use Each
- Formatting Charts to Look Professional
- Sparklines & Mini-Visuals
- Build a One-Page Dashboard
- Keyboard Shortcuts That Make You Look Pro
- Capstone Showcase + Interview Q&A Drill
Certificate
The course is free. When you finish every lesson you can get a verified certificate for Rs 99 (GST included). It carries a QR code anyone can scan to verify it, so you can add it to your resume and LinkedIn.
Why Techwave Academy
Techwave Academy is a free, hands-on learning platform built for Indian students K-12 and self-learners. Every course is interactive: code runs in your browser, AI mentors explain every concept, and progress is tracked end-to-end. No installs, no signup walls, no hidden costs. Just learn.
Sign up free and start learning
Create a free account and open Excel and Google Sheets Essentials in seconds. No credit card. No spam.
Start this course freeFrequently asked questions
Is this Excel course free?
Yes. Every lesson is free, and everything works in free tools: Excel on the web, Google Sheets or LibreOffice Calc.
Do I need to buy Microsoft Excel?
No. Excel on the web is free with a Microsoft account, and Google Sheets works for almost every lesson.
Is it good for job interviews?
Yes. The course covers VLOOKUP, XLOOKUP, SUMIFS, pivot tables and dashboards, which are the skills office and data jobs test most.
I am a complete beginner. Can I start?
Yes. Week 1 starts from your first formula, and every formula has a predict-the-result exercise to build intuition.
Which language are the lessons in?
English with Hinglish narration, written for Indian students, freshers and office staff.