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 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.
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
The teaching method at Noble Desktop is perfect and the classes provide you with infinite knowledge that makes you eager to take everything they offer. I love Noble!
—Ivonne Ackerman
Experienced educators who are driven to help you succeed
Refresh the materials for free within one year
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 Noble Desktop, 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.
Our instructors are veterans of their field and experienced educators, driven to help you succeed.
Program Director & Instructor
School Director, Instructor, & Senior Course Developer
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 intermediate Excel functions like VLOOKUP and SUMIFs, and how to summarize data with Pivot Tables, Sort & Filter databases, and split and join text. Gain the skills needed to utilize complex Excel functions and prepare for more advanced training.
Learn advanced Excel functions, macros, and data analysis to improve efficiency and manage complex data in any job setting. This advanced course is ideal for Excel power-users.
Become proficient in Microsoft Excel and go from beginner to pro with our hands-on Excel Bootcamp. Learn functions, formulas, Pivot Tables, macros, and time-saving techniques to conquer all the key skills needed to excel in Excel.
Join our financial modeling class to learn essential finance and accounting concepts, build a discounted cash flow (DCF) model in Excel, acquire advanced Excel skills, explore corporate finance and valuation, and create a financial model on a real company. This hands-on course will teach you practical financial skills.
Master Excel, review corporate finance, and build a valuation model on a public company. Gain basic and intermediate Excel skills and learn how to read financial statements, build valuations, and predict market trends.
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.
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 |
See the Installment plan FAQ for more information.
Program Director & Instructor
Mourad Kattan is an instructor and Program Director for Business, Finance, & Excel at Noble Desktop, teaching classes and designing courses in Excel, finance, accounting, and financial modeling.
Before Noble Desktop, Mourad worked as a financial analyst at Credit Suisse and H/2 Capital Partners. In those positions, he used advanced analytical and financial skills to evaluate a variety of investments.
Mourad graduated from the University of Pennsylvania summa cum laude and is part of the Beta Gamma Sigma honor's society.
School Director, Instructor, & Senior Course Developer
Dan Rodney has been a designer and web developer for over 20 years. He creates coursework for Noble Desktop and teaches classes. Dan also writes scripts for InDesign (Make Book Jacket, Proper Fraction Pro, and more) in his spare time. Dan teaches just about anything web, video, coding, or print-related (and more): HTML, CSS, JavaScript, Figma, Sketch, After Effects, Premiere Pro, Photoshop, Illustrator, InDesign, SQL, Power BI, Data Visualization, Project Management, and more. You can find Dan on X (Twitter), LinkedIn, Facebook, and at danrodney.com.