Banking is covered in videos 27 & 28

Video/Class Project 27:
Video to watch:   Excel & Business Math 27: Bank Reconciliation Made Easy   ( 45:21 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo27BankReconciliation.xlsm 
Handout to download: ExcelBusinessMathVideo27BankReconciliation.pdf
Assigned Homework:  HW #1 - 2 at end of Excel Workbook for this video. 

Video/Class Project 28:
Video to watch:   Excel & Business Math 28: IF Function, IS Functions & Building a Check Register Other IF Tricks too   ( 31:41 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo28IFandCheckRegister.xlsx 
Handout to download: ExcelBusinessMathVideo28IFandCheckRegister.pdf
Assigned Homework:  HW #1 - 4 at end of Excel Workbook for this video. 

Payroll is covered in videos 29 - 36

Video/Class Project 29
Video to watch:   Excel & Business Math 29: Time Number Formatting & Time Calculations in Excel for Payroll Table   ( 19:59 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo29TimeNumberFormat.xlsx 
Handout to download: ExcelBusinessMathVideo29TimeNumberFormat.pdf 
Assigned Homework:  HW #1 - 2 at end of Excel Workbook for this video. 

Video/Class Project 30
Video to watch:    Excel & Business Math 30: Payroll Time Sheets, IF Function, Sheet Reference for Overtime & Gross Pay   ( 21:42 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo30ExcelTimeSheets.xlsx 
Handout to download: ExcelBusinessMathVideo30ExcelTimeSheets.pdf 
Assigned Homework:  HW #1 BIG HW Problem at end of Excel Workbook for this video. 

Video/Class Project 31
Video to watch:   Excel & Business Math 31: Night Shift Hours Worked Formula for Payroll Time Sheet (3 Examples)  ( 20:43 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo31NightShift.xlsx 
Handout to download: ExcelBusinessMathVideo31NightShift.pdf 
Assigned Homework:  HW #1 - 2 at end of Excel Workbook for this video. 

Video/Class Project 32
Video to watch:   Excel & Business Math 32: Rounding Time Calculations to Nearest 5 or 15 minutes using MROUND    ( 15:30 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo32RoundFiveMinutes.xlsx 
Handout to download: ExcelBusinessMathVideo32RoundFiveMinutes.pdf 
Assigned Homework:  HW #1 - 2 at end of Excel Workbook for this video. 

Video/Class Project 33
Video to watch:   Excel & Business Math 33: VLOOKUP Function for Incentive Pay: Commissions & Piecework (15 Examples)    ( 1 Hour & 20 mins)
Start file for Video/Class Project to download: ExcelBusinessMathVideo33VLOOKUPIncentive.xlsx 
Handout to download: ExcelBusinessMathVideo33VLOOKUPIncentive.pdf 
Assigned Homework:  HW # 1 - 10 at end of Excel Workbook for this video. 

Video/Class Project 34
Video to watch:   Excel & Business Math 34: MEDIAN Function for FICA Social Security & Medicare Payroll Deductions    ( 38:57 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo34SocialSecurityDeduction.xlsx 
Handout to download: ExcelBusinessMathVideo34SocialSecurityDeduction.pdf 
Assigned Homework:  HW # 1 - 4 at end of Excel Workbook for this video. 

Video/Class Project 35
Video to watch:    Excel & Business Math 35: VLOOKUP & MAX Functions for Percentage Method Federal Income Tax Deduction   ( 29:36 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo35VLOOKUPFedIncomeTaxDeduction.xlsx 
Handout to download:  ExcelBusinessMathVideo35VLOOKUPFedIncomeTaxDeduction.pdf
Assigned Homework:  HW #1 - 4 at end of Excel Workbook for this video. 

Video/Class Project 36
Video to watch:   Excel & Business Math 36: Comprehensive Excel Payroll Example: SUMIFS, MROUND, MOD, VLOOKUP & More     ( 28:44 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo36ComprehensivePayroll.xlsx 
Handout to download: ExcelBusinessMathVideo36ComprehensivePayroll.pdf 
Assigned Homework:  None.