Downloads for Videos:
Week7Busn214StartFile&FinishedFile

Download Workbooks With Homework:
Week07Homework.xlsx

Downloads for In Class Workbook:
In Class Week 7 Busn 214.xlsm
Boolean.xlsm
Lookup Adding.xlsm

VBlogs (click to watch):

Highline Excel Class 33: IF AND OR Customer Credit Analysis
Highline Excel Class 34: IF function Formula Payroll Formula
Highline Excel Class 35: IF Function Vs. VLOOKUP Function
Highline Excel Class 36: Array Formulas Basics
Highline Excel Class 37: SUMPRODUCT function
Highline Excel Class 38: Array Functions TRANSPOSE FREQUENCY
Highline Excel Class 39: Forcing Functions To Become Arrays

 Extra videos:
Excel Magic Trick 320: Lookup Adding: SUMPRODUCT & SUMIF
Excel Magic Trick 366: Lookup Adding For Accounting Estimate
Excel Magic Trick #183: Income Statement by Year & Month
Excel Magic Trick 597: Counting With 4 Criteria Including All Criteria Robust Formula

VBlogs (click to watch):
Highline Excel Class 47: PMT function 5 Examples
Highline Excel Class 48: Interest Rates 6 Examples
Highline Excel Class 49: Spreadsheet To Compare Loans
Highline Excel Class 50: Value Asset: PV NPV & XNPV function
Highline Excel Class 51: Life Time Savings Plan

Workbooks for extra videos:
WorkbookExcelMagicTricks317-323StartFile
WorkbookExcelMagicTricks317-323FinishedFile
WorkbookExcelMagicTricks358-369StartFile&FinishedFile
WorkbookExcelMagicTricks175-184StartFile
WorkbookExcelMagicTricks175-184FinishedFile
WorkbookExcelMagicTricks597-603StartFile&FinishedFile