FREE EXCEL CRASH COURSE
Introducing...
65+ Lessons, 6 Exercises, 2+ hours of video lessons
To Help You Thrive in the Most Prestigious Jobs on Wall Street...
FREE EXCEL CRASH 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 form a significant part of 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 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
Excel Date & Text Functions (8 video lessons, 1 exercise)
In this module, we use 8 video lessons to demonstrate basic and advanced Date and Text functions that will come up frequently on the job. This includes an exercise with aggressive benchmarking and a video solution to make sure you don't move on until you have a complete understanding.
Excel View & Print (7 video lessons, 1 exercise)
In this module, we use 8 video lessons to walk you through the various View and Print functions Excel offers that will boost your productivity. This includes an exercise with aggressive benchmarking and a video solution to make sure you don't move on until you know the ins and outs of these functions.
Our students have landed and thrived at positions across all top Wall Street firms, including:
WSO Free Excel Crash Course - Video Preview
Below you will find some video previews of specific lessons in our Free Excel Crash 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.
Excel Modeling Course Summary Table of Contents
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)
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.
Get the Excel Modeling Course Certification
After completing the course, all students will be granted the WSO Excel Crash 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
FREE Excel Crash Course Provide?
This Excel Crash Course Includes: | Value |
|---|---|
WSO Free Excel Crash Course 65+ video lessons across 7 Modules taught by a top-bucket bulge bracket investment banker. | $200 |
6 Interactive Exercises with Benchmarks Gain realistic practice drilling the concepts taught in the course with timed benchmarks so that you can. | $250 |
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 |
TOTAL VALUE | $750 |
Get Unlimited Lifetime Access To The WSO Excel Modeling Course For 100% Off
$750
$0 (FREE)
Pay in full or make 3 monthly payments of... Just kidding. It's FREE.
Secure checkout
