Master the advanced Excel tricks, techniques, and tools financial analysts use to build and audit financial models. By the end of this course, you will know how to write efficient and flexible formulas, create sensitivity analysis, and master Excel's features for finance.

  • Get started with cash flow modeling and projections in Excel
  • Master Excel shortcuts and techniques for financial modeling, including navigation, formula writing, and working without the mouse
  • Audit financial models and write efficient, flexible formulas
  • Learn advanced analytical tools for sensitivity analysis
  • Learn financial functions for NPV, IRR, Bond Yields, & Mortgage Payments
  • Conquer advanced functions financial analysts need: Nested functions, VLOOKUP-MATCH, INDEX-MATCH

Related Courses

This course is included as the first day of our Financial Modeling Bootcamp. In our Bootcamp, you will build a valuation model on a public company while learning how to analyze its financial statements and create meaningful projections. The Bootcamp reviews financial accounting, corporate finance, and corporate valuation concepts, and includes smaller projects in LBO modeling and integrated 3-statement modeling. 

Learn Advanced Excel & Financial Modeling: Take this course with our or Financial Analyst Training Program to achieve the skills you need to become a top financial analyst.

warning-standard-solid This course has a prerequisite

Prior financial experience is helpful, but not required. 

Excel proficiency equivalent to Intermediate Excel for Business is required, including VLOOKUP, Pivot Tables, and IF statements.

What You'll Learn

  • Financial functions: NPV, IRR, XNPV, and XIRR
  • Advanced database functions: VLOOKUP-MATCH, & INDEX-MATCH
  • Create Data Tables to show outputs based on various scenarios
  • Use Goal Seek's powerful calculation tools
  • Create financial projections based on historical data
  • Learn Hot Keys to work in Excel without the mouse
  • Master Excel with a variety of shortcuts finance professionals need