Excel & Business Math 34: MEDIAN Function for FICA Social Security & Medicare Payroll Deductions
Download Start Excel File: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/Content/05BankingPayroll/ExcelBusinessMathVideo34SocialSecurityDeduction.xlsx
Download pdf Notes: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/Content/05BankingPayroll/ExcelBusinessMathVideo34SocialSecurityDeduction.pdf
Entire Class Web Site: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/135/135NoTextBookClass.htm
In this video learn how to
Excel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College / Mike Girvin at excelisfun Channel at YouTube Channel.
Topics in Video:
1. (00:01) Introduction
2. (01:28) FICA Payroll Social Security & Medicare Tax Deductions
3. (04:50) Calculating FICA Deductions and Net Pay Long Hand, all three situations
4. (17:32) Learning How to Make a Tax Calculation When There is a Hurdle That Changes The Tax Rate
5. (18:13) Using MEDIAN Function to Deal With Tax Hurdles
6. (31:17) Payroll Employee Table Example for Tax Deductions and Net Pay
7. (37:44) Summary
Next Video: 35 Excel & Business Math