Excel & Business Math 34: MEDIAN Function for FICA Social Security & Medicare Payroll Deductions
Download Start Excel File: http://ift.tt/2t0QtAv
Download pdf Notes: http://ift.tt/2Cr8I67
Entire Class Web Site: http://ift.tt/2BjafuY
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