EXCEL MODELING COURSE
Introducing...
To Help You Thrive in the Most Prestigious Jobs on Wall Street...
EXCEL MODELING COURSE PREVIEW
Excel Formatting (8 video lessons, 1 exercise)
In this module, we use 8 video lessons to expand upon the best practices in previous modules to learn conditional formatting and custom number formatting (among other topics). This module also includes an exercise with aggressive benchmarking 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 use 9 video lessons to help explain anchoring as well as basic and advanced math functions that will come up frequently on the job. This module also includes an exercise at the end with a video solution so you can see how an actual investment banker uses these in the real world…
Excel Logic & Data Functions (13 video lessons, 1 exercise)
In this module, we use 13 video lessons to 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 another challenging exercise…
Excel Lookup and Financial Functions (8 video lessons, 1 exercise)
In this module, we use 8 video lessons to 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 another challenging exercise that tests your retention and speed…
Excel Scenarios, Data Tables and Auditing (7 video lessons, 1 exercise)
In this module, we use 7 video lessons 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 another timed benchmarking exercise…
Excel Sorting, Filtering and Pivot Tables (7 video lessons, 1 exercise)
In this module, we use 7 video lessons 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 another timed benchmarking exercise…
Excel Navigation (7 video lessons, 1 exercise)
In this module, we use 7 video lessons to explain best practices when navigating Excel. This includes an exercise with aggressive benchmarking and a video solution to make sure you don't move on until you have true mastery.
Excel Efficiency Foundation (14 video lessons, 1 exercise)
In this module, we use 14 video lessons to explain best practices on how to gain maximum efficiency when navigating Excel (and Windows) for finance careers. This includes an exercise with aggressive benchmarking and a video solution to make sure you are building good habits for financial modeling
Our students have landed and thrived at positions across all top Wall Street firms, including:
WSO Excel Modeling Course 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) the right way the first time around.
Below you will find a list of the modules and lessons included in this course.
- Introduction and Course Overview (5Min)
- Flow of the Course (1Min)
- Setup For Mac Users (5Min)
- Getting Familiar with Excel (2Min)
- Introduction (1Min)
- Excel Shortcuts (4Min)
- Worksheet Navigation and Selection (5Min)
- The Excel Ribbon, Hotkeys, and the Formula Bar (5Min)
- Excel Worksheets, View/Zoom, and Navigating Menus (5Min)
- Excel Review (1Min)
- Excel Navigation Exercise [DOWNLOAD]
- Navigation Exercise: Answer (4Min)
- Introduction
- Excel Windows Shortcuts
- Excel Familiar Shortcuts
- Ctrl vs. Alt
- Excel Comments
- Fill Right and Down
- Excel Paste Special
- Excel Rows and Columns
- Grouping and Hiding
- Excel Common Hotkeys
- Office Hotkeys
- Quick Access Toolbar
- Review
- Excel Efficiency Foundation Exercise
- Efficiency Foundation Exercise: Answer
- Introduction
- Excel Formatting Best Practices
- Excel Default Formats
- Excel Custom Number Formatting
- Other Formatting Tips
- Excel Conditional Formatting
- Review
- Excel Formatting Exercise
- Formatting Exercise: Answer
- Introduction (1Min)
- Excel Show and Zoom (4Min)
- Excel Freeze Panes (6Min)
- Split Panes and New Window (4Min)
- Excel Print and Page Layout (7Min)
- Review (1Min)
- Excel View & Print Exercise
- View & Print Exercise: Answer (3Min)
- Introduction (1Min)
- Excel Formulas (4Min)
- Excel Errors (5Min)
- Excel Basic Math Functions (8Min)
- Excel Advanced Math Functions (10Min)
- Excel Anchoring (7Min)
- More Math Functions (2Min)
- Review (1Min)
- Excel Math Functions Exercise
- Math Functions Exercise: Answer (4Min)
- Introduction (1Min)
- Dates in Excel (4Min)
- Useful Date Functions (5Min)
- Excel Time Calculations (2Min)
- & and TEXT (6Min)
- Excel Dynamic Text Example (5Min)
- Review (1Min)
- Date & Text Functions Exercise
- Date & Text Functions Exercise: Answer (5Min)
- Introduction (2Min)
- Excel IF and Nested IF (4Min)
- Excel AND, OR, and XOR (7Min)
- Excel Comparison Operators (1Min)
- IFERROR in Excel (3Min)
- Excel Information Functions (1Min)
- PROPER, LOWER, and UPPER (2Min)
- LEFT, RIGHT, and MID (2Min)
- Text to Columns (3Min)
- Excel SUBSTITUTE (1Min)
- Excel SEARCH (3Min)
- Review (1Min)
- Logic & Data Functions Exercise
- Logic & Data Functions Exercise: Answer (6Min)
- Introduction (1Min)
- Excel VLOOKUP & HLOOKUP (4Min)
- Excel INDEX + MATCH (4Min)
- VLOOKUP vs INDEX + MATCH (6Min)
- XLOOKUP (4Min)
- Excel Data Validation (4Min)
- Excel Financial Functions Master (7Min)
- Review (1Min)
- Lookup & Financial Functions Exercise
- Lookup & Financial Functions Exercise: Answer (4Min)
- Introduction (1Min)
- Excel Scenarios (6Min)
- Excel Data Tables (6Min)
- Excel Naming Cells (6Min)
- Excel Formula Auditing (4Min)
- Review (1Min)
- Scenarios, Data Tables, & Auditing Exercise
- Scenarios, Data Tables, & Auditing Exercise: Answer (3Min)
- Introduction (1Min)
- Excel Data Overview (2Min)
- Excel Sorting (5Min)
- Excel Filtering (5Min)
- Excel Pivot Tables (12Min)
- Review (1Min)
- Sorting, Filtering, & Pivot Tables Exercise
- Sorting, Filtering, & Pivot Tables Exercise: 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)
- Trendlines and Regression (4Min)
- Review (1Min)
- Excel Charts Exercise
- Excel Charts Exercise: Answer (3Min)
- Introduction (1Min)
- Inserting and Adjusting Charts (3Min)
- Select Data and Combo Charts (4Min)
- Other Chart Elements (2Min)
- Data Labels (2Min)
- Trendlines and Regression (4Min)
- Review (1Min)
- Excel Charts Exercise
- Excel Charts Exercise: Answer (3Mi
- Capstone Assignment
- Challenge #1 (8Min)
- Challenge #2 (6Min)
- Challenge #3 (9Min)
- Course Outro (1Min)
Don't Take Our Word For It
Wall Street Oasis has trained over 63,000 students at elite corporate and educational institutions for over a decade.
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.
How Much Value Does This
Excel Modeling Course Provide?
This Online Excel Class Includes: | 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 |
Get Unlimited Lifetime Access To The WSO Excel Modeling Course For 93% Off
$1,370
$97
Pay in full or make 3 monthly payments of $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. In short, you get a great return on your investment, or you get your money back. It's that simple.