Completed
) Use Formula Evaluator to verify that VLOOKUP Formula is working correctly
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel and Business Math - VLOOKUP and MAX Functions for Percentage Method Federal Income Tax Deduction
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Federal Income Tax Withholdings Deducted from Employees Paychecks
- 3 ) IRS web site with 2018 Percentage Method Tax Tables.
- 4 ) 2018 Percentage Method Federal Income Tax Withholding Tables in Excel
- 5 ) 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 ) Use Formula Evaluator to verify that VLOOKUP Formula is working correctly
- 7 ) 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.
- 8 ) 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.
- 9 ) 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 …
- 10 ) Summary
