15-Day Excel Learning Course
A complete step-by-step workbook to master Excel, formulas, and data
analysis in 15 days.
📘 Introduction
Welcome to the 15-Day Excel Learning Course! This guide will take you from beginner to
advanced Excel skills in just 15 days. It includes 50+ essential formulas, process guides,
practice exercises, and a final project.
📅 Day 1
Introduction to Excel Interface: Ribbon, Tabs, Quick Access Toolbar, Worksheets, and Cells.
Practice: Open Excel and explore menus, save a workbook, and enter sample data.
📅 Day 2
Basic Formatting: Bold, Italics, Underline, Borders, Cell Colors, Merge & Center.
Practice: Create a student marks table and format it.
📅 Day 3
Basic Formulas: SUM, AVERAGE, MIN, MAX, COUNT.
Example: =SUM(A1:A5) adds values from A1 to A5.
Practice: Calculate total and average marks for students.
📅 Day 4
Text Functions: LEFT, RIGHT, MID, LEN, TRIM, PROPER, CONCATENATE.
Practice: Clean a messy name list and standardize text.
📅 Day 5
Date & Time Functions: TODAY, NOW, YEAR, MONTH, DAY, WEEKDAY.
Practice: Extract year, month, and weekday from a list of dates.
📅 Day 6
Logical Functions: IF, AND, OR, NOT, IFS.
Practice: Create a grading system using IF formula.
📅 Day 7
Lookup Functions: VLOOKUP, HLOOKUP, INDEX, MATCH.
Practice: Search student marks using VLOOKUP.
📅 Day 8
Advanced Lookup: XLOOKUP, XMATCH, FILTER, SORT, UNIQUE.
Practice: Find top 3 scores using SORT + FILTER.
📅 Day 9
Math Functions: ROUND, ROUNDUP, ROUNDDOWN, CEILING, FLOOR, MOD, POWER, SQRT.
Practice: Apply rounding to sales figures.
📅 Day 10
Statistical Functions: STDEV, VAR, CORREL, MEDIAN, MODE.
Practice: Analyze student performance variance.
📅 Day 11
Conditional Formatting & Data Validation.
Practice: Highlight students scoring < 40.
📅 Day 12
Pivot Tables & Pivot Charts.
Practice: Summarize sales by region and product.
📅 Day 13
Charts & Visualizations: Column, Line, Pie, Combo.
Practice: Create a sales dashboard chart.
📅 Day 14
Excel Data Tools: Remove Duplicates, Text-to-Columns, Flash Fill, What-If Analysis.
Practice: Clean and split a dataset.
📅 Day 15
Intro to Macros & VBA.
Practice: Record a macro to automate formatting.
📊 50+ Essential Excel Formulas
SUM
Description: Adds numbers
Example: =SUM(A1:A5) → 150
AVERAGE
Description: Returns mean value
Example: =AVERAGE(A1:A5) → 30
IF
Description: Checks condition
Example: =IF(A1>50,'Pass','Fail')
VLOOKUP
Description: Searches value in table
Example: =VLOOKUP(101, A2:D20, 3, FALSE)
INDEX
Description: Returns value at row/column
Example: =INDEX(A2:C10, 2, 3)
MATCH
Description: Finds position of value
Example: =MATCH(50, A1:A10, 0)
ROUND
Description: Rounds number
Example: =ROUND(12.3456,2) → 12.35
TEXT
Description: Formats number/text
Example: =TEXT(TODAY(),"DD-MMM-YYYY")
CONCAT
Description: Joins text
Example: =CONCAT(A1, " ", B1)
LEN
Description: Length of text
Example: =LEN(A1)
TRIM
Description: Removes spaces
Example: =TRIM(A1)
PROPER
Description: Capitalizes text
Example: =PROPER("hello world") → Hello World
SEARCH
Description: Finds substring position
Example: =SEARCH("cat","education") → 5
REPLACE
Description: Replaces text part
Example: =REPLACE("Hello",2,3,"i") → Hio
NOW
Description: Current date/time
Example: =NOW()
TODAY
Description: Current date
Example: =TODAY()
EOMONTH
Description: End of month date
Example: =EOMONTH(TODAY(),1)
PMT
Description: Loan payment
Example: =PMT(10%/12,60,100000)
NPV
Description: Net Present Value
Example: =NPV(10%,A1:A5)
IRR
Description: Internal Rate of Return
Example: =IRR(A1:A5)
UNIQUE
Description: Unique values
Example: =UNIQUE(A1:A20)
SORT
Description: Sorts data
Example: =SORT(A1:B20,2,TRUE)
FILTER
Description: Filters data
Example: =FILTER(A2:C10,B2:B10>50)
SEQUENCE
Description: Generates numbers
Example: =SEQUENCE(5,1,1,1)
SUBTOTAL
Description: Returns subtotal
Example: =SUBTOTAL(9,A1:A10)
CLEAN
Description: Removes non-print chars
Example: =CLEAN(A1)
EXACT
Description: Checks text match
Example: =EXACT(A1,B1)
HOUR
Description: Extracts hour
Example: =HOUR(NOW())
MINUTE
Description: Extracts minute
Example: =MINUTE(NOW())
SECOND
Description: Extracts second
Example: =SECOND(NOW())
WEEKDAY
Description: Day of week
Example: =WEEKDAY(TODAY())
WEEKNUM
Description: Week number
Example: =WEEKNUM(TODAY())
OFFSET
Description: Returns shifted range
Example: =OFFSET(A1,1,1,3,1)
CHOOSE
Description: Selects from list
Example: =CHOOSE(2,"Red","Blue","Green")
SWITCH
Description: Returns based on case
Example: =SWITCH(A1,1,"One",2,"Two","Other")
XOR
Description: Exclusive OR
Example: =XOR(TRUE,FALSE)
IFERROR
Description: Handles errors
Example: =IFERROR(1/0,"Error")
VALUE
Description: Converts text to number
Example: =VALUE("123")
REPT
Description: Repeats text
Example: =REPT("*",5) → *****
CHAR
Description: Returns character
Example: =CHAR(65) → A
SQRT
Description: Square root
Example: =SQRT(25) → 5
POWER
Description: Exponent
Example: =POWER(2,3) → 8
MOD
Description: Remainder
Example: =MOD(10,3) → 1
ROUNDUP
Description: Always rounds up
Example: =ROUNDUP(12.34,1) → 12.4
ROUNDDOWN
Description: Always rounds down
Example: =ROUNDDOWN(12.34,1) → 12.3
CEILING
Description: Rounds up to multiple
Example: =CEILING(15,5) → 20
FLOOR
Description: Rounds down to multiple
Example: =FLOOR(15,5) → 15
