Looking for corporate training?
We offer custom onsite training and discounted class firstname.lastname@example.org
212 • 684 • 5151
We provide computers to use during class. This course is available on PC only.
Students may retake the course once within six months if there is an available seat.
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.
This course does not require or cover corporate valuation or financial accounting concepts. The goal of this course is to master Excel's features. For in-depth analysis on financial modeling concepts as well as building comprehensive financial models on real-world companies, see our Financial Modeling Bootcamp.
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.
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.
Excel Classes: Excel is perhaps the top skill required for finance professionals today. At NYC Career Centers, you can get started with the basics or learn comprehensively in the Excel for Business Bootcamp.
Financial Modeling Bootcamp: Learn Excel, finance, accounting, and corporate valuations skills in our Financial Modeling Bootcamp in New York City. The first day of the course is this Advanced Excel for Finance training. On day two, you will learn finance principles including enterprise value, comparable companies analysis, corporate valuation principles, and financial accounting concepts. On the last day, you will build a comprehensive valuation model on a publicly-traded restaurant company using real financial data. You will research the company to determine the model drivers, and derive a value per share using a DCF model.
Corporate Finance: In our corporate finance training, you will learn the core finance concepts every finance professional should know, including stocks, bonds, options, NPV, IRR, M&A, LBO transactions, DCF modeling, and more.
Financial Accounting: In our Financial Accounting courses, you will learn to analyze financial statements, including the income statement, balance sheet, cash flow statement, and financial statement footnotes. We'll cover the basics of dual entry accounting and other accounting principles.
You can attend this training live online at the scheduled time the course is offered (New York, Eastern Time) through screen-sharing software Zoom (free for you).