Completed
) Formula for: Total Gross Pay, using the Functions: SUM
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Comprehensive Excel Payroll Example - SUMIFS, MROUND, MOD, VLOOKUP & More
Automatically move to the next video in the Classroom when playback concludes
- 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
