FM
Beginner
Financial Modeling Fundamentals
Build a three-statement model from scratch in Excel, with clean structure and checks.
View courseExcel for Finance Professionals
Master the formulas, shortcuts and tools analysts use every day in Microsoft Excel.
What you'll learn
- Core concepts explained with real US company examples
- Step-by-step Excel walkthroughs you can follow along with
- Best practices used by analysts at leading firms
- A final assessment to earn your certificate of completion
Course curriculum
Module 1: Keyboard shortcuts and efficient navigation45 min
Module 2: Lookup functions: XLOOKUP, INDEX/MATCH52 min
Module 3: Logical and date functions59 min
Module 4: PivotTables and data summaries66 min
Module 5: Charts for financial reporting73 min
Module 6: Data validation and auditing50 min
Who this course is for
Students, career changers and working professionals in finance, accounting, consulting and business who want practical, job-ready skills.
Requirements
A computer with Microsoft Excel (Microsoft 365 recommended). No prior experience is required for beginner courses.
Related courses
BV
Intermediate
Business Valuation: DCF, Comps & Precedents
Value a company using discounted cash flow, trading comparables and precedent transactions.
View course