Wall Street Prep – Excel Crash Course 2022

Wall Street Prep - Excel Crash Course 2022

For finance professionals, proficiency in Excel is a fundamental part of the job description. Whether you describe yourself as a beginner or proficient in Excel, this course will take you to the next level and turn you into an advanced “power” user.

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

Course TOC

Chapter 1: Welcome to Excel

Chapter 2: Excel Basics

Chapter 3: Formatting & Navigation

Chapter 4: Date & Concatenation Functions

Chapter 5: Lookup Functions & Data Tables

Chapter 6: Mathematical Functions

Chapter 7: Text Functions

Chapter 8: Sorting, Filters and Pivot Tables

Chapter 9: Using Excel to Solve Problems

Chapter 10: Using LAMBDA to Create Custom Functions

Appendix: Recording Macros & Custom Formatting

There are no reviews yet.

Add a Review

You must be <a href="https://wislibrary.net/my-account/">logged in</a> to post a review.