EXCEL MODELING COURSE
Introducing...
105多个课程，10多个练习，5小时的视频课程
To Help you Thrive in the Most Prestigious Jobs on Wall Street...
EXCEL MODELING COURSE PREVIEW
Excel格式（8个视频课，1个练习）
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.
Excel建模课程摘要目录
Below you will find a list of the modules and lessons included in this course.
- Introduction and Course Overview (5Min)
- 课程的流动（1分钟）
- Setup For Mac Users (5Min)
- 熟悉Excel（2分钟）
- Introduction (1Min)
- Excel快捷方式（4分钟）
- Worksheet Navigation and Selection (5Min)
- Excel Ribbon，Hotkeys和Formula Bar（5分钟）
- Excel Worksheets, View/Zoom, and Navigating Menus (5Min)
- Excel Review (1Min)
- Excel导航练习[下载]
- Navigation Exercise: Answer (4Min)
- Introduction
- Excel Windows Shortcuts
- Excel熟悉的快捷方式
- Ctrl vs. Alt
- Excel评论
- 右后
- Excel糊特别
- Excel Rows and Columns
- 分组和隐藏
- Excel普通热键
- 办公室热键
- Quick Access Toolbar
- Review
- Excel效率基础练习
- 效率基础练习：答案
- Introduction
- Excel Formatting Best Practices
- Excel Default Formats
- Excel Custom Number Formatting
- 其他格式提示
- Excel Conditional Formatting
- Review
- Excel Formatting Exercise
- 格式练习：答案
- Introduction (1Min)
- Excel Show and Zoom (4Min)
- Excel Freeze Panes (6Min)
- Split Panes and New Window (4Min)
- Excel Print and Page Layout (7Min)
- 评论（1分钟）
- Excel View & Print Exercise
- 查看与打印练习：答案（3分钟）
- Introduction (1Min)
- Excel Formulas (4Min)
- Excel错误（5分钟）
- Excel基本数学功能（8分钟）
- Excel Advanced Math Functions (10Min)
- Excel锚定（7分钟）
- 更多数学功能（2分钟）
- 评论（1分钟）
- Excel数学功能练习
- 数学功能练习：答案（4分钟）
- Introduction (1Min)
- Dates in Excel (4Min)
- Useful Date Functions (5Min)
- Excel Time Calculations (2Min)
- & and TEXT (6Min)
- Excel动态文本示例（5分钟）
- 评论（1分钟）
- Date & Text Functions Exercise
- Date & Text Functions Exercise: Answer (5Min)
- Introduction (2Min)
- excel if if and嵌套（4分钟）
- Excel AND, OR, and XOR (7Min)
- Excel比较操作员（1分钟）
- IFERROR in Excel (3Min)
- Excel Information Functions (1Min)
- PROPER, LOWER, and UPPER (2Min)
- LEFT, RIGHT, and MID (2Min)
- Text to Columns (3Min)
- Excel替代（1分钟）
- Excel搜索（3分钟）
- 评论（1分钟）
- Logic & Data Functions Exercise
- 逻辑和数据功能练习：答案（6分钟）
- Introduction (1Min)
- Excel VLOOKUP & HLOOKUP (4Min)
- Excel INDEX + MATCH (4Min)
- VLOOKUP vs INDEX + MATCH (6Min)
- Excel Data Validation (4Min)
- Excel Financial Functions Master (7Min)
- 评论（1分钟）
- 查找和财务功能练习
- 查找和财务功能练习: Answer (4Min)
- Introduction (1Min)
- Excel方案（6分钟）
- Excel Data Tables (6Min)
- Excel Naming Cells (6Min)
- Excel Formula Auditing (4Min)
- 评论（1分钟）
- 方案，数据表和审核练习
- 方案，数据表和审核练习: Answer (3Min)
- Introduction (1Min)
- Excel数据概述（2分钟）
- Excel排序（5分钟）
- Excel Filtering (5Min)
- Excel Pivot Tables (12Min)
- 评论（1分钟）
- 排序，过滤和透视表练习
- 排序，过滤和透视表练习: Answer (4Min)
- Introduction (1Min)
- Inserting and Adjusting Charts in Excel (3Min)
- Excel Select Data and Combo Charts (4Min)
- Other Chart Elements (2Min)
- Data Labels (2Min)
- 趋势线和回归（4分钟）
- 评论（1分钟）
- Excel Charts Exercise
- Excel图表练习：答案（3分钟）
- Introduction (1Min)
- Inserting and Adjusting Charts (3Min)
- 选择数据和组合图（4分钟）
- Other Chart Elements (2Min)
- Data Labels (2Min)
- 趋势线和回归（4分钟）
- 评论（1分钟）
- Excel Charts Exercise
- Excel Charts Exercise: Answer (3Mi
- 顶峰分配
- Challenge #1 (8Min)
- Challenge #2 (6Min)
- Challenge #3 (9Min)
- Course Outro (1Min)
学生评论
“伙计们,这门课是可怕的,因为它使Excel fun (or at least much less painful). Even though in my internship they rarely let us touch the models, I definitely thinkthis course helped me impress the analyst I was working with most of the summer and helped me secure a full-time offer。when he asked me to organize some data in Excel for a buyer universe, I think he was pleasantly surprised that I turned it around in under 2 hours and had it beautifully formatted with some bells and whistles. you guys rock, thank you! oh, and yes, you can use this as a testimonial! ..."
“我之前又参加了另一个Excel课程，但是自从我试图闯入投资银行业务以来，这与我更加相关万博app网页版when I took it. I love that you can download the lessons for offline viewing on my commute...thanks for putting this together WSO!"
“我以这门课程为尝试更快的速度，我不得不说it has made a big difference。Not that I'm the traditional student since I'm a bit more senior role at a consulting practice, but it was still really helpful for me and made me more confident when reviewing work from clients and my team. I don't think I need the other financial modeling courses since I'm happy with my role, but you never know. Thanks WSO, keep it up!"
“这个高级Excel建模课程是顶级的,在所有方面。教练扎克（Zach）不仅与他的讲话，而且与屏幕上的视觉效果进行了非常清楚的交流，以帮助记住捷径和热键。该课程采取了我曾经认为的任务很难且非常复杂，并且使它们在简单，易于管理的作品中可以理解。许多其他课程只会告诉您该怎么做，最后可能要完成任务。该WSO建模课程从字面上迫使您在每个模块末尾完成的自我训练使您的大脑学习，如果您错过了任何内容，则会通过清晰的解决方案视频进行学习。
It's fun (the monkey and banana points are hilarious),very well-organized and has relevant examples while troubleshooting common errors, and it's very easy to pick up and put down since the micro-lessons are usually only a few minutes each. I'm a senior manager at a Big 4 accounting firm, and was looking to sharpen my skills to keep up with all of the junior staff who come out of school and MBA programs with strong excel skills. I'm confident, after this, that not only will I be able to keep up but be more efficient and likely teach them a few tricks and shortcuts to save time as well.
Would recommend it to anyone looking for anyone looking to通过Excel提高效率，甚至只是那些只是在寻找刷新的人。保证将一些学习带回您的工作和客户。”
“我以为我以前是一个excel，但是now I know我是因为我能够快速进行练习...但是确实需要一些时间。有条件格式，枢轴表等的课程也与我在F500实习中所做的事情有关my boss definitely noticedmy skills when I didn't touch my mouse. I'm excited to try and land an IB internship next year."
“Shooting you a quick note because I just got my full-time offer and I wanted to say THANK YOU! I have to say theinstructors for these courses are super talented(especially Zach). From Excel to financial statements to Valuation I was really able to go into my internship ready to go and more confident after taking the time to go through these. I didn't get through ALL of the lessons, but I did complete over 80% and got my rewards!"
“本课程是great tool for mastering excel, whether you need a refresher between internships or are looking to learn new functions and master the keyboard, the course offers a ton of bite-sized lessons that prepped me for my Summer Analyst role."
“I must say that you guys have done a great job. This is definitely better than the other Excel course out there, ranging from simple and clear instructions to the breadth of functions covered. I even managed to implement the shortcuts I learnt over the weekend at work today!
Also loved the animated monkey - helps makes things lighter and definitely makes the course more informal and fun :)"
“The personal tips and alerts on best practices are what differentiates this Excel training course from the other training courses I've had in person.A lot of these tips are shortcuts I often use at work on a daily basis,但是要么是由工作中的同事或我自己教的，而且参加这门课程会节省我很多时间in having to figure out best practices by myself at work. This course doesn't skip over anything, and I think it was especially important and helpful to dedicate full, comprehensive videos to educating people on lookups and data tables.I have definitely learned tips that will help me become more efficient in Excel, and I'd definitely recommend this course for everyone，尤其是学生招募的学生，希望学习如何使用Excel的稳固基础，或者需要在Excel上进行刷新的人。”
“I thought the course was a good program to teach Excel modeling. Any student who takes this course will walk away with better Excel skills."
“华尔街绿万博app足彩下载洲Excel建模课程是任何新的或潜在的金融专业人士，尤其是投资银行业的新专业人员的绝佳资源，万博app网页版providing a significant jump start for those early on in their careers.这是一门非常经过深思熟虑的课程，在教您最重要的Excel捷径，配方和格式的同时，使事情变得轻松愉快 - 所有这些都是crucial to making you faster, and ultimately better at your job。该课程设法涵盖了所有必要的主题（从打印功能到表格和Vlookup），而不会像其他课程一样浪费时间。居民猴子麦克斯（Monkey Max）通过提供出色的幽默来帮助保持轻松愉快的事物，这对于让任何人参与这样的在线课程至关重要。这些模块是巧妙的订购，视频由知识渊博的老师出色。该课程为您提供信息，并演示其功能（有机会测试自己的手），而无需不必要地进行操作。我绝对会向任何对金融感兴趣的学生推荐本课程（也广泛地）计划鼓励我大学投资俱乐部的所有新成员参加WSO Excel建模课程。简单的说，this course is a must for any incoming financial professional!“
“Overall I really enjoyed it and believeit taught be various skills which will be applicable and save me time on the job。它超越了我在大学参加的基于Excel的课程，并为我提供了投资银行需要的细节。万博app网页版本课程绝对值得完成，并期待将来做更多的华尔街绿洲课程！”万博app足彩下载
“华尔街绿万博app足彩下载洲Excel建模课程是初学者或经验丰富的Excel用户希望掌握技能的绝佳资源。该课程叙述，专业且易于遵循。它不仅向您展示了每笔资金的基础知识专业人士应该知道，它还为那些寻求IB，PE和其他高金融角色的人定制学习目标。为了巩固您的学习，该课程还包括每章结尾处的技能测试练习，以确保您完全掌握和理解材料。我强烈建议任何希望将他们的建模技能提升到一个新的水平的人。”
“I found it incredibly helpful and with this being the second excel course I have done, andit was by far a lot more comprehensive and a lot more enjoyable than my last course。Zack was great right from the start. It was really cool to have a personable, funny, and honest teacher. Right from the getgo he really made me excited for the course and throughout his anecdotes and honesty about what needs to be known in excel in the workplace was great. The content was great as well. I really liked how it was split up into sections and within each section, there were clear objectives on what we had to learn. Overall, this was a really great excel course, I felt challenged, but I also felt like it was easy and fun to learn. The WSO Advanced Excel Course真的让我有信心在今年夏天进入实习，并在Excel中奔跑。“
“总的来说，我真的很喜欢放在一起的东西。对我来说，这是课程的简洁性 - 每一堂课都是简单的，至关重要。”
“我认为课程很棒。Zach是一位出色的老师，在每个模块中都表现出色和解释内容。在此简短课程之后，我在Excel中感到更加强大，并且拥有所有的测验来继续练习。对于想要在Excel中更有效工作的任何人来说“。
“这些视频非常简洁，充满了幽默，易于遵循。对于那些为他们的工作或学校而出色的人，我会100％建议在参加这两个计划之前参加该计划。I thought that by practicing with the actual excel model at the end of each module that it further instilled the information much more effectively than other excel courses I have taken.
“我是very impressed with this course! What stands out to me the most is how much knowledge is packed in to such a small timeframe. Other courses with this level of detail are ~3-4 times as long.
It has a clean and professional layout and is easy to follow. The presenter is clearly quite knowledgeable and provides useful tips and insights throughout each lesson that are applicable in the workplace. The end-of-module exercises are simple and straight to the point and the accompanying answer videos are helpful and beat going back through each lesson to see where you went wrong.
I'm really happy that I've taken this course and do believe that,无论您是大学生/实习生还是入门级专业人员，您都可以从中获得一些价值。Unlike other courses online this is one you can do over the weekend and bring those new skills to work on Monday.
“很棒 - 非常有用的学习步伐，清晰的解释”
Get the Excel Modeling Course Certification
完成课程后，所有学生将获得WSO Excel建模课程认证。将此证书用作雇主的信号，表明您拥有技术Excel技能，可以立即为您的团队增加价值。
证明您已经在大学课程之外投入了工作，以使自己更加高效，并掌握在财务职业中取得成功的最关键计划。轻松分享LinkedIn和其他社交媒体网站，以突出您的技能并加强您作为候选人的个人资料。
这有多少价值
Excel建模课程提供？
这个在线Excel类包括： |
Value |
|---|---|
WSO Excel建模课程 110+ video lessons across 13 Modules taught by a top-bucket bulge bracket investment banker... |
$500 |
10 Interactive Exercises with Benchmarks Gain realistic practice drilling the concepts taught in the course with timed benchmarks so that you can ... |
$450 |
24个月的实际财务专业人士的无限精英支持 Have a technical question? Easily drop a comment into any lesson and get a response from a pro within 48hrs. |
$300 |
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 |
总价值 |
$1,370 |
以93％的折扣获得无限的终身访问WSO Excel建模课程
$1,370
$97
全额付款或每月支付37美元
Secure checkout
100% Unconditional Money-Back Guarantee
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.