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.
