X
excel.rean.meWork faster in Excel
Learning Guide•Beginner
Share on X (Twitter)Share on LinkedInShare on FacebookShare on TelegramShare on Reddit

30 Days to Get Better in Excel (Complete Step-by-Step Learning Guide)

Master Excel in 30 days! A complete roadmap from basic calculations to advanced formulas, lookups, financial functions, and dynamic arrays — one lesson per day.

Advertisement

Hello everyone! Do you want to get better with Microsoft Excel fast and easy? I make this 30-Day Excel Learning Plan for you!

Follow 1 lesson every day — from simple basic calculation all the way to advanced dynamic arrays and financial formulas. In just 30 days, you will build strong confidence and finish your Excel work much faster!

30 days to better excel guide

🗓️ The 30-Day Excel Roadmap (From Basic to Advanced)

🟢 Phase 1: Basic Foundations & Simple Calculations (Days 1 – 5)

🔹 Day 1: Master Essential Excel for Beginner

Start your journey by learning keyboard shortcuts! Stop using mouse for everything.

🔹 Day 2: Learn SUM Formula (Add Numbers Fast)

SUM is the most important formula in Excel. Learn how to add numbers in rows and columns without adding cell by cell manually.

🔹 Day 3: Learn AVERAGE, MIN & MAX Formulas

Find average sales, lowest price, or highest student score easily using AVERAGE, MIN, and MAX functions.

🔹 Day 4: Master Date & Time Functions (TODAY, NOW, DAY, MONTH, YEAR)

Learn how to insert current date automatically and extract day, month, or year from any date cell.

🔹 Day 5: Review Top 20 Basic Excel Formulas

Take time to review all fundamental formulas in one complete guide with practice tips!

🟡 Phase 2: Text Manipulation & Data Cleaning (Days 6 – 10)

🔹 Day 6: Change Text Case (UPPER, LOWER, PROPER)

Clean up messy text formatting! Automatically convert text to ALL CAPS, small letters, or Proper Title Case.

🔹 Day 7: Connect Text Values (CONCAT & & Operator)

Join first name and last name, or combine codes together using CONCAT formula and & ampersand operator.

🔹 Day 8: Advanced Text Cleaning (TRIM, CLEAN)

Remove annoying hidden spaces and bad characters when copying data from systems or websites.

🔹 Day 9: Master REPT & TEXTJOIN Formulas

Repeat characters to make mini visual bars or join text from multiple cells while skipping blank cells automatically!

🔹 Day 10: Extract Text (TEXTBEFORE, TEXTAFTER, TEXTSPLIT)

Pull out specific parts of text — everything before or after a delimiter, or split a full name into separate columns!

🟠 Phase 3: Logic, Conditions & Counting (Days 11 – 15)

🔹 Day 11: Learn IF Formula (Logical Conditions)

Make Excel make decisions for you! Automatically show "Pass" or "Fail", calculate bonuses, or apply discounts based on conditions.

🔹 Day 12: Use AND, OR & NOT for Multiple Conditions

Combine multiple conditions inside your IF formula. Check if a sale is BOTH above target AND in the right region!

🔹 Day 13: Nested Conditions with IFS Formula

Stop writing complicated nested IFs! Use IFS to handle many conditions cleanly in one formula.

🔹 Day 14: Master SUMIF & SUMIFS (Conditional Summing)

Sum numbers only when they match specific conditions — total sales for a specific branch or date range.

🔹 Day 15: Count with COUNTIF & COUNTIFS

Count how many cells meet your conditions — how many students passed, how many products are below stock limit?

🔵 Phase 4: Lookup & Search Functions (Days 16 – 20)

🔹 Day 16: Rank Data with RANK Formula

Rank student exam scores or sales performance from highest to lowest without sorting data manually.

🔹 Day 17: Auto Highlight Data with Conditional Formatting

Learn how to highlight duplicate values, high sales, or entire rows dynamically based on cell values.

🔹 Day 18: Master VLOOKUP & HLOOKUP

Search for data across tables effortlessly! Learn the classic VLOOKUP for vertical tables and HLOOKUP for horizontal ones.

🔹 Day 19: Upgrade to XLOOKUP (Modern Lookup)

Replace VLOOKUP with the powerful modern XLOOKUP — search left or right, return multiple columns, and handle errors automatically!

🔹 Day 20: Master INDEX & MATCH (The Ultimate Lookup Combo)

Overcome VLOOKUP limitations! Look up values to the left, create flexible dynamic lookups, and combine with other formulas.

🟣 Phase 5: Rounding, Math & Number Formatting (Days 21 – 24)

🔹 Day 21: Round Numbers (ROUND, ROUNDUP, ROUNDDOWN)

Stop showing too many decimal places! Use ROUND, ROUNDUP, and ROUNDDOWN to format numbers exactly the way you want.

🔹 Day 22: Use CEILING & FLOOR for Smart Rounding

Round UP to nearest 5, 10, or any multiple — perfect for pricing tables and scheduling!

🔹 Day 23: Master MOD, QUOTIENT, POWER & SQRT

Do advanced math in Excel — find remainder, integer division, power, and square root using built-in functions.

🔹 Day 24: Format Numbers as Text with TEXT & DOLLAR

Display numbers the way YOU want — show currency symbols, leading zeros, or date formats inside a formula.

🔴 Phase 6: Financial & Date Calculations (Days 25 – 27)

🔹 Day 25: Calculate Loan Payments with PMT, IPMT & PPMT

Calculate monthly loan payments, see how much goes to interest, and how much reduces your loan balance each month.

🔹 Day 26: Learn PV, FV & NPER (Investment Planning)

Plan your savings! Calculate how much money you need today to reach a future goal, or how long it takes to save a target amount.

🔹 Day 27: Work with Working Days (NETWORKDAYS & WORKDAY)

Calculate how many working days between two dates, or find the exact date that is N working days from today — skip weekends automatically!

🌟 Phase 7: Dynamic Arrays & Modern Excel (Days 28 – 30)

🔹 Day 28: Extract Unique Values with UNIQUE & Filter with FILTER

Stop removing duplicates manually! UNIQUE gives you a clean list instantly. FILTER extracts only rows that match your conditions.

🔹 Day 29: Sort & Sequence Data Automatically (SORT & SEQUENCE)

Auto-sort a list without touching data, or generate number sequences like 1, 2, 3... or dates for an entire month in seconds!

🔹 Day 30: Master SUMPRODUCT (The Swiss Army Knife Formula)

The most powerful formula in Excel! Multiply, sum, count with conditions — all in one formula without helper columns.

Advertisement

💡 Pro Tips to Finish This 30-Day Challenge

  1. Practice 20 Minutes Every Day: Don't rush all 30 days in one weekend! Practice 1 topic every day for 20 minutes so you remember formulas naturally.
  2. Download Practice Files: Open practice files alongside every lesson so you can type formulas yourself — not just watch!
  3. Use Shortcuts Daily: Practice pressing Ctrl + C, Ctrl + V, Ctrl + Z, and F4 (Absolute Reference) until your fingers do it automatically.
  4. Bookmark This Page: Save this guide to your browser bookmarks so you can return every day to check off your progress!
  5. Repeat Before Moving Forward: If a formula feels confusing, spend one extra day on it. There is no shame — mastery takes repetition!

📚 Related Collections & Downloads

Found this tutorial helpful? Share it with colleagues:
Share on X (Twitter)Share on LinkedInShare on FacebookShare on TelegramShare on Reddit
📚

Related Tutorials

Opens in new tab ↗
Advertisement