Optional Supplement II: Crash Course in Excel

Click on any module for more details Premium Package: The complete program. Modules I-VI Module I: Financial Statement Modeling Module II: DCF Modeling Module III: LBO Modeling Module IV: M&A Accretion/Dilution Modeling Module V: Trading Comps Modeling Module VI: Transaction Comps Modeling Optional Supplement I: Crash Course in Accounting Optional Supplement II: Crash Course in Excel Please contact Matan Feldman for corporate access and pricing information: mfeldman@wallstreetprep.com or 800.646.3575 ex. 703

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.

Key Learning Outcomes

• 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.

Overview

• Section 1: Excel Basics Overview of Excel Excel A-B-C's-Excel navigation and menu commands Entering, moving, and manipulating data Excel formatting
• Section 2: Gaining Excel Proficiency Calculations, formulas & functions
• Section 3: Advanced Excel Topics Excel mechanics and best practices Introduction to data tables and macros
• Section 4: Excel & Financial Modeling Introduction to modeling techniques Excel and its role in Financial and Valuation Modeling.