Excel Formulas & Functions
intermediate
Verified Certificate Included
Executive Excel & Financial Modeling Masterclass
From modern dynamic array formulas to valuation models used by top-tier consulting and finance teams.
Taught by om ankitbhai faldu
24.50 Hours Content
5 Lessons
English (Subtitle transcripts available)
Course Overview & Learning Outcomes
Master dynamic arrays (FILTER, UNIQUE, SORTBY, XLOOKUP), advanced scenario modeling, DCF valuations, and executive board-ready data presentation.
Course Curriculum
2 modules • 5 lessons • 24.50 hours-
Deep Dive into FILTER, SORT, and UNIQUEvideo • 15:00 mins
-
Mastering Two-Way Lookups with XLOOKUPdocumentLocked
-
Module 1 Knowledge CheckquizLocked
-
Linking 3-Statement Models Dynamicallyvideo • 20:00 minsLocked
-
Capstone: Build a 3-Statement Valuation ModelassignmentLocked
Your Instructor
om ankitbhai faldu
Senior Lead Consultant at Expolio Group
Enterprise practitioner specializing in complex spreadsheet systems, financial automation, and Power BI dashboards for Fortune 500 organizations.
₹4,999
₹9,999
Save 50%
Includes lifetime access & future syllabus updates
This Masterclass Includes:
- 24.50 hours of on-demand HD video
- 5 step-by-step modular lessons
- Authentic downloadable exercise workbooks
- Interactive quizzes & graded capstone
- Access on mobile, tablet, and desktop
- Verified Certificate of Completion
30-Day Money-Back Guarantee