BloomTech’s Downfall: A Long Time Coming

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel and Business Math - VLOOKUP and MAX Functions for Percentage Method Federal Income Tax Deduction

ExcelIsFun via YouTube

Start learning Write review

Overview

Learn how to use VLOOKUP & MAX Functions to calculate Federal Income Tax Withholdings for different marital statuses and pay periods. The course covers creating deduction formulas, verifying formula accuracy, and applying calculations to entire payroll tables. The teaching method involves practical examples and demonstrations using Excel. This course is intended for individuals interested in mastering Excel functions for business math applications, particularly in the context of federal income tax deductions.

Syllabus

) Introduction.
) Federal Income Tax Withholdings Deducted from Employees Paychecks.
) IRS web site with 2018 Percentage Method Tax Tables..
) 2018 Percentage Method Federal Income Tax Withholding Tables in Excel.
) 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..
) Use Formula Evaluator to verify that VLOOKUP Formula is working correctly.
) 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..
) 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..
) 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..
) Summary.

Taught by

ExcelIsFun

Reviews

Start your review of Excel and Business Math - VLOOKUP and MAX Functions for Percentage Method Federal Income Tax Deduction

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.