Completed
) 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.
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
