Comprehensive Excel Payroll Example - SUMIFS, MROUND, MOD, VLOOKUP & More

Dive into a comprehensive 29-minute video tutorial on creating a complete payroll table solution in Excel. Master essential functions like SUMIFS, MROUND, MOD, and VLOOKUP while learning to calculate hours worked, gross pay, deductions, and net pay. Follow along with downloadable start files and PDF notes as you explore formulas for regular and overtime hours, Social Security and Medicare deductions, federal income tax withholding, and more. Perfect for business math students and professionals looking to enhance their Excel skills in payroll management.

) Introduction.
) Formula for: Hours Worked, using the Functions: SUM, MOD, MROUND.
) Formula for: Total Hours, using the Function: SUMIFS.
) Formula for: Regular Hours, using the Function: IF.
) Formula for: Overtime Hours.
) Formula for: Regular Gross Pay, using the Function: ROUND.
) Formula for: Overtime Gross Pay, using the Functions: ROUND.
) Formula for: Total Gross Pay, using the Functions: SUM.
) Hide Columns.
) Formula for: Cumulative Gross Pay After This Paycheck.
) Formula for: Social Security Deduction, using the Functions: MEDIAN, ROUND.
) Formula for: Medicare Deduction @ 1.45%, using the Functions: MEDIAN, ROUND.
) Formula for: Medicare Deduction @ 2.35%, using the Functions: MEDIAN, ROUND.
) Formula for: Taxable Pay, using the Function: MAX.
) Formula for: Federal Income Tax Withholding, using the Functions: VLOOKUP, ROUND.
) Formula for: Total Deductions.
) Formula for: Net Pay.
) Summary.