15 Days to Get Better with Microsoft Excel (Step-by-Step Learning Guide)

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

Follow 1 lesson every day from simple basic calculation to advanced lookup formulas. In just 15 days, you will build strong confidence and finish your Excel work much faster!

15 days to get better with excel guide

🗓️ The 15-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.

📖 Lesson: Introduction to Excel for Beginner (With Video) ↗

🔹 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.

📖 Lesson: How to Use SUM Function in Excel (With Video) ↗

🔹 Day 3: Learn AVERAGE, MIN & MAX Formulas

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

📖 Lesson: How to Use AVERAGE Function in Excel ↗
📖 Lesson: How to Use MIN & MAX Functions in Excel ↗

🔹 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.

📖 Lesson: How to Use TODAY and NOW Functions ↗
📖 Lesson: How to Use DAY, MONTH, YEAR in Excel ↗

🔹 Day 5: Review Top 15 Basic Excel Formulas for Beginners

Take time to review all fundamental formulas in one complete video tutorial with free practice file!

📖 Lesson: Top 15 Basic Excel Formulas for Beginners ↗

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

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

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

📖 Lesson: How to Change Text Case (UPPER, LOWER, PROPER) ↗

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

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

📖 Lesson: How to Connect Text Values in Excel (CONCAT, &) ↗

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

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

📖 Lesson: How to Use Text Cleaning Formulas in Excel ↗

🔹 Day 9: Master REPT & TEXTJOIN Formulas

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

📖 Lesson 1: How to Use REPT Formula in Excel ↗
📖 Lesson 2: How to Use TEXTJOIN Formula in Excel ↗

🟠 Phase 3: Logic, Conditional Math & Ranking (Days 10 – 12)

🔹 Day 10: Learn IF Formula (Logical Conditions)

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

📖 Lesson: How to Use IF Function in Excel ↗

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

Sum numbers only when they match specific conditions (example: total sales for specific branch or date range).

📖 Lesson: SUMIF vs SUMIFS in Excel (Single & Multiple Conditions) ↗

🔹 Day 12: Rank Data with RANK Formula

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

📖 Lesson: How to Use RANK Function in Excel ↗

🔴 Phase 4: Advanced Lookups & Data Highlighting (Days 13 – 15)

🔹 Day 13: Auto Highlight Data with Conditional Formatting

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

📖 Lesson: How to Highlight Data in Excel Step by Step ↗

🔹 Day 14: Master Lookup Formulas (VLOOKUP vs XLOOKUP)

Search for data across tables effortlessly! Learn traditional VLOOKUP and modern, powerful XLOOKUP.

📖 Lesson: VLOOKUP vs XLOOKUP in Excel: When to Use ↗

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

Overcome VLOOKUP limitations! Learn how to look up values to the left and create flexible, dynamic report lookups.

📖 Lesson: How to Use INDEX & MATCH Function in Excel ↗

💡 Pro Tips to Finish This 15-Day Challenge

Practice 20 Minutes Every Day: Don't rush all 15 days in 1 afternoon! Practice 1 formula every day for 20 minutes to remember syntax naturally.
Download Practice Files: Open practice files alongside video tutorials so you can type formulas yourself.
Use Shortcuts Daily: Practice pressing Ctrl + C, Ctrl + V, Ctrl + Z, and F4 (Absolute Reference) until your fingers do it automatically!
Bookmark This Page: Save this guide to your browser bookmarks so you can return every day to check off your progress!