This course teaches learners how to create a comprehensive payroll table solution in Excel, covering topics such as calculating hours worked, regular and overtime hours, gross pay, deductions like Social Security and Medicare, and net pay. The course focuses on using Excel functions like SUMIFS, MOD, MROUND, VLOOKUP, and more. The teaching method involves a step-by-step tutorial demonstrated in a 29-minute video. This course is intended for individuals interested in mastering Excel for business math applications, particularly in the context of payroll calculations.
Overview
Syllabus
) 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.
Taught by
ExcelIsFun
Related Courses
-
Excel & Business Math - MEDIAN Function for FICA Social Security & Medicare Payroll Deductions
4.7 -
Excel and Business Math - VLOOKUP and MAX Functions for Percentage Method Federal Income Tax Deduction
-
Excel & Business Math - VLOOKUP Function for Incentive Pay: Commissions & Piecework
-
Create Excel Invoices, Data Validation Drop-Down, VLOOKUP & IF Functions
-
Ctrl + Shift + Enter - Excel Array Formulas - SUMPRODUCT Function - Including Timing
-
Excel for Accountants - VLOOKUP & PivotTables - Complete Lessons from Basic to Advanced
