What's the Master Excel Functions Course?
This is a course aimed at transforming the way you work with data. Whether you’re brand-new to Excel or looking to level up your skills, this beginner-friendly course will take you from “What’s a formula?” to “Watch me work Excel magic” in just a few hours.
This course is packed with 7+ hours of hands-on lessons designed to make Excel functions click for anyone. By the end, you’ll be able to crunch numbers with confidence using statistical and financial functions, , clean up messy data using handy text functions, tackle data like a pro with conditional and lookup functions.
"No more staring blankly at spreadsheets—you’ll know exactly what to do to make Excel work for you."
Course Highlights
- 7+ hours of easy-to-follow, bite-sized lessons you can complete at your own pace
- Examples and practice exercises to build your skills
- Lifetime access to course materials—revisit anytime!
- English Captions for all videos
- A Certificate of Completion to show off your new skills (hello, resume boost!)
-
Bonus Module on Excel Productivity Tools and guides for all functions (Access after 15 days)
Course Curriculum
- Quick Intro (1:47)
- Formulas Basics (For Complete Beginners) (4:27)
- Absolute and Relative Referencing (5:10)
- Sum and Product Function (4:16)
- Named Ranges (2:55)
- Average, Min and Max (4:47)
- Calculating Across Sheets (3:31)
- Calculating Across Workbooks - Intro to 3D Formulas (4:57)
- 3D Formulas - Options (3:42)
- Consolidate by Position (4:06)
- Consolidate by Category (4:46)
- Quick Intro (2:05)
- Combine Text (7:07)
- Change Case (3:40)
- Clean Text - Clean, Trim and Substitute (5:21)
- Split and Extract - Left, Mid and Right (5:09)
- Split and Extract - Len and Find (6:16)
- Extract Text - Office 365 (6:49)
- Split Text - Office 365 (5:45)
- Date Basics (6:02)
- Generate Dates (3:28)
- Calculate Days - Days, Networkdays, Workday (6:20)
- Calculate Deadlines - EDATE and EOMONTH (5:19)
- Quick Intro (1:44)
- VLookup - Approx Match (3:59)
- VLookup - Exact Match (4:27)
- HLookup Function (4:01)
- Index and Match Function (4:41)
- XLookUp - VLookUP + More (8:46)
- XLookUp - HLookup+Index Match (5:06)
- XLookUp - Everything Else (7:29)
- Unique Function (4:11)
- Filter Function (2:24)
- Sort and Sort by Function (6:09)
- Offset Function (12:12)
- Indirect Function (12:07)
- Quick Intro (2:06)
- Count Functions (3:29)
- Small, Large, Min, Max, and Average Functions (5:49)
- PV, FV and PMT Functions (5:47)
- NPER Function (1:31)
- Monthly Loan Payment (2:02)
- Loan Payment Schedule (8:56)
- Loan Payment Schedule - the easy way (4:40)
- NPV and XNPV Functions (4:31)
- IRR and XIRR Functions (4:03)
- MIRR Function (2:49)
Hi, I’m Shilpa
I am a 2X Microsoft MVP and the founder of Sheet Sensei, a destination for high-quality Excel tutorials.
In 2021, fueled by my passion for both Excel and teaching, I launched TikTok and Instagram channels to disseminate Excel tips.
I started Sheet Sensei with the goal of changing people's love hate relationship with Excel to one that helps them excel in their careers.
Today, I'm proud to have built a community of over 1.5 million Excel enthusiasts. Over the past few years, I've trained 1,000s of professionals and crafted specialized training modules for corporates, non-profits, and educational institutions.
