Wall street prep – Excel Crash Course

Salepage: Wall street prep – Excel Crash Course

For finance professionals, proficiency In Excel Is a fundamental part of the job description. Whether you currently work In Excel at a beginner or Intermediate level, this course will take you to the next level and turn you into an advanced “power” user. We’ll start with the basics before we quickly introduce you to 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’ll be completing Excel exercises alongside the instructor at every step of the way.

Course Objective

We’ll start with the basics before we quickly introduce you to 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’ll be completing Excel exercises every step of the way

What You Will Learn

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

Wall Street Prep’s Excel Crash Course is used at top financial institutions and business schools.

Full Course Agenda

• Basic Excel Shortcuts, Navigation & Editing
• Logical, Date & Concatenation Functions
• Lookup Functions & Data Tables
• Math functions
• Text Functions
• Sorting, Filters, and Pivot Tables
• VBA, Recording Macros & Custom Form

Read more about: Wall street prep