Looking for corporate training?
We offer custom onsite training and discounted class firstname.lastname@example.org
We are open! Classes are running in-person (socially distanced) and live online. Secure your seat today
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.
Learn with real-world projects
Step-by-step instruction to boost retention
Gain industry knowledge from professionals
Retake the course for free within one year
Learn the concepts and skills covered in this course or your tuition is on us. See details and terms & conditions.
The Career Centers instructors are highly skilled communicators who really know their craft. They are wonderful about explaining and re-explaining when necessary and I never felt rushed or foolish for asking a question.
Upon completion of this course, you’ll recieve an official certificate testifying to your mastery of the curriculum. We’ll send you a link where you can download your certificate, share it online with your friends, post it to your professional network on LinkedIn, and view all your earned certificates. Congratulations on your achievement!
185 Madison Avenue, NYC
In-person training happens at our campus in NYC where you’ll get face-to-face interaction with instructors and direct collaboration with other students. Courses are hands-on with all the necessary computers and software provided to you in class.
Live online training happens through Zoom during the same time as the in-person class and gets you the same interactivity and access to the instructor as in-person students. There are no extra fees and we’ll work with you to ensure your remote setup is perfect.
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.
Select up to two courses and tap Compare Courses to view a side-by-side comparison of Advanced Excel for Financial Modeling with your selected courses.
Become an expert Excel user with this Advanced Excel course. Learn powerful functions like INDEX-MATCH, work with advanced Pivot Table functions, and start recording macros to automate workflows. Prepare yourself for any Excel challenge with this advanced Excel course.More details
Go from novice to expert in our three-day comprehensive Excel Bootcamp. You’ll learn advanced database functions, calculations, and formulas, shortcuts, Pivot Tables and scripts, and macros for automating tasks with ease.More details
Take your Excel skills up a level with this Intermediate Excel course. Learn important Excel functions like VLOOKUP, SUMIFs, and Pivot Tables in this hands-on training. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation.More details
Build a financial model and learn corporate finance and accounting principles. By the end of this course, you'll have a comprehensive Discounted Cash Flow (DCF) model to add to your portfolio. You'll have a fundamental knowledge of corporate finance and accounting concepts. Finally, your advanced Microsoft Excel skills will aid you in building financial models quickly and accurately.More details
Master advanced Excel, corporate finance, and corporate valuation in this intensive five-day bootcamp. You’ll learn the terms and vocabulary used within the industry to prepare you for interviews and have a valuation model to present from your portfolio. After this course, you’ll be prepared to work as a financial analyst.More details