Course Overview
13 Modules to Master Excel Modeling
Join this course to become an Excel Modeling Wizard and stand out among candidates for top finance positions. Get everything you need to excel and secure your dream job.
Who is this Course for?
Motivated college students looking to work in high finance.
Professionals looking to master Excel Modeling and prepare for the recruiting process
Key Outcomes
Master ALL Excel Concepts
By the end of the course, you will possess all the skills and knowledge necessary to be efficient at using Excel. This will make you a valuable member of your team right from day one.
Unlocking the Door to your Finance Career
Learning to navigate and leverage the power of Excel to its fullest potential is a foundational skill to any finance career that requires you to analyze and deal with numbers or datasets.
Boost Your Confidence and Earnings Potential
After you finish this course, you'll become an Excel expert. You'll feel confident about building financial models in Excel and ready for job interviews, which will increase your odds of earning a higher salary.
This course has helped our students and young professionals land and thrive at positions across all top Wall Street firms, including:
WHAT’S INCLUDED
A step-by-step course to help you master Excel Modeling
Module 1: Introduction
In this module, we introduce the course structure and the basics of Excel, allowing you to gain a clear understanding of what to expect as you progress through the material.
Module 2: Navigation
In this module, we teach you the shortcuts you need to use when navigating in Excel. You'll learn Excel shortcuts and navigation controls to move around effortlessly.
Module 3: Efficiency Foundation
This module explains how you can get maximum efficiency when working with Excel. You will learn the top shortcuts and practice them to take your Excel skills to the next level.
Module 4: Formatting
In this module, we teach you how to access and use the various formatting tools.
Module 5: View & Print
In this module, you will learn how to have split and freeze panes as well as other view options in Excel. This module also includes a View & Print Exercise.
Module 6: Math Functions
In this module, we teach you basic and advanced math functions that will come up frequently on the job, along with advanced concepts such as anchoring.
Module 7: Date & Text Functions
In this module, you'll learn to create dynamic text fields using date and text functions. This module also includes an exercise at the end with a video solution.
Module 8: Logic & Data Functions
In this module, we 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.
Module 9: Lookup & Financial Functions
In this module, we explore lookup functions such as VLOOKUP, HLOOKUP, and INDEX-MATCH and the reasons for using them in the context of financial modeling.
Module 10: Scenarios, Data Tables, & Auditing
In this module, we explore data tables, naming cells, formula auditing, and scenarios so that you can take your Excel modeling to another level. This module also includes a timed benchmarking exercise.
Module 11: Sorting, Filtering, & Pivot Tables
In this module, we explore sorting, filtering, and pivot tables which are used extensively when trying to analyze the various outcomes and input sensitivities in financial models.
Module 12: Excel Charts
In this module, we explore various charts, trendlines, and regression. This module also includes an exercise and a video walkthrough to make sure you don’t move on until you have true mastery.
Module 13: Capstone Assignment
This module includes capstone assignments with 3 different challenges that require you to put together the most critical concepts that you learned throughout the course.
Don’t Take Our Word For It
Hear From Our Students
Wall Street Oasis has trained over 63,000 students at elite corporate and educational institutions for over a decade.
I'm an Econ major student, so I've never been taught how to properly do a model, and WSO's modeling course not only prepped me for modeling but also taught me a lot of tips and tricks that have saved me so much time while building up models. Also, it helped me to ace all my technical interviews.
For those who thinking about getting this course, do it now! You won't regret!
I am not sure how it compares to other LBO courses in terms of value for money (if there are even other LBO online courses out there), but I do want to emphasize that it is an extremely dense course compared to most other online/MOOC courses so the price (probably) scales accordingly compared to standard online course prices from other services.
I've been hailed by my boss and colleagues at work, trident insurance co.ltd finance department,I used the knowledge also in PowerPoint and word ,these hotkeys apply almost in ppt,word and excel. I've been so efficient yet I'm still in campus.
A local leather turning firm also gave me a role in finance and accounting and it's been a lovely experience, I've actually recoup the money I paid wall street oasis for the course and in fact I got a massive discount, Patrick didn't sell it to me$497 dollars if I remember. The PowerPoint course could improved though,it only gives tricks but does not teach one how to actually create a full presentation or pitchbook. I'm sorry that I have to write my review away from home, I saw the email from Patrick and had planned to do this at home unfortunately my schedule with university,exams have Started and work reasons left me with no time,so seeing the second email I had to pull over and give at least something back by the roadside. If one is keen on a career in finance WSO is the place, it's worth it and the discussion section will broaden your commercial awareness. Thank you WSO.
Finally you'll get to the modeling, and you'll cover that in reasonable depth to understand what you're doing.
The course is well laid out with exams at the end of every module. The files you keep from this are a great future reference if you ever forget how exactly to do something. One last thing that I found excellent: the instructor is not just an Excel instructor, but also clearly works in finance. This shows up in additional tips throughout the course on best practices and how best to present your models.
The theory explanation is straight to the point and clear. I could understand all the concepts to build a complex financial modeling.
Currently I'm working at a M&A company in Brazil, and what I've learnt in this course is very useful for my daily tasks.
I do recommend this course.
The teacher explain complex topics in a simple way.
The teacher explain complex topics in a simple way.
There are questions at the end of each section that could be improved upon, but it's a modeling course not exam prep so it is understanable.
Overall, I would recommend this course to someone interested in learning LBOs.
I've done Excel courses before like this but with no practice, so only little of what I learned actually stuck. Practice makes perfect so I'm gonna head back to that :D
A solid use of time and great value for money - especially if purchased within the bundles.
However, despite this being of second nature to me, I decided to check out the WSO financial statement modeling course as part of the Elite Modeling package while planning my move to investment advisory. Needless to say, like the other WSO courses, this was a well-planned out course from which even a seasoned professional like me could take away a lot. Knowing various standards that are used in the finance and investment community helps to blend in with the pros.
Would definitely recommend getting not just this but the whole elite modeling package if that's still on offer. Thanks WSO team! :)
Received this as part of a bundle (fantastic value, I might add), and this was the perfect walk through for someone that knows theoretically what an LBO is, but wants a nuts and bolts perspective. Very accessible and quickly brings you up to speed. A very high yield course.
Certificates
Get The Excel Modeling Course Certification
After completing the course, all students will be granted the WSO Excel Modeling Course Certification. Use this certificate as a signal to employers that you have the technical Excel skills to immediately add value to your team.
Demonstrate that you have put in the work outside of university courses to make yourself more efficient and master the most critical program for success in finance careers. Easily share to LinkedIn and other social media sites to highlight your skills and strengthen your profile as a candidate.
Course Benefits
How much is the Excel Modeling Course Worth?
What You Get |
Value |
---|---|
WSO Excel Modeling Course 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 Months of Unlimited Elite Support from Actual Finance Pros 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 |
Total Value |
$1,370 |
Consider this your first investment in a long career...
After all, you've likely already spent tens of thousands of dollars on college (and perhaps tens of thousands more on an MBA)...
When you start your coveted finance job, you'll be making well over $200,000...
...over $350,000 if you have an MBA...
And that's just the beginning of a long and very lucrative career that could easily net you millions...
Even at thousands of dollars and your ROI would still be huge…
At a fraction of that price, the ROI is even better... When you do the math, it's a no brainer.
And that doesn't include the time you'd have to spend figuring all of this out and the hours of sleep these courses will save you.
Even if you used the free info online, you'd still have to find it, organize it, vet it and test it to get it to work. That would take months… and at that point, you may have missed your window.
The WSO Excel Modeling Course gives you everything you need to be super-efficient and master Excel Modeling… quickly and easily.
But we're not going to charge you thousands...
We won't even ask for half of that...
Get Unlimited Lifetime Access To The Excel Modeling Course For
This offer (+bonuses) is limited-time only
12 Month Money-Back Guarantee
Your investment is protected by our 12-Month Risk-Free Guarantee -- easily the most generous in the market.
If, for any reason (or no reason), you don't think the WSO Excel Modeling Course is right for you, just do the following within 365 days of your enrollment:
- Email [email protected] letting us know
- That's it!
We'll refund every penny. No questions asked. We bear the risk and will eat the transaction fees because we're that confident you'll love it.
Course Reviews
Here’s what professionals like you think of the course.
The theory explanation is straight to the point and clear. I could understand all the concepts to build a complex financial modeling.
Currently I'm working at a M&A company in Brazil, and what I've learnt in this course is very useful for my daily tasks.
I do recommend this course.
I am not sure how it compares to other LBO courses in terms of value for money (if there are even other LBO online courses out there), but I do want to emphasize that it is an extremely dense course compared to most other online/MOOC courses so the price (probably) scales accordingly compared to standard online course prices from other services.
Received this as part of a bundle (fantastic value, I might add), and this was the perfect walk through for someone that knows theoretically what an LBO is, but wants a nuts and bolts perspective. Very accessible and quickly brings you up to speed. A very high yield course.
FAQ
Answers to popular questions
About
Top professionals with many years of Bulge Bracket and/or Elite Boutique IB experience
- MBA Students and Business Undergraduates
- Current IB Analysts
- Corporate Finance Professionals
- Anyone trying to break into IB, consulting, etc....
- Professionals looking to lateral into high finance
- Taught and vetted by actual industry professionals
- Course content continually reviewed and updated
- Prepare to excel across all aspects of financial modeling
- Video-based self-study online courses from elite faculty (all current or previous finance professionals from top firms)
- Interactive quizzes
- Gamification to make more engaging
- 24 months elite support
ENQUIRIES
Any other questions?
We’re here to help.
We're confident you'll love the program and happy to answer any questions you have! E-mail [email protected] at any time and we'll get back to you within a few hours.