Basic Excel Training Videos
 With thanks to Niki Simoneaux (MBA '06).

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
 With extreme gratitude to Brian Dolan, Susie Min, and Brad Page (all MBA '08) who created these files as part of a tutorial. Disclaimer: these lessons show one way to do forecasting and modeling. There are alternative ways to do such modeling and this should be taken as an example rather than the "way" to do this.

All of the following lessons use Hershey Foods. The files mentioned in the videos are:

Lesson 1: Historical Income Statement , Time 4:31
Formatting the historical income statement from Edgar Online in Excel.

Lesson 2: Historical Balance Sheet , Time 7:28
Formatting the historical Balance Sheet from Edgar Online in Excel.

Lesson 3: Assumptions Tab , Time 7:22
Creating an assumptions table to drive the numbers in the model.

Lesson 4: Projecting the Income Statement , Time 3:04
Forecasting based on sales growth and the percentage of sales method.

Lesson 5: Projecting the Balance Sheet , Time 5:57
Forecasting based on balance sheet ratios.

Lesson 6: Projecting the Statement of Cash Flows , Time 5:16
Forecasting ending cash balances.

Lesson 7: Forecasting the Debt and Interest Schedule , Time 11:55
Allows you to forecast the financing needs for the firm (excess cash versus borrowing)

Lesson 8: Connecting it All , Time 3:09
Links all of the financial statements and circular references to make the model fully functioning.

 

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