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 withactual industry professionals.Understand excel modeling inside out and become a power user. Course content is continually reviewed and updated.
Best Practices
Learn the things youshould and should not doon 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. Wego over common mistakes and errorsanalysts and associates make starting out and give tips to put yourself in a better light.
Lifetime Access to WSO's Excel Modeling Course
Withover 100 lessons, we take you from a beginner in Excel to an absolute master with to help make sure youbuild a proper foundationfor 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 membersby demonstrating an excellent grasp of Excel. As an analyst or associate, you will "own" the model.
Investment Banking Interview 4-Hour Bootcamp OPEN NOW - Only 15 Seats | October 22, 2022 - 10:00AM EDT | $297 | View | |
Financial Modeling & Valuation 2-Day Bootcamp OPEN NOW - Only 15 Seats | November 5 - 6, 2022 - 10:00AM EDT | $997 | View | |
Private Equity Interview 1-Day Bootcamp OPEN NOW - Only 15 Seats | November 12, 2022 - 10:00AM EST | $497 | View | |
Venture Capital 4-Hour Bootcamp - Sat Nov 12th - Only 15 Seats | November 12, 2022 - 10:00AM EST | $197 | View | |
Financial Modeling & Valuation 2-Day Bootcamp OPEN NOW - Only 15 Seats | December 3 - 4, 2022 - 10:00AM EST | $997 | View | |
Show allShow less | ||||
Private Equity Interview 1-Day Bootcamp OPEN NOW - Only 15 Seats | December 10, 2022 - 10:00AM EST | $497 | View |
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
- 选择性粘贴
- 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:
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小时的生活指导了一个精英鳍ance 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
经常问什么estions
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 ourB0B体育平台下载 for more details
- Live-instruction conducted through Zoom
- Lifetime access to our Excel Modeling Course