Excel Training Videos

 Lesson 1: General Shortcuts in Windows , Time 9:33
How to move from program to program. How to use keyboard shortcuts.

Lesson 2: What is Excel Good and Bad at Handling , Time 3:24
What types of things is Excel able to handle well and which things is it not well suited for?

Lesson 3: Error Messages in Excel , Time 4:53
What error messages might you see in Excel, what do they mean, and how do you fix them.

Lesson 4: Moving Around Excel , Time 4:11
How do you move around the spreadsheet, select text, and freeze panes?

Lesson 5: Excel Recognizes Sequences , Time 4:12
Excel can recognize and continue sequences both numeric and non-numeric.

 

 

Forecasting and DCF models in Excel
 Lesson 1: Setting up the model , Time 13:19
Good spreadsheet design and simplifying the historical financials to prepare it for forecasting.

Lesson 2: Projecting the Income Statement , Time 10:34
Basics of the assumptions table and how to construct the forecasted income statement.

Lesson 3: Projecting the Balance Sheet , Time 18:11
Using ratios to forecast the first pass balance sheet. First pass will not balance because it keeps financing decisions constant.

 

  Home  Finance I Videos  Finance II Videos  Excel Training Videos  BA II+ Calculator Training Videos