Downloads for Videos:
Week3Busn214StartFile
Week3Busn214FinishedFile
Consolidate-ExcelMagicTricks90.xlsSratFile
Consolidate-ExcelMagicTricks90Finished.xlsFinishedFile

Downloads Workbook With Homework:
Week03Homework.xlsm

Downloads for In Class Workbook:
In Class Week 3 Busn 214.xlsm
Busn 214 Week 3 In Class.docx

VBlogs (click to watch):
Highline Excel Class 14: How To Setup Data in Excel
Highline Excel Class 15: Excel 2007 Tables 7 Examples
Highline Excel Class 16: Sort, Sorting 10 Examples
Highline Excel Class 17: Filter, Filtering 8 Examples
Highline Excel Class 18: Subtotals
Highline Excel Class 19: Advanced Filter Extract Data 9 Examples
Highline Excel Class 20: Pivot Tables 20 Examples
Excel Magic Trick #90: Consolidation

Other Videos to watch:
Excel Magic Trick 567: Collapsible Expandable Cell Ranges
Excel Magic Trick 86: Table Feature Copy Formula Automatic