Compare Classes & Certificates

Which course is right for you? This tool allows you to compare any class or certificate program in our catalogue with the important information you need to make the right decision.

Remove
Key Information
Advanced Excel for Financial Modeling
$350 6 Hours
Learn More
Download Syllabus
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: May 21, Tuesday, 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
Financing See our Leif 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

Yelp Facebook LinkedIn YouTube Twitter Instagram