Image of the Wall Street Prep logo

Crash Course in Excel - Online Supplement to Self Study Program

Price: $39.00
Online Training - 3-month access
Price: $69.00
Online Training - 2-year access

For investment bankers, proficiency in Excel is a fundamental part of the job description. Wall Street Prep's Crash Course in Excel is an optional supplement to the Self-Study Program for those that want to acquire a comprehensive Excel skill set quickly and covers all versions of Excel, including Excel 2007.

  • Accelerate the internalization of the key time-saving shortcuts via exercise-based internalization drills, audio guidance, and interactive quizzes.
  • Learn how to incorporate and take advantage of the most popular and helpful Excel functions and table features for financial analysis.
  • Learn to quickly create macro-based shortcuts.
  • Build data tables and perform sensitivity analysis.
  • Enhance the presentation of financial and valuation models by adding forms and toggles to your spreadsheets.
  • This Excel training covers all versions of Excel, including Excel 2007.

Note: The Crash Course in Excel is a supplement to the Self-Study Program; it does not contain any financial modeling. Click back for the listing of Self Study Programs.

Table of contents and downloads

Excel 2003 Demo
Excel 2007 Demo

Key Highlights

  • Introduction to Excel layout
  • Immersion exercises and Excel shortcuts
  • Drills - Navigating in Excel
  • Drills - Entering and editing data
  • Drills - Manipulating work areas
  • Drills - Functions
  • Drills - Advanced Functions and data tables
  • Drills - Sensitivity analysis and form toggles
  • Drills - Sorting and autofiltering data
  • Drills - Recording Macros in Excel