Log in
Log inBook a demo

Excel Crash Course

COURSE
Wall Street Prep
8 hrs

Excel Crash Course

COURSE
Wall Street Prep
8 hrs
Included in GO1 PremiumStarting from $12 per user for teamsLearn moreTry for free
Included in GO1 PremiumStarting from $12 per user for teamsLearn moreTry for free

Course Overview 

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.

Instructor - Matan Feldman 

Matan Feldman is Wall Street Prep’s Founder and Managing Partner. His responsibilities include business development, development of courses, and overseeing training programs. Matan has overseen training programs for clients including Morgan Stanley, Credit Suisse, Raymond James, Stifel Nicolaus, FBR Capital Markets, Sagent Advisors, Giuliani Capital Advisors, JP Morgan, Cerberus, Wharton Business School, London Business School, Kellogg, Booth, Stern (NYU), and Cornell. Prior to founding Wall Street Prep, Matan served in several capacities on Wall Street — first as an Analyst in Chase Manhattan Bank's Mergers & Acquisitions Group in New York, and subsequently as an Associate within JP Morgan's Equity Research Group, covering Food & Drug Retail Equities.

Learning
CHAPTER 1: WELCOME TO EXCEL
Getting Startedvideo • 10 mins
Ribbon Layoutvideo • 5 mins
Using the Keyboard To Navigate the Excel Ribbonvideo • 5 mins
Excel Settingsvideo • 8 mins
Excel Basics Review - Quizquiz
CHAPTER 2: EXCEL BASICS
Basic Excel Shortcuts, Navigation & Editingvideo • 7 mins
Basic Formattingvideo • 5 mins
Referencing Cells From Other Worksheetsvideo • 5 mins
Navigation to Referencing Cells from Other Workbooksvideo • 2 mins
Navigation Within Excel Review - Quizquiz
CHAPTER 3: FORMATTING & NAVIGATION
Splitting & Freezing Panesvideo • 4 mins
Entering & Editing Datavideo • 8 mins
Columns & Rowsvideo • 7 mins
Paste Specialvideo • 10 mins
Ctrl Shortcutsvideo • 1 min
Naming Cellsvideo • 3 mins
Anchoring Cellsvideo • 4 mins
Naming Worksheetsvideo • 1 min
Grouping & Hiding Columns & Rowsvideo • 3 mins
Grouping Workbooksvideo • 3 mins
Formula Auditingvideo • 7 mins
Cell Alignment & Center Across Selectionvideo • 3 mins
Go to Specialvideo • 4 mins
Conditional Formattingvideo • 10 mins
Creating Dynamic Headers, Custom Formatting & the TEXT Functionvideo • 8 mins
More on Custom Formattingvideo • 16 mins
Find and Replacevideo • 3 mins
#Ref, #Div/0! & Other Excel Errorsvideo • 3 mins
Page layoutvideo • 7 mins
Entering/Editing Data Review - Quizquiz
CHAPTER 4: DATE & CONCATENATION FUNCTIONS
Introduction to Functions: SUM & Averagevideo • 3 mins
Simple & Nested IF Statementsvideo • 10 mins
IFS statement (2016+ only)video • 7 mins
IFERROR & Concatenationvideo • 8 mins
Date Functions: EOMONTH & EDATEvideo • 5 mins
ISNUMBER, ISTEXT & Combining with IF to Create Overridesvideo • 7 mins
More Date Functions: YEARFRAC, DAY, MONTH, YEAR & DATEvideo • 6 mins
AND & OR Functionsvideo • 6 mins
Logical Functions Review - Quizquiz
CHAPTER 5: LOOKUP FUNCTIONS & DATA TABLES
HLOOKUP, VLOOKUP, CHOOSE, OFFSET & INDEX Functionsvideo • 11 mins
Common Errors with HLOOKUP, VLOOKUP, CHOOSE, OFFSET & INDEXvideo • 3 mins
The MATCH Functionvideo • 3 mins
Combining H/VLOOKUP, OFFSET, INDEX, CHOOSE with MATCHvideo • 14 mins
Combining INDIRECT with &video • 8 mins
Creating Drop Down Menus with Data Validationvideo • 3 mins
Combining INDIRECT with MATCHvideo • 1 hr
The Address Functionvideo • 8 mins
Using COLUMN and ROW Functions and Counters in Complex Formulasvideo • 7 mins
Data Tablesvideo • 14 mins
When Data Tables Fail - Self Referencing IF Statementvideo • 8 mins
Lookup Functions and Data Tables Review - Quizquiz
CHAPTER 6: MATHEMATICAL FUNCTIONS
The SUMPRODUCT Functionvideo • 4 mins
Advanced SUMPRODUCT: Adding Criteria & Booleans in Excelvideo • 13 mins
SUMIF/S & AVERAGEIF/Svideo • 8 mins
CEILING, FLOOR & ABS Functionsvideo • 2 mins
ROUND, ROUNDUP, ROUNDDOWN & COMBIN Functionvideo • 4 mins
The MIN & MAX Functionsvideo • 3 mins
COUNT/A & COUNTIF/S Functionsvideo • 5 mins
Present Value & Future Value Functionsvideo • 7 mins
NPV & XNPV Functionsvideo • 7 mins
IRR & XIRR Functionsvideo • 3 mins
Mathematical Functions Review - Quizquiz
CHAPTER 7: TEXT FUNCTIONS
Text Functions (LEN, LEFT, RIGHT, MID, REPLACE, etc.)video • 8 mins
Using Text Functions to Solve Data Extraction Challengesvideo • 8 mins
Flash Fill (Excel 2013 Only)video • 3 mins
Text to Columnsvideo • 6 mins
Remove Duplicatesvideo • 2 mins
VALUE and DATEVALUEvideo • 4 mins
CHAPTER 8: SORTING, FILTERS AND PIVOT TABLES
Sort & Subtotalvideo • 4 mins
Autofiltervideo • 4 mins
Pivot Tables, Part 1video • 9 mins
Pivot Tables, Part 2video • 8 mins
CHAPTER 9: USING EXCEL TO SOLVE PROBLEMS
The fiscal half date problemvideo • 9 mins
The Olympic event problemvideo • 16 mins
Excel Crash Course Conclusionvideo • 1 min
APPENDIX: RECORDING MACROS & CUSTOM FORMATTING
Appendix VBA & Macros in Excelvideo • 7 mins
Supplementary Materials
Step by Step Course Manualdocument
Supporting Documents Kittext