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

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

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.