Excel Master Bootcamp - 4 Hours
Introducing...
An Intense 4-Hour Bootcamp to Help You
Become Efficient at Financial Modeling
Limited to 15 Seats
WHAT YOU’LL GET IN THIS VIRTUAL 4-HOUR BOOTCAMP
Get Taught by The Best
Boost your efficiency at financial modeling with actual industry professionals. Understand excel modeling inside out and become a power user. Course content is continually reviewed and updated.
Best Practices
Learn the things you should and should not do on the job to make sure you're presenting yourself and your work in front of colleagues and senior team members in the best light possible. We go over common mistakes and errors analysts and associates make starting out and give tips to put yourself in a better light.
Lifetime Access to WSO's Excel Modeling Course
With over 100 lessons , we take you from a beginner in Excel to an absolute master with to help make sure you build a proper foundation for the more advanced financial modeling courses later.
Master Excel Shortcuts
Learn how to save time and enhance productivity, establishing trust and stability of senior team members by demonstrating an excellent grasp of Excel. As an analyst or associate, you will "own" the model.
WSO Excel Master Bootcamp - Video Preview
Topics Covered
- Introduction and Course Overview
- Flow of the Course
- Setup For Mac Users
- Getting Familiar with Excel
- Introduction
- Worksheet Navigation and Selection
- The Ribbon, Hotkeys, and the Formula Bar
- Worksheets, View/Zoom, and Navigating Menus
- Excel Shortcuts
- Introduction
- Windows Shortcuts
- Familiar Shortcuts
- Ctrl vs. Alt
- Comments
- Fill Right and Down
- Paste Special
- Rows and Columns
- Grouping and Hiding
- Common Hotkeys
- Quick Access Toolbar
- Office Hotkeys
- Introduction
- Formatting Best Practices
- Default Formats
- Custom Number Formatting
- Other Formatting Tips
- Conditional Formatting
- Introduction
- Show and Zoom
- Freeze Panes
- Split Panes and New Window
- Print and Page Layout
- Introduction
- Formulas
- Errors
- Basic Math Functions
- Advanced Math Functions
- Anchoring
- More Math Functions
- Introduction
- Dates in Excel
- Useful Date Functions
- Time Calculations
- & and TEXT
- Dynamic Text Example
- Introduction
- IF and Nested IF
- AND, OR, and XOR
- Comparison Operators
- IFERROR
- Information Functions
- PROPER, LOWER, and UPPER
- LEFT, RIGHT, and MID
- Text to Columns
- SUBSTITUTE
- SEARCH
- Introduction
- VLOOKUP & HLOOKUP
- INDEX + MATCH
- VLOOKUP vs INDEX + MATCH
- Data Validation
- Financial Functions Master
- Introduction
- Scenarios
- Data Tables
- Naming Cells
- Formula Auditing
- Introduction
- Data Overview
- Sorting
- Filtering
- Pivot Tables
- Inserting and Adjusting Charts
- Select Data and Combo Charts
- Other Chart Elements
- Data Labels
- Trendlines and Regression
Our customers have landed positions at all top Wall Street firms, including:
.png)
Get Distinct Course Certifications
After completing each course, all students will be granted a WSO Certification for that specific course. Use these certificates as a signal to employers that you have the technical 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 is Your
Finance Career Worth?
|
What You Get |
Value |
|---|---|
|
WSO Excel Master Bootcamp 4 hours of live instruction taught by an elite Finance professional... |
$997 |
|
WSO Excel Modeling Course 110+ video lessons across 13 Modules taught by a top-ranked bulge bracket investment banker... |
$97 |
|
TOTAL VALUE |
$1,094 |
Get Unlimited Lifetime Access To The Excel Modeling Course And Attend the 4-Hour Excel Master Bootcamp For 72% Off
$1,094
$297
Secure checkout
Frequently Asked Questions
Professionals from top investment banks and private equity funds
- MBA Students and Business Undergraduates
- Incoming Venture Capital Analysts and Associates
- Investment Banking Analysts and Associates
- Incoming Real Estate Investment Analysts and Associates
- Incoming Private Equity Associates/Analysts
- Corporate Finance Professionals
- Taught and vetted by actual industry professionals
- Course content continually reviewed and updated
- Boost your efficiency at financial modeling
- Please check out our Events page for more details
- Live-instruction conducted through Zoom
- Lifetime access to our Excel Modeling Course