SelfStudy guide
Learn Excel in 10 Minutes a Day
Excel rewards small, daily wins. Ten focused minutes a day for 30 days takes you from formulas to your first dashboard.
Last updated: May 2026 · By the SelfStudy Editorial Team
The 30-day Excel plan
Week 1: navigation, references, basic formulas. Week 2: IF, VLOOKUP, INDEX/MATCH, XLOOKUP. Week 3: pivot tables and charts. Week 4: one mini dashboard from real data.
Shortcuts that save hours
Learn 5 shortcuts a week: Ctrl+; (date), Ctrl+Shift+L (filter), Alt+= (autosum), F4 (lock reference), Ctrl+T (table).
What to learn next
Once dashboards click, add Power Query, then Power Pivot, then a touch of VBA. That's an analyst-grade toolkit in 90 days.
Daily 10-minute plan
| Day | Today's 10-minute task |
|---|---|
| Day 1 | Cell references: relative vs absolute (F4). |
| Day 2 | SUM, AVERAGE, COUNT, MIN, MAX. |
| Day 3 | IF formula with 3 examples. |
| Day 4 | VLOOKUP basic syntax. |
| Day 5 | XLOOKUP and why it replaces VLOOKUP. |
| Day 6 | Conditional formatting. |
| Day 7 | Week 1 recap. |
Checklist
- Bookmark ExcelJet
- Keep a personal shortcut cheatsheet
- Build a small real dataset
- Commit to 30 days
Recommended courses & tools
Affiliate disclosure: Some links may be affiliate links. We may earn a commission at no extra cost to you.
Coursera
PopularBest for: University-level certificates
Online courses and degrees from top universities and companies, with verified certificates.
Pros
- Accredited certificates
- Strong catalog
- Financial aid available
Cons
- Some paywalled content
- Variable instructor quality
Udemy
Best for: Affordable practical skills
Massive library of self-paced practical courses on tech, business, and creative skills.
Pros
- Frequent deep discounts
- Lifetime access
- Huge selection
Cons
- Inconsistent quality
- Not accredited
Frequently Asked Questions
Do I need to pay for Excel courses?+
No — ExcelJet and Microsoft's own free guides are excellent. Paid courses help if you want a structured 30-day path.
Is XLOOKUP better than VLOOKUP?+
Yes, for modern Excel versions. Learn both since VLOOKUP still appears in legacy files.
Related guides
Get a free 30-day self-study planner
A printable PDF with daily goals, weekly reviews, and a flexible schedule. Delivered to your inbox.