Key Information
Advanced Excel for Financial Modeling
$350 7 Hours
Overview
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.
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.
Location
185 Madison Avenue, NYC or Live Online
Schedule
Next start date: January 10, Monday, 10–5pm
Other scheduling options Weekdays only
View full schedule
Certification
Free Retake Within 1 Year See our class policies for more details
Workbook Included
12-Month Financing See our Climb Credit FAQ for more details
Target Audience
Anyone
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

Add Class or Certificate to Compare