YoVDO

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

Offered By: ExcelIsFun via YouTube

Tags

Microsoft Excel Courses Payroll Management Courses VLOOKUP Function Courses Business Math Courses

Course Description

Overview

Learn to use VLOOKUP and MAX functions in Excel to calculate Federal Income Tax Withholding deductions in this 30-minute video tutorial. Explore the 2018 Percentage Method Tax Tables and apply them to various scenarios, including single and married status with weekly pay periods. Practice calculating deductions by hand and with Excel formulas for individual cases and entire payroll tables. Utilize the Formula Evaluator to verify VLOOKUP accuracy and discover how to efficiently copy formulas to new templates. Gain practical skills for managing payroll calculations in Excel, taught by Michael Girvin from Highline College.

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

Related Courses

Microsoft Excel بحث و ترتيب وتصفية البيانات فى
Coursera Project Network via Coursera
Analyzing Data in Spreadsheets
DataCamp
Usar Funciones y Fórmulas Básicas en Excel
Coursera Project Network via Coursera
Introduction to Data Analysis using Microsoft Excel
Coursera Project Network via Coursera
Working with Real-Time Data in Excel
LinkedIn Learning