Student Passport Access: Crash Course in Excel
 Price: $39/month Order Now |
|
| Module Type | Access Level |
|---|---|
| Financial Modeling | |
| Financial Statement Modeling | Unlimited |
| DCF Modeling | Unlimited |
| LBO Modeling | Unlimited |
| M&A Accretion/Dilution Modeling | Unlimited |
| Trading Comps Modeling | Unlimited |
| Transaction Comps Modeling | Unlimited |
| Interview Prep | |
| Acing the "fit" interview | Unlimited |
| Acing the quantitative interview | Unlimited |
| Crash Courses | |
| Accounting | Unlimited |
| Excel | Unlimited |
| Navigating Financial Reports | Unlimited |
| Advanced Modeling | |
| Advanced Financial Modeling | Unlimited |
| Advanced LBO Modeling | Unlimited |
Excel is a powerful tool widely used on Wall Street to perform financial and valuation modeling. Accordingly, Wall Street Prep has developed the Excel seminar for participants with a limited or no knowledge of this application.
- Provides the required Excel foundation for those pursuing careers in finance.
- Taught using easy-to-follow materials filled with exercises that test and reinforce covered concepts.
- Prepares participants for the Financial and Valuation Modeling training seminars, which presume a basic understanding of Excel.
- Learn Excel Basics—menu commands, data manipulation, and formatting.
- Gain Excel proficiency—calculations, functions, formulas, and Excel best practices.
- Understand advanced Excel features—data tables and macros.
- Introduction to modeling techniques, and the role of Excel in Financial and Valuation Modeling.
-
Chapter 1: Introduction to Excel layout
-
Chapter 2: Immersion exercises and Excel shortcuts
-
Chapter 3: Drills - Navigating in Excel
-
Chapter 4: Drills - Entering and editing data
-
Chapter 5: Drills - Manipulating work areas
-
Chapter 6: Drills - Functions
-
Chapter 7: Drills - Advanced Functions and data tables
-
Chapter 8: Drills - Sensitivity analysis and form toggles
-
Chapter 9: Drills - Sorting and autofiltering data
-
Chapter 10: Drills - Recording Macros in Excel