Download Start Excel File: http:\/\/ift.tt\/2F21S4D
\nDownload pdf Notes: http:\/\/ift.tt\/2owePNU
\nEntire Class Web Site: http:\/\/ift.tt\/2BjafuY<\/p>\n
In this video learn how to use VLOOKUP & MAX Functions to make Federal Income Tax Withholding Deduction formulas.
\nExcel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College \/ Mike Girvin at excelisfun Channel at YouTube Channel.
\nTopics in Video:
\n1. (00:01) Introduction
\n2. (00:31) Federal Income Tax Withholdings Deducted from Employees Paychecks
\n3. (02:42) IRS web site with 2018 Percentage Method Tax Tables.
\n4. (04:00) 2018 Percentage Method Federal Income Tax Withholding Tables in Excel
\n5. (06:19) Video Example 1: Calculate Federal Income Tax Withholdings for Marital Status \u201cSingle\u201d and Pay Period Weekly. Calculations made by Hand and with MAX and VLOOKUP.
\n6.
\n7. (17:05) Use Formula Evaluator to verify that VLOOKUP Formula is working correctly
\n8. (18:38) Video Example 2: Calculate Federal Income Tax Withholdings for Marital Status \u201cMarried\u201d and Pay Period Weekly. Calculations made by Hand and with MAX and VLOOKUP.
\n9. (21:36) Video Example 3: Calculate Federal Income Tax Withholdings for Marital Status \u201cSingle\u201d and Pay Period Weekly for an Entire Payroll Table. Calculations made with MAX and VLOOKUP.
\n10. (27:33) Video Example 4: Calculate Federal Income Tax Withholdings for Marital Status \u201cMarried\u201d 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.
\n11. (28:28) Summary<\/p>\n
Next Video: 36 Excel & Business Math<\/p>\n