MICROSOFT EXCEL · COMPLETE VIDEO COURSE

Stop Googling the same Excel formula every week.

122 short lessons across 18 modules, in the order a beginner actually needs them — mechanics, formulas, cell references, lookups, pivot tables, charts, and 12 lessons of VBA that turn Monday’s report into one button.

699once · no subscription

That’s under ₹6 a lesson — and you keep them for good.

Try it 7 days — refund with one email, keep what you’ve downloaded.

Or watch a full lesson first — free, start to finish ↓

Razorpay-securedUPIGPayPhonePeCardsNet Banking7-day refund
122 lessons · 18 modulesInstant access by email✓ Watch on any device✓ Yours indefinitely
Microsoft Excel — Complete Video Course — 122 video lessons
SEE IT BEFORE YOU BUY

Watch a full lesson. Then decide.

Not a trailer — an entire lesson, exactly as it appears in the course. If the pace and the teaching style work for you, the other 121 are the same.

One complete lesson, unedited — the same format all 122 follow.

WHAT CHANGES

Five things you’ll stop doing the hard way.

NowCopy a formula down and watch it break
AfterKnow instantly whether you need $A$1, A$1 or A1 — and whyCell References · 6 lessons
NowMatch two sheets by hand, row by row
AfterPull any column from any table with VLOOKUP, XLOOKUP or INDEXLookup Functions · 5 lessons
NowScroll 4,000 rows hunting for the number
AfterAnswer it with a pivot table in about thirty secondsPivot Tables · 9 lessons
NowColour-code cells manually every week
AfterSet a rule once and let the sheet flag itselfConditional Formatting · 14 lessons
NowRebuild the same report every Monday
AfterRecord it once, then press one buttonVBA & Macros · 12 lessons
THE FULL CURRICULUM

All 122 lessons, listed. Check before you buy — not after.

18 modules. Every lesson title is below — open any module to read exactly what’s in it. We’d rather you find the gap now than discover it after paying.

Getting started & workbooksThe file-level mechanics nobody teaches you properly.
  1. Create and close a workbook
  2. Save a workbook
  3. Change the number of worksheets
  4. Set a password on an Excel file
  5. Insert and rename worksheets
  6. Hide and unhide worksheets
  7. Move or copy worksheets within a workbook
  8. Move or copy worksheets to another workbook
Rows, columns & cellsRestructuring a sheet without breaking it.
  1. Insert rows and columns
  2. Hide and unhide rows and columns
  3. Delete rows and columns
  4. Insert and delete cells
  5. Freeze panes on rows and columns
Working with dataEntering, editing and moving data at speed.
  1. Enter data
  2. Edit data
  3. Move data
  4. Duplicate data
  5. Enter data with the fill handle
  6. Custom patterns with the fill handle
  7. Drag and drop
  8. Delete data
Find & replaceIncluding the formatted-value searches most people never find.
  1. Find a value
  2. Find a formatted value
  3. Find all matches at once
  4. Find and replace a value
  5. Find and replace formatted values
Formulas & operatorsWhat a formula actually is, and the order Excel resolves it in.
  1. What is a formula and a function
  2. Arithmetic operations in formulas
  3. Order of operations
Cell referencesThe single concept that separates people who can copy a formula from people who can't.
  1. What is a cell reference
  2. Relative reference
  3. Relative reference — worked examples
  4. Absolute reference
  5. Absolute reference — worked example
  6. Mixed reference
Date & time functionsDates are where most spreadsheets quietly go wrong.
  1. YEAR, MONTH, DAY, DATE
  2. NOW and TODAY
  3. HOUR, MINUTE, SECOND and TIME
  4. EDATE and EOMONTH
  5. WEEKDAY and WEEKNUM
Logical functionsBuilding conditions Excel can evaluate.
  1. AND
  2. NOT
  3. OR
Error-checking functionsCatching the #N/A and #DIV/0! before someone else does.
  1. ISERROR
  2. ISNUMBER
  3. ISNA
  4. ISBLANK
Core calculationsThe handful of functions that do most of the work in most sheets.
  1. COUNT
  2. COUNTIF
  3. SUMIF
  4. SUM
  5. AVERAGE
  6. MIN and MAX
Math & number functionsRounding, sign, and generating test data.
  1. ABS
  2. EVEN
  3. INT
  4. RAND
  5. RANDBETWEEN
Lookup functionsThe skill every Excel job description asks for by name.
  1. VLOOKUP
  2. VLOOKUP with MATCH
  3. HLOOKUP
  4. VLOOKUP with INDEX
  5. XLOOKUP
Conditional formattingMaking the sheet point at what matters, automatically.
  1. What is conditional formatting
  2. Create a conditional formatting rule
  3. Revise a rule
  4. Add additional rules
  5. Delete rules
  6. Highlight top and bottom values
  7. Highlight above and below average values
  8. Data bars
  9. Colour scales
  10. Icon sets
  11. Highlight text values
  12. Show duplicate values
  13. Highlight rows
  14. Highlight rows using multiple criteria
Excel tablesStructured ranges — sorting, filtering, dedupe and slicers.
  1. What is an Excel table
  2. Create a table
  3. Remove a table
  4. Table options
  5. How table ranges work
  6. Add a totals row
  7. Remove duplicates from a table
  8. Sort a table
  9. Use table filters
  10. Working with table rows and columns
  11. Add a slicer to a table
  12. Slicer options
Pivot tablesSummarising thousands of rows without writing a formula.
  1. Pivot table introduction
  2. Why you should use a table for your pivot table
  3. Add fields to a pivot table
  4. Rearrange fields
  5. Field settings
  6. Format numbers in a pivot table
  7. Change the math used for pivot values
  8. Control grand totals
  9. Control subtotals
ChartsThe five charts that cover almost every real reporting need.
  1. Bar chart
  2. Column chart
  3. Line chart
  4. Pie chart
  5. Scatter chart
Keyboard shortcutsWhere the speed actually comes from.
  1. File commands
  2. Cell editing
  3. Cut, copy and paste
  4. Undo and redo
  5. Entering data
  6. Find and replace
  7. Navigating a workbook
VBA & macrosThe part most people never reach — automating the work away.
  1. The Visual Basic Editor interface
  2. Enable the Developer tab
  3. Record a macro
  4. Save a macro
  5. Write a simple macro
  6. Enter data using VBA
  7. Insert rows and columns with VBA
  8. Hide and unhide rows with VBA
  9. Hide columns with VBA
  10. Change column width with VBA
  11. Change row height with VBA
  12. Delete rows and columns with VBA

Just added: a new Power Query module. Its lesson titles are being added to this list — everything else above is the complete, final list.

SOUND FAMILIAR?

This is built for one person in particular.

Not the analyst who already writes macros. The person who uses Excel every day and has never actually been taught it.

  • You use Excel at work but learned it by guessing
  • You can manage SUM and sorting, then freeze at VLOOKUP or a pivot table
  • You copy a formula down, it breaks, and you can't say why
  • You rebuild the same report by hand every week
  • You're starting at zero and want the whole thing in order, once

If that’s you, the 122 lessons above are in the order you need them.

THE PART MOST PEOPLE NEVER REACH

The last 12 lessons are the ones that give you your evenings back.

Plenty of people learn Excel up to pivot tables and stop there. This course has 12 more lessons after them, and they are the ones that matter on a Monday: enable the Developer tab, record a macro, save it, then write simple ones yourself — inserting rows, hiding columns, setting widths, deleting ranges. The weekly report you rebuild by hand becomes a button you press.

Try it 7 days — refund with one email, keep what you’ve downloaded.

ONE COURSE, OR ALL THREE FOR ₹300 MORE

Two courses cost ₹998. All three cost ₹999.

Office jobs rarely ask for Excel alone. Both companion courses are built exactly like this one — short, ordered, practical. Here is the part worth reading twice: Excel plus one of them is ₹998. Excel plus both is 999. The third course costs ₹1.

Excel only
699
122 lessons · one-time
  • All 18 Excel modules
  • Lifetime access
  • 7-day refund
Excel + one more
998
170 lessons · one-time
  • Excel, plus Word or PowerPoint
  • Added at checkout in one tap
  • ₹1 more gets you the third
BEST VALUE
Full Office Kit
1,297999
204 lessons · one-time
  • All three courses
  • Excel + Word + PowerPoint
  • Word and PowerPoint together add ₹300

That ₹1297 isn’t an invented “value” — it’s exactly what the three cost separately at this same checkout (₹699 + ₹299 + ₹299). All three options appear when you click below: start with Excel and add what you want, or take the Kit in one tap. Same checkout either way.

Excel, Word and PowerPoint video courses — 204 lessons
THE RISK IS OURS

Watch the whole thing. Decide after.

You have seven days. Open every module, try the lookups, run a macro — and if it isn’t what you wanted, send one email and we refund every rupee. No form, no reason required, no “what didn’t you like” interrogation.

You keep whatever you’ve already downloaded. We’re not going to chase you for files — if the course didn’t earn the ₹699, that’s our problem to fix, not yours.

We make study material for Indian job-seekers — SQL, Java, DSA, Excel. Most of it is practice questions, which quietly assumes you already know the tool. This course is the part that comes first: Excel taught in order, from what a workbook is to writing a macro, with every lesson title published above so you can check the sequence before you spend a rupee. We didn’t put a certificate on it or call it a bootcamp, because it isn’t one. If it doesn’t do the job, the refund is one email and we won’t ask why.

— the team at Learn and Excel

STRAIGHT ANSWERS

Questions people ask before they buy.

Isn't all of this free on YouTube?

Honestly — yes. Nearly every one of these 122 topics exists free somewhere on YouTube, and if you have the patience to hunt them down, you genuinely should. What ₹699 buys is the order: 122 lessons already sequenced from what a workbook is to writing a macro, with nothing missing in the middle and nothing you have to go looking for. No ads, no fifteen-minute video for a three-minute idea, no discovering halfway that the next one assumes something you skipped. If your time isn't worth ₹699, YouTube is the better deal and we'd rather say so.

How do I actually get the course after I pay?

Instantly, by email. The email carries a small PDF; open it and the Google Drive link to the full course folder is inside. Nothing to install, no login to create, no waiting for approval.

How long do I have access?

Indefinitely. The download link in the email expires after 30 days, but the Drive folder it points to doesn't — save the link or the PDF and the course stays yours. If you ever lose it, email us and we'll resend.

Which version of Excel do I need?

The lessons are shot in Microsoft Excel for Windows. Almost everything applies identically in Excel 2016 onwards and in Microsoft 365. XLOOKUP is the one function that needs a recent version (Microsoft 365 or Excel 2021) — the VLOOKUP, HLOOKUP and INDEX/MATCH lessons cover the same job on older versions.

Can I watch on my phone?

Yes — the folder plays on a phone. But Excel itself is a laptop tool, so the honest advice is: watch a lesson on whatever you have, and practise on a computer.

Is this subtitled or in Hindi?

The lessons are in English.

Do I get a certificate?

No. No certificate, no assessment, no completion badge. This is a skills course, not a credential — you're buying the ability to do the work, not a line for your CV. If a certificate is what you actually need, look at Microsoft's official certification; this course is not exam prep for it.

Why is it only ₹699?

Because it's recorded once and sold many times, and because nothing expensive is attached to it. No classroom, no batch timings, no salesperson calling you. It also means it isn't a bootcamp: no live classes, no doubt-clearing sessions, no mentor, no certificate, no placement help. It is 122 recorded lessons and a curriculum you can read in full before you spend anything. ₹699 is what that is worth, so that's the price.

Is it one payment, or a subscription?

One payment. There's no renewal and no auto-debit. The Word and PowerPoint courses at checkout are optional add-ons, priced clearly — never a trap.

What's inside — and what isn't?

Inside: the full 122 lessons listed above — mechanics, formulas and references, date and logic functions, lookups (VLOOKUP, XLOOKUP, INDEX/MATCH), conditional formatting, tables, pivot tables, charts, shortcuts, and a complete VBA module. A new Power Query module has also just been added — its lesson titles are being added to this page. Not inside: IF/IFS logic chains, dynamic arrays, Power Pivot, financial modelling, or certification exam prep. Everything listed above is the real list — nothing is hidden behind it.

What if it isn't for me?

Email us within 7 days and we refund in full. You keep whatever you've already downloaded — we're not going to chase you for files.

Is my payment safe?

Razorpay handles the payment — the same gateway behind major Indian brands. UPI, cards and net-banking all work. We never see your card details.

Try it 7 days — refund with one email, keep what you’ve downloaded.

122 lessons. ₹699, once.

Straight about the edges: this course does not cover IF/IFS logic chains, dynamic arrays, or Power Pivot. Everything it does cover is listed above, lesson by lesson.

Learn it properly once, and stop looking it up every time.

Try it 7 days — refund with one email, keep what you’ve downloaded.