Download Start Excel File: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/Content/05BankingPayroll/ExcelBusinessMathVideo35VLOOKUPFedIncomeTaxDeduction.xlsx
Download pdf Notes: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/Content/05BankingPayroll/ExcelBusinessMathVideo35VLOOKUPFedIncomeTaxDeduction.pdf
Entire Class Web Site: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/135/135NoTextBookClass.htm

In this video learn how to use VLOOKUP & MAX Functions to make Federal Income Tax Withholding Deduction formulas.
Excel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College / Mike Girvin at excelisfun Channel at YouTube Channel.
Topics in Video:
1. (00:01) Introduction
2. (00:31) Federal Income Tax Withholdings Deducted from Employees Paychecks
3. (02:42) IRS web site with 2018 Percentage Method Tax Tables.
4. (04:00) 2018 Percentage Method Federal Income Tax Withholding Tables in Excel
5. (06:19) Video Example 1: Calculate Federal Income Tax Withholdings for Marital Status “Single” and Pay Period Weekly. Calculations made by Hand and with MAX and VLOOKUP.
6.
7. (17:05) Use Formula Evaluator to verify that VLOOKUP Formula is working correctly
8. (18:38) Video Example 2: Calculate Federal Income Tax Withholdings for Marital Status “Married” and Pay Period Weekly. Calculations made by Hand and with MAX and VLOOKUP.
9. (21:36) Video Example 3: Calculate Federal Income Tax Withholdings for Marital Status “Single” and Pay Period Weekly for an Entire Payroll Table. Calculations made with MAX and VLOOKUP.
10. (27:33) Video Example 4: Calculate Federal Income Tax Withholdings for Marital Status “Married” and Pay Period Weekly for an Entire Payroll Table. Calculations made with MAX and VLOOKUP. See how to copy a Whole Table for formulas to a new template.
11. (28:28) Summary

Next Video: 36 Excel & Business Math