.png)
Excel formulas
Write SUM, IF, COUNTIF and nested formulas that work the first time, and learn to read error messages.
Master Excel,
hands on.
Our bite-sized, interactive lessons make Excel skills easy to learn and remember. You learn by doing, not by watching.
Lesson 4 · Your first lookup
Goal: Find the price of product A-17 using XLOOKUP.
fx=XLOOKUP(A2, Products!A:A, Products!C:C)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | SKU | Item | Qty | Price |
| 2 | A-17 | Pens | 40 | $2.40 |
| 3 | B-02 | Notebooks | 12 | $5.10 |
| 4 | C-33 | Stapler | 6 | $9.80 |
✓Correct! XLOOKUP returned $2.40.
Learning that actually sticks
3-minute lessons
100% hands-on
0 setup needed
Follow a path from beginner to confident.
Path 1
Excel Foundations
Cells, formulas, formatting and your first charts. Zero experience required.
Path 2
Analyst Toolkit
Lookups, pivot tables and data cleaning for real reporting work.
From practice to mastery.
01
Do the task
Every lesson drops you into a real spreadsheet with one small goal. No videos to sit through.
02
Get instant feedback
We check your formula as you type and show you why it works, or why it didn’t.
03
Lock it in
Short repeats of what you missed make the skill stick, so you remember it next week.
What you’ll be able to do.
Write formulas that don’t break
Look up data across sheets
Build pivot tables in minutes
Clean messy exports fast
Make charts people understand
Use conditional formatting
Automate with dynamic arrays
Move faster with shortcuts
Learn Excel online
The fastest way to learn Excel is to use it.
ExcelPanda is an interactive Excel course built around short, practical exercises. Each lesson gives you a small goal, a real spreadsheet and instant feedback, so you learn formulas, functions and data skills by doing them.
Whether you are starting from zero or tightening up your skills for work, you will build the habits that matter: clean data, readable formulas and reports you can trust.
Excel topics you can learn here
Lookups and references
Pull data across sheets with XLOOKUP, VLOOKUP and INDEX/MATCH, and understand absolute versus relative references.
Pivot tables
Summarize thousands of rows in a few clicks, group dates, and build reports that update on refresh.
Charts and visuals
Pick the right chart, format it cleanly and make the key point obvious at a glance.
Data cleaning
Fix messy exports with TRIM, TEXTSPLIT, Flash Fill and Power Query basics.
Keyboard shortcuts
Navigate, select and format without the mouse and finish routine work in a fraction of the time.
Learning by doing vs. watching videos
| Feature | Video courses | ExcelPanda |
|---|---|---|
| You practice | After the video, if at all | In every lesson |
| Feedback | None, you check yourself | Instant, on your formula |
| Lesson length | 10 to 40 minutes | About 3 minutes |
| Remembering it | Rewatch to refresh | Short repeats of what you missed |
Excel learning questions, answered
How do I learn Excel from scratch?+
Start with cells, ranges and basic formulas such as SUM and AVERAGE, then move to lookups, pivot tables and charts. ExcelPanda breaks each of these into short, hands-on lessons so you practice every skill in a real spreadsheet instead of only reading about it.
How long does it take to learn Excel?+
Most people can handle everyday tasks like formulas, formatting and simple charts within a few weeks of short daily practice. Lookups, pivot tables and data cleaning usually take a little longer, which is why lessons are kept to a few minutes each.
Do I need Excel installed to use ExcelPanda?+
No. Lessons run in the browser, so there is nothing to install or set up before you start.
Which Excel functions should I learn first?+
SUM, IF, COUNTIF, XLOOKUP and INDEX/MATCH cover a large share of real-world work. After those, learn SUMIFS, TEXTJOIN, FILTER and pivot tables.
Is learning by doing better than watching videos?+
Videos are easy to follow but easy to forget. Typing the formula yourself, seeing the result and fixing mistakes builds the muscle memory that makes skills stick.
Is ExcelPanda free?+
You can start with free lessons today. Paid plans for the full library may be added later, and the free lessons will remain free.
Never feel lost in a spreadsheet again.
Start with a 3-minute lesson. No setup, no credit card.
=SUM()=VLOOKUP()=XLOOKUP()=IF()=INDEX()=MATCH()=COUNTIFS()=SUMIFS()=TEXTJOIN()=FILTER()=LET()=PIVOT()=SUM()=VLOOKUP()=XLOOKUP()=IF()=INDEX()=MATCH()=COUNTIFS()=SUMIFS()=TEXTJOIN()=FILTER()=LET()=PIVOT()