Advanced Excel for Financial Modeling
Learn the tricks and techniques in Excel needed for financial analysts to build financial models, create sensitivity analyses, and more.
Learn the tricks and techniques in Excel needed for financial analysts to build financial models, create sensitivity analyses, and more.
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 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.
Learn Advanced Excel & Financial Modeling: Take this course with our or Financial Analyst Training Program to achieve the skills you need to become a top financial analyst.
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.
From our hands-on training style to world-class instructors and custom-crafted curriculum, we deliver results our alumni are proud of.
Advanced Excel for Financial Modeling is rated 5.0 stars
in the past 24 months
I had an amazing experience doing private training for Excel for Finance. I learned all the practical applications for the formulas I'm expected to know at my new job - I feel great and super confident at work with my new skills! Very patient and knowledgeable instructor too.
Max D.
I took a private Excel class at NYIM, and it was excellent. The trainer, Mourad, prepared a very good class outline that taught me many useful tools. During our time together, Mourad was patient and changed the direction as he determined what my greatest needs were. I will be taking more classes with NYIM and highly recommend them.
Kevin D.
This class was absolutely great. I've been in Finance for 5 years and learned things today!
John A.
Owl Ventures
As one of our smaller courses, tuition for this course is due in full before the start date. The best way to save on this course is to take it as part of a certificate program.
There are no extra fees or taxes for our courses. The price you see on this page is the maximum you’ll pay us.
However, if you plan to take the course live online, you may need to obtain required software. We’ll help you get set up with a free trial of paid software prior to the class. Most of our coding classes utilize freely-available open-source software. For most of our design and motion graphics courses, we will help you get set up with a free trial of Adobe Creative Cloud. If you attend the course in-person, we will have a computer already set up for you with all of the required software for no additional cost.
We don’t currently offer discounts as we do our best to affordably prices our courses.
Learn the concepts and skills covered in this course or your tuition is on us. See details and terms & conditions.
Work on projects proven to boost retention
Refined over many cohorts for an optimal learning experience
Excellent classes and excellent venue! It has just the right level of personal attention and class participation. I would highly recommend NYIM and look forward to taking future classes there. – Hazel S.
Experienced educators who are driven to help you succeed
Refresh the materials and gain additional practice
Attend this course in-person in NYC or Live Online via Zoom. Engage with expert instructors, ask questions, and get feedback on your exercises and projects.
Unlike other providers, these are not mass open-enrollment classes. At NYIM Training, you’ll learn in small groups (typically 8-15 students) and receive personalized attention.
Get face-to-face interaction with an instructor and other students when you learn at our NYC campus. Courses are hands-on with a computer and software provided.
Get 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.
Upon completion of this course, you’ll receive 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!
Shareable on
We offer a single free retake of the class within a year.
You can also access recordings of each session in your student portal within one business day of the session’s end. Recordings are available for one month after the session.
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.
This course does not qualify for payments plans or student financing. See our Payment Plan FAQ to find related programs that qualify.
You may attend this training virtually (online) at the scheduled time the course is offered (New York, Eastern Time).
You have some options:
Select up to two courses and tap Compare selected courses to view a side-by-side comparison of Advanced Excel for Financial Modeling with your selected courses.
Learn the skills you need to become a top financial analyst: advanced Excel, financial modeling, corporate finance, and accounting. Build a financial model to value a public company, and learn industry best practices from experienced investment bankers and analysts.
Become an advanced Microsoft Excel user in just three days. This Excel Bootcamp includes 18 hours of hands-on training in formulas, functions, Pivot Tables, macros & more.
Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow.
In this 5-day financial analyst program, you'll master Excel, review corporate finance and financial accounting concepts, and build a comprehensive valuation model on a public company.
Purchase group class vouchers at a discount for our regularly-scheduled group classes in NYC, or create a custom training program at your offices.
We’ve trained thousands of companies!
Let us create the perfect program for your team.
Excel Classes: Excel is perhaps the top skill required for finance professionals today. At NYIM, 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.
This policy was updated on August 14, 2018.
Your privacy is important to us. It is the policy of NYIM Training to respect your privacy regarding any information we may collect from you across our website, https://training-nyc.com, and other sites we own and operate.
We only ask for personal information when we truly need it to provide a service to you. We collect it by fair and lawful means, with your knowledge and consent. We also let you know why we’re collecting it and how it will be used.
We only retain collected information for as long as necessary to provide you with your requested service. What data we store, we’ll protect within commercially acceptable means to prevent loss and theft, as well as unauthorized access, disclosure, copying, use or modification.
We don’t share any personally identifying information publicly or with third-parties, except when required to by law.
Our website may link to external sites that are not operated by us. Please be aware that we have no control over the content and practices of these sites, and cannot accept responsibility or liability for their respective privacy policies.
You are free to refuse our request for your personal information, with the understanding that we may be unable to provide you with some of your desired services.
Your continued use of our website will be regarded as acceptance of our practices around privacy and personal information. If you have any questions about how we handle user data and personal information, feel free to contact us.
By accessing the website at https://training-nyc.com, you are agreeing to be bound by these terms of service, all applicable laws and regulations, and agree that you are responsible for compliance with any applicable local laws. If you do not agree with any of these terms, you are prohibited from using or accessing this site. The materials contained in this website are protected by applicable copyright and trademark law.
In no event shall NYIM Training or its suppliers be liable for any damages (including, without limitation, damages for loss of data or profit, or due to business interruption) arising out of the use or inability to use the materials on NYIM Training’s website, even if NYIM Training or a NYIM Training authorized representative has been notified orally or in writing of the possibility of such damage. Because some jurisdictions do not allow limitations on implied warranties, or limitations of liability for consequential or incidental damages, these limitations may not apply to you.
The materials appearing on NYIM Training’s website could include technical, typographical, or photographic errors. NYIM Training does not warrant that any of the materials on its website are accurate, complete or current. NYIM Training may make changes to the materials contained on its website at any time without notice. However, NYIM Training does not make any commitment to update the materials.
NYIM Training has not reviewed all of the sites linked to its website and is not responsible for the contents of any such linked site. The inclusion of any link does not imply endorsement by NYIM Training of the site. Use of any such linked website is at the user’s own risk.
NYIM Training may revise these terms of service for its website at any time without notice. By using this website you are agreeing to be bound by the then current version of these terms of service.
These terms and conditions are governed by and construed in accordance with the laws of New York and you irrevocably submit to the exclusive jurisdiction of the courts in that State or location.
The first installment is due one week before the first class. Subsequent installments are spread out evenly across the duration of the course.
Installments | |
---|---|
10% non-refundable deposit | |
$350.00 | Total You Pay |