Microsoft Excel 03 Payroll Part 3 Relative vs Absolute References

Excel Lesson #3 in StudyOffice.org series. See studycoding.org for all tutorials by Shad Sluiter.

[@carmenmontero1894]

Thank you Professor! May the Lord continues blessing you and family.

[@ThePrado361]

I just want to start by saying, THANK YOU!! This is so informative, and you make it so easy to learn.

[@paulakwayena3815]

I just love your teachings . you are very clear with your teachings. thank you God bless you more

[@magdelinrosario8098]

You are simply the best!!!!!! Thank you so much!

[@cyndimahne3411]

love this and thanks - could you please continue with how to add cells to figure taxes and social security with-holdings?

[@taniablanco6333]

Impresionada con la buena calidad de las clases, ojala todos los cursos por internet que, incluso se pagan fueran tan buenos, y tan explicitos. gracias.

[@turtleshell0]

thank u for these they're honestly very helpful

[@dulanxing]

Thank you for the tutorials!

[@talhashah3986]

ThankYou so much Professor!

[@HL-ok7dl]

Could You upload with MedcareTax,social tax, income Tax...

[@miamolydie3417]

Oh, i found the mistake. I inserted the empty columns before Jan 1, such that the figures didn;t correspond to Jan 8. So I deleted the figures and repeated the if formula, then copied and pasted, and it worked!

[@jkb1904]

Thank you very much

[@sloke7806]

Thank you, you're a great help

[@henrynnonyelu9191]

Nice job. Please keep it up. God bless you more.

[@ahmedmuhammed643]

First of all I 'd thank you for your great effort, but I'd be grateful if you could upload the excel sheet that you're working on

[@KihwanKim-f8t]

Thank you can you show us how to do paycheck for each employees showing tax and medicare and social security

[@arielledenisse2426]

Thank you. this helps a lot!!!!

[@renzoski-LA]

Excellent class. I just have a question regarding the overtime. for the first person Jon kern; he makes $15.90 per hour, but for the overtime you are paying him $7.95. If this is an overtime hour, the amount should be higher, right? the formula you use has 0.5*... My question is if the number should be 1.5 instead of 0.5? Thank you

[@shadsluiter]

The overtime bonus is 50% of his regular pay. This is added to his regular hourly pay.

[@joshuasackey5059]

Great job! Just that the video focus isn’t sharp; most of the characters in your worksheet are blurry.

[@panthazin9353]

Thank you for your videos. Those are very clear and easy to follow, but i have one concern here. the sample data are up to Jan 29. how about to calculate until Jan 31? I suppose =D4+7 formula is inapplicable in that case. Please explain me.

[@mukhtyarahmad7377]

Thanks for Uploading such informative video

[@miamolydie3417]

Hello, thanks so much for your clear lessons. However, I wonder why when I copy and paste the IF formular of over time hours for Jan 1 to Jan 8, all the figures are 0. they don't change according to the hour worked. Is there any particular configuration? Thanks

[@robertocheru]

this is great,thank you

[@tionenji1957]

Very helpful

[@MzDanielleJoy]

Thank you!!!!!!

[@mahared7701]

Thank you!

[@Nobodysvlog]

Oh my God, it's getting difficult!!!! Lesson 1 and 2, I can take those but Lesson 3 is oh no! I want to have different assignments of this everyday for me to really absorb all.

[@zariagenevieve4741]

I said the same thing. He completely lost me halfway through Part 3.

[@jeffreyvisser8628]

@@zariagenevieve4741 I tried it as well. I could have add those months and hour payments, but I couldn't do it all at ones. I did it 1 week to the next week till week 5. But the end, I couldn't do what he did

[@alchemi5150]

Do you have a sample of DTR computation for lates and undertime in shifting schedule

[@KoangKenGach]

So amazing

[@kellyoku]

Great job!

[@shadsluiter]

Thanks for the visit

[@alchemi5150]

We have 5 shifts per day and an increment of 10 minutes each shift.

[@jimmyandmaria3551]

How can I get payslips from this

[@tonyatrammell4574]

thank you for your help

[@edellos9567]

could you help me sir? why is it when i tried to do the formula for dates its repeating itself like june 1 ..E5+7

[@krishnaviswanathan6283]

Thank you sir

[@seanmckenna8721]

who the hell searches this up intentionally!!!!!

[@shadsluiter]

People who use Excel for their job. Relative and absolute references are pretty common way to make formulas but difficult to understand the first time you see them.

[@Manell90210]

me

[@AlamBarzakh99]

I did and its been really helpfull