Downloads:
Busn214Ch07to10.zip
Finished In-class workbook: Busn214SIBWMOE2007Chapter07-10fromMGirvinFinished.xlsm

VBlogs and YouTube videos for Class Content(click to watch):
VBlog14Busn214AdvancedExcelCh07
VBlog15Busn214AdvancedExcelCh07
VBlog16Busn214AdvancedExcelCh07
VBlog17Busn214AdvancedExcelCh07
VBlog18Busn214AdvancedExcelCh07
VBlog19Busn214AdvancedExcelCh07
Excel Magic Trick #46: Absolute Macro Recorder (about 10 minutes)
Excel Magic Trick #47: Relative Macro Recorder (about 8 minutes)
Excel Magic Trick #48 Part 1: Bad Data To Good Data  (about 8 minutes)
Excel Magic Trick #48 Part 2: Bad Data To Good Data  (about 5 minutes)
VBlog20Busn214AdvancedExcelCh07

Related You Tube videos:
Concatenate and Ampersand
Subtotals
Text To Columns
Text Formulas and TEXT function