Instructions:
1) Download all files
2) Open files
3) Click on video and watch
4) Complete project as seen in video.
5) Do homework practice problems at the end of the Excel workbook.
Downloads:
135Chapter00.xlsx
If file downloads as ".zip", watch this video: Download Excel File Shows Up As Zip?
Videos To Watch:
Excel 2010 Business Math 01: Intro To Excel: Ribbons, QAT, Worksheets,
Workbooks, Calculations (24 mins)
Excel 2010 Business Math 02: Formulas In Excel (12 mins)
Excel 2010 Business Math 03: Stylistic and Number Formatting (11 mins)
Excel 2010 Business Math 04: Range Functions Rule! (3 mins)
Excel 2010 Business Math 05: Don't Get Tricked By Number Formatting (Number
Formatting As Façade) (16 mins)
Excel 2010 Business Math 06: Math Order Of Operations & Formulas In Excel (7
mins)
Excel 2010 Business Math 07: How To Search For and Use Excel Functions (11
mins)
Excel 2010 Business Math 08: Relative and Absolute Cell References and Fill
Handle and Angry Rabbit (16 mins)
Excel 2010 Business Math 09: Summarize Formula Inputs, Formulas & Stylistic
Number Formatting (7 mins)
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