Free Excel & Google Sheets Course — Formulas, VLOOKUP, Pivot Tables
Master Excel and Google Sheets free — SUM, IF, VLOOKUP/XLOOKUP, SUMIFS, data cleaning, pivot tables, charts and data validation. The highest-ROI office and data skill for Indian jobs, with real formulas and hands-on practice.
TL;DR: Master Excel and Google Sheets free — SUM, IF, VLOOKUP/XLOOKUP, SUMIFS, data cleaning, pivot tables, charts and data validation. The highest-ROI offic…
Written & reviewed by the Syllab.in Academic Team (CBSE/NCERT subject experts) · Updated
Free Excel course: 10 lessons, from the basics through to the advanced topics interviewers actually ask about. Every lesson is free, needs no sign-up, and runs in your browser with an editor and instant AI feedback.
Excel Course Syllabus — 10 Lessons
Work through them in order, or jump to the topic you need. 10 lessons include worked explanations and runnable examples.
Foundations
- Spreadsheets, Cells & References — A spreadsheet is a grid of cells organised into columns (letters A, B, C…) and rows (numbers 1, 2, 3…).
Formulas
- SUM, AVERAGE, COUNT, MIN & MAX — The most-used functions summarise a range of cells.
- IF & Logical Functions — IF makes a decision: `=IF(condition, value_if_true, value_if_false)`.
- VLOOKUP, XLOOKUP & INDEX/MATCH — Lookups pull a value from a table by matching a key — e.g.
- SUMIF, COUNTIF & AVERAGEIF — Often you want to summarise only the rows that meet a condition: total sales for one region, count of students who passed, average marks for one class.
Data Handling
- Text & Date Functions — Real data is messy: names with extra spaces, codes you must split, dates in odd formats.
- Sorting, Filtering & Data Cleaning — Before analysis, you organise data. Sorting reorders rows by a column (marks high-to-low, names A-Z); you can sort by multiple levels (by class, then by marks within each class).
Analysis
- Pivot Tables — Summarise Anything — A pivot table is the fastest way to summarise a large table without writing a single formula.
- Charts & Conditional Formatting — A chart turns numbers into a picture people grasp instantly.
- Named Ranges, IFERROR & Data Validation — Named ranges make formulas readable: name B2:B100 as "Sales" and write `=SUM(Sales)` instead of `=SUM(B2:B100)`.
Who this Excel course is for
School and college students in India starting from zero, and anyone revising Excel for placements, board practicals or a project. There is no prerequisite beyond being able to type — the first lessons assume no programming background at all.
How to study this course
- Read the lesson, then run the example in the built-in editor before moving on — reading code is not the same as writing it.
- Try the practice task at the end of each lesson. Getting it wrong and fixing it is where the learning happens.
- When you are stuck, ask the free AI Tutor to explain that specific line rather than skipping ahead.
🤖 Stuck on any of these? Ask Syllab's free AI Tutor to explain step by step →