To Help you Thrive in the Most Prestigious Jobs on Wall Street...




In this module, we use8 video lessonsto expand upon the best practices in previous modules to learn conditional formatting and custom number formatting (among other topics). This module also includes an用积极的基准测试and a video solution to make sure you keep practicing until you are very productive...

Excel Math Functions (9 video lessons, 1 exercise)

In this module, we use9 video lessons为了解释锚定以及基本和高级数学功能,这些功能将经常出现在工作中。该模块还包括一个带有视频解决方案的练习,因此您可以看到实际投资银行家使用这些in the real world…

Excel Logic & Data Functions (13 video lessons, 1 exercise)

In this module, we use13 video lessonsto dive into some of the more complex and foundational functions used throughout financial modeling. This includes IF and Nested IF statements, ISERROR, Information Functions and more. We wrap up this module with anotherchallenging exercise

Excel Lookup and Financial Functions (8 video lessons, 1 exercise)

In this module, we use8 video lessonsto explore vlookup, hlookup, data validation as well as index and match and when it is best to use each in the context of financial modeling. We wrap up this module with anotherchallenging exercise that tests your retention and speed

Excel Scenarios, Data Tables and Auditing (7 video lessons, 1 exercise)

In this module, we use7个视频课程to explore data tables, naming cells, formula auditing and Scenarios so that you can take your Excel modeling to another level. This module also includes anothertimed benchmarking exercise

Excel Sorting, Filtering and Pivot Tables (7 video lessons, 1 exercise)

In this module, we use7个视频课程to explore sorting, filtering and pivot tables which are used extensively when trying to analyze the various outcomes and input sensitivities in financial models. Learn through doing with anothertimed benchmarking exercise

Excel Navigation (7 video lessons, 1 exercise)

In this module, we use7个视频课程在浏览Excel时解释最佳实践。这包括一个用积极的基准测试还有一个视频解决方案,以确保您在真正掌握之前不会继续前进。

Excel Efficiency Foundation (14 video lessons, 1 exercise)

In this module, we use14 video lessonsto explain best practices on how to gain maximum efficiency when navigating Excel (and Windows) for finance careers. This includes an用积极的基准测试以及一个视频解决方案,以确保您养成财务建模的良好习惯

Our students have landed and thrived at positions across all top Wall Street firms, including:

WSO Excel建模课程Video Preview

Below you will find some video previews of specific lessons in our Excel Modeling Course. This is to give you a sense of the teaching style of the instructor and covers some of our more basic Excel tips and tricks. All WSO courses include unlimited support from actual finance professionals who are on call to make sure you don't get stuck as you teach yourself how to become an Excel modeling wizard. This course is focused primarily on productivity and building the right habits (like quick keys, anchoring, etc) so that you learn how to play the instrument (Excel) therightway the first time around.

Grid items
Excel shortcuts
Exercise: SumIfs, Anchoring and More


Below you will find a list of the modules and lessons included in this course.

Get the Excel Modeling Course Certification

完成课程后,所有学生将获得WSO Excel建模课程认证。将此证书用作雇主的信号,表明您拥有技术Excel技能,可以立即为您的团队增加价值。





WSO Excel建模课程

110+ video lessons across 13 Modules taught by a top-bucket bulge bracket investment banker...


10 Interactive Exercises with Benchmarks

Gain realistic practice drilling the concepts taught in the course with timed benchmarks so that you can ...



Have a technical question? Easily drop a comment into any lesson and get a response from a pro within 48hrs.


6 Months of FREE Access to Macabacus

Full access to this Excel plug-in that makes financial modeling even easier, including tools for PowerPoint and Word.

$ 120




以93%的折扣获得无限的终身访问WSO Excel建模课程




Secure checkout
100% Unconditional Money-Back Guarantee

Credit Cards“>
                <div class=
                   <div class=

12 Month Risk-Free Guarantee

Your investment is protected by our 12-Month Risk-Free Guarantee. If, for any reason, you don't think the WSO Excel Modeling Course is right for you, just send us an email, and we'll refund every penny. No questions asked.简而言之,您将获得丰厚的投资回报,或者收回您的资金。It's that simple.