Главная
Study mode:
on
1
) Introduction
2
) Formula for: Hours Worked, using the Functions: SUM, MOD, MROUND
3
) Formula for: Total Hours, using the Function: SUMIFS
4
) Formula for: Regular Hours, using the Function: IF
5
) Formula for: Overtime Hours
6
) Formula for: Regular Gross Pay, using the Function: ROUND
7
) Formula for: Overtime Gross Pay, using the Functions: ROUND
8
) Formula for: Total Gross Pay, using the Functions: SUM
9
) Hide Columns
10
) Formula for: Cumulative Gross Pay After This Paycheck
11
) Formula for: Social Security Deduction, using the Functions: MEDIAN, ROUND
12
) Formula for: Medicare Deduction @ 1.45%, using the Functions: MEDIAN, ROUND
13
) Formula for: Medicare Deduction @ 2.35%, using the Functions: MEDIAN, ROUND
14
) Formula for: Taxable Pay, using the Function: MAX
15
) Formula for: Federal Income Tax Withholding, using the Functions: VLOOKUP, ROUND
16
) Formula for: Total Deductions
17
) Formula for: Net Pay
18
) Summary
Description:
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.

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

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Accounting #Payroll Accounting #Human Resources #Payroll Management #Data Science #Data Analysis #Spreadsheets #VLOOKUP Function #Business Math
1 of 18

) Introduction