Excel for Investment Banking

Course details

For finance professionals, Excel proficiency is an absolute must. Wall Street Prep's "Excel for Investment Banking" will give you a competitive edge by turning you into a blazingly fast "Power User." We start with the basics, but very quickly introduce lesser known time-saving keyboard shortcuts and powerful Excel functions and features that you can immediately put to use on the job. The only way to learn Excel is by doing, so you will complete frequently encountered Excel exercises every step of the way.

Lessons include:

• Accelerate the internalization of the key time-saving shortcuts via exercise-based internalization drills and video-driven guidance.
• 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 spreadsheet