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.