You are here

Advanced Excel for Finance

Advanced Excel for Finance


NYIM Training
185 Madison Ave
11th Fl
New York, NY 10016
Register for Course
Monday, June 24, 2019 - 6:00am


Advanced Excel for Finance Class Overview Advanced Excel for Finance is a unique course covers Excel techniques commonly used by finance professionals, including investment banking, private equity, hedge funds, real estate, and asset management. Learn financial functions for NPV, IRR, Yields, Payments and more Master Excel shortcuts to speed up workflow, including navigation, formula writing, and working without the mouse Conquer advanced functions: Nested functions, VLOOKUP-MATCH, INDEX-MATCH Get started with Cash Flow Modeling in Excel Excel proficiency equivalent to Intermediate Excel for Business is required. Advanced Excel for Finance Course Syllabus Financial Functions Net Present Value Internal Rate of Return Mortgage Payments Bond Yield Advanced Techniques to Expedite Workflow Advanced Cell Locking Hot Keys Windows Cell Auditing Special Formatting Date functions Conditional Formatting-Formulas Advanced Functions Nested IF statements IF statements with AND/OR Advanced Analytical Tools Goal Seek Data Tables Conditional SumProduct Pivot Table-Calculations Pivot Charts Advanced Database Functions MATCH function VLOOKUP-MATCH INDEX-MATCH INDEX-Double MATCH Introduction to Macros Recording Macros Relative Macros Project I: Cash Flow Modeling Projecting Cash Flows Advanced Modeling Techniques Project II: Loan Amortization Model PMT Function Loan Table Advanced SUMIFs Note: Students will receive a Certificate of Completion at the end of this course and may retake the same course for free.

Register for Course