Download files for Chapter 00 (Right-click link, then click SAVE to download):
Ch 00 Excel Workbook.xlsx:
(This contains: 1) In-class/Video Projects (blank templates and solutions) and
2) Homework (blank templates and solutions))
Chapter 00 Hand Drawings
(Class Notes)
Chapter 00 PowerPoint (None for this chapter)
If file downloads as ".zip", watch this video: Download Excel File Shows Up As Zip?
Watch videos for Chapter 00 (Click link):
Excel Finance
Class 01: Intro To Excel 2007 & 2010
Excel Finance
Class 02: Getting Started with Formulas, Functions, Formula Inputs and Cell
References
Excel Finance
Class 03: Math Operators and Order of Operations
Excel Finance
Class 04: The Importance Of Number Formatting In Financial Calculations
Excel Finance
Class 05: Percent, Percent Change / Increase / Decrease Percentage Number
Formatting
Excel Finance Class 06: Relative and Absolute Cell References in
Copied Formulas
Excel Finance Class 07: Stylistic Formatting
Here is a 1 minute video hint about how to watch the videos:
Excel Magic Trick 827: Alt + Tab To Switch Between Open Windows (YouTube Video &
Excel)
http://www.youtube.com/watch?v=02SWSyLjQkc
Here is a 1 minute video hint about how to create formulas in green cells:
Excel Magic Trick 826: Formatting Floods Out Cell References When Making
Formulas
http://www.youtube.com/watch?v=s4LoD-j489I