Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Financial Modeling 201: Kickstart your Spreadsheet Skills
Chapter 1 - Course Introduction and Overview
Welcome to Financial Modeling 201: Kickstart Your Spreadsheet Skills. Here's what you'll learn! (8:30)
Chapter 2 - Introduction to Spreadsheets
2a. What is a Spreadsheet? (16:07)
2b. Absolute & Relative Cell Referencing (18:47)
2c. How to Make Spreadsheets More User-Friendly (14:21)
Reference Sheet: Spreadsheet Formatting Conventions
2d. Useful Keyboard Shortcuts (8:09)
Reference Sheet: Basic Spreadsheet Keyboard Shortcuts
2e. How to Use the Excel Ribbon Menu (7:06)
Reference Sheet: Excel Working Space Basic Elements
Quiz on Spreadsheet Basics
Answers to Quiz on Spreadsheet Basics
Chapter 3 - Spreadsheet Functions and Error Checking
Reference Sheet: Excel Functions
3a. Basic Math & Statistical Functions (7:49)
-- Excel Functions Exercises: Introduction & Spreadsheet (1:28)
-- Exercises: SUM AVERAGE ROUND (3:06)
3b. Lookup and Logical Functions (19:28)
-- Exercises: MAX MIN VLOOKUP INDEX MATCH IF (7:18)
3c. Financial Functions (13:51)
-- Exercises: PV PMT FV (5:10)
3d. Profitability Metrics (18:22)
-- Exercises: NPV IRR XNPV XIRR (6:01)
3e. Goal Seek (5:39)
-- Exercises: Goal Seek (2:44)
3g. 12 Common Spreadsheet Errors to Avoid (21:23)
Guideline: 12 Common Spreadsheet Errors to Avoid (with Examples)
3h. How to do Spreadsheet Error Checking (17:55)
Guideline: How to Reduce Spreadsheet Errors
Quiz on Spreadsheet Functions & Error Checking
Answers to Quiz on Spreadsheet Functions & Error Checking
Chapter 4 - How to Draw Charts and Spot Errors & Deceptions
4a. Why Draw Charts? - the Value of Data Visualization (10:40)
4b. How to Select the Best Chart Type for the Job (8:08)
4c. How to Draw (Better) Charts (16:10)
Guideline: 5 Principles for Drawing Better Charts
4d. Chart Errors and Deceptions (5:42)
4e. Curve-Fitting, Interpolation & Extrapolation (14:08)
Guideline: Chart Type Selection Guide
Quiz on Drawing Charts and Spotting Errors and Deceptions
Answers to Quiz on Drawing Charts and Spotting Errors & Deceptions
4f. Course Conclusion (2:34)
Course Evaluation Questionnaire
2c. How to Make Spreadsheets More User-Friendly
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock