Microsoft Excel 01 Payroll Part 1 - How to enter data and create formulas

  Рет қаралды 1,436,440

Programming w/ Professor Sluiter

Programming w/ Professor Sluiter

Күн бұрын

Пікірлер: 248
@gaynelleziccardi3269
@gaynelleziccardi3269 2 жыл бұрын
Y’all can’t guess how it was get my loan from the bank, they needed both my Bank and Earning statements, I had to submit them two months back cause I filed for a loan then a recommendation about Stray Admin came and I gave it a try, he’s good in making statements too for sure, can attest cause I got the loan..
@simpleexcelexamples9619
@simpleexcelexamples9619 2 жыл бұрын
Love the content of this video and your way of teaching! Thanks for the video which gave me inspiration for my own classes (I give basic Excel training to students) 😊
@ericajons9861
@ericajons9861 2 жыл бұрын
Came back from the dealership the other day and they requested I bring my pay stubs that’s shows I really earn the amount I claimed cause of the SRT I was tryna purchase, shit got intense fast cause i had to submit them as early AF😂😭, got really confused till I saw the recommendations from these video’s comment sessions about Stray Administration, with trust I looked him up and now I’m pushin 🅿️ all day in my new weep..
@lesliehanna9079
@lesliehanna9079 7 жыл бұрын
who idiots thumb this video down.... THIS WAS AWESOME & very helpful... if your not a teacher go be one... thanks a lot 😘
@andyrattan7796
@andyrattan7796 7 жыл бұрын
laffy land its the ones without knowledge... The complete ignorance
@atiashah4538
@atiashah4538 9 жыл бұрын
I have to say THANK YOU. I have had excel lessons in the past and I didn't understand them. You have made it easy to understand and now I get it.
@21_angngocsiluan95
@21_angngocsiluan95 3 жыл бұрын
lllllllllllllllllllllll lllllllllll l lllllllllllllll
@brandsplanet4381
@brandsplanet4381 8 жыл бұрын
This was so easy. Yo ma man nigga !
@janikamahmud9121
@janikamahmud9121 7 жыл бұрын
Straight forward... You did a great help. God Bless.
@elviradagami5184
@elviradagami5184 2 жыл бұрын
thank you sir, i have learned something from your tutorial..you explain it well with a clear voice/sound. Very effective.
@user-fn5gr1re4w
@user-fn5gr1re4w 2 жыл бұрын
I'm not a payroll person or good at math but this is amazing. I have such bad anxiety and scared to get a job like this and screw it up and get fired
@djhazan6139
@djhazan6139 7 жыл бұрын
you really are the best lecturer, easy teaching , easy way to get the point for the student. thank you sir
@geraldinegari1921
@geraldinegari1921 5 жыл бұрын
I appreciate this video was so easy and I did learned a lot!
@lucondafenderson6222
@lucondafenderson6222 4 жыл бұрын
I like it and I have learned from it
@lalithahegde9468
@lalithahegde9468 5 жыл бұрын
And those 153 dislikes for this beautiful information are pubg players??
@nelsononyema4621
@nelsononyema4621 5 жыл бұрын
Thanks a lot at least I can now smile while working on excel.
@aarnmullard9254
@aarnmullard9254 7 жыл бұрын
Thanks mate, was a really helpful and pain free tutorial! Brilliant
@ismailgasimov6247
@ismailgasimov6247 8 жыл бұрын
thanks billions, You are the great presenter I have even seen. What a method you have used. Take care . Thanks a lott
@jejester02memester43
@jejester02memester43 5 жыл бұрын
Sir Rodnel, Good morning. I just want to reach out you and the accounting department for all my salary dispute. Here is the breakdown of my salary disputes: Payslip for April 15 (March 22 to April 4): Attendance March 30 (Saturday Overtime) 8 hours vs Payslip NO Overtime = Dispute by 8 hours overtime. Payslip for May 15 (April 23 to May 7): Attendance May 2 (1 hour OT), May 3 (2 hours OT), May 6 (2 hours OT) and May 7 (1hout OT) = 6 hours OT vs Payslip 3 hours OT= Dispute by 3 hours overtime. Payslip for May 31 ( May 8 to May 23) Attendance May 8 (1 hour OT), May 9 (1 hour OT), May 10 ( 2 hours OT), May 13 ( SH 2hours OT), May 14 (1 hour OT), May 15 (1 hour OT), May 16 (1 hour OT), May 17 (1 hour OT), May 21 (1 hour OT) and May 22 (1 hour OT) = 10hours REG OT and 2 hours SH OT vs Payslip 10 hours REG OT = Dispute by SH 2 hours OT Payslip for June 30 (June 6 to June 20) Attendance June 6 (1 hour OT), June 7 (1 hour OT) and June 10 (1 hour OT) = 3 hours OT vs Payslip 1 hour OT = Dispute by 2 hours OT. For the reference above, I have an overtime dispute of 13 hours Regular OT and 2 hours Special Holiday OT. Hope that all my dispute will be immediately resolved. Thank you so much Sir Rodnel. Regards, John Meir D. Conchada
@johncarlomabiling6855
@johncarlomabiling6855 5 жыл бұрын
Thanks a lot for this beautiful video..it helps me a lot..thank u so much sir..for the very good demonstration.
@mauriceelisha7999
@mauriceelisha7999 Ай бұрын
What a fuck,,the best I came across,,, needed some refreshments for a job Interview on using Excel for staff salary payments,,with this am set
@Tunogkalyeah
@Tunogkalyeah 4 жыл бұрын
Excel always present through any office transactions. My pleasure to also share my skills.
@nehau4816
@nehau4816 5 жыл бұрын
Thanks a lot, your voice is very clear & easy to understand
@aprilthomas5870
@aprilthomas5870 2 жыл бұрын
Oh my God I appreciate you so much.
@069molly7
@069molly7 5 жыл бұрын
In just seconds I got it thx bro🤟🏼
@itsdigitalisss
@itsdigitalisss 5 жыл бұрын
I appreciate this video so much it was very easy to follow and I really learned a lot!
@chandrasekar4668
@chandrasekar4668 5 жыл бұрын
Oh really
@hubertsanjo376
@hubertsanjo376 2 жыл бұрын
hi love you you look humble
@j.maginnenu6291
@j.maginnenu6291 4 жыл бұрын
battlewho?? you use GAMES YOU PLAY to speak to people who want to learn something that is NOT your stupid game??? This is ACCOUNTING!!
@KGwede
@KGwede Жыл бұрын
hi , love everything about the video , is there a way i can download your car inventory , i want to try it myself.
@zoejackson3801
@zoejackson3801 6 ай бұрын
This was Amazing and very easy to understand thanks!🙏
@stevechua8642
@stevechua8642 4 жыл бұрын
good pm pasend naman po ako ng mga formula ng computaion at staka yung sa payroll din po ito email ko po steveychua@gmail.com SALAMAT PO!!
@dayahomar6590
@dayahomar6590 6 жыл бұрын
Thanks you sir. U made it clear, but i noticed that u wroye house instead hours.
@ImranAhmad-ep4qp
@ImranAhmad-ep4qp 4 жыл бұрын
How to Group, Ungroup, Subtotal in MS Excel | Excel में Group, Ungroup, Subtotal का उपयोग कैसे करें? kzbin.info/www/bejne/bqOUlo1-n7mDnrM
@therealsaint3075
@therealsaint3075 2 жыл бұрын
I needed a car loan from a car dealership and I needed to bring in my w2s last week and that got my stressed out asf till I came across some great comments about deelscafe💯💯
@ampleleapcognitiontechnolo5899
@ampleleapcognitiontechnolo5899 3 жыл бұрын
Video was informative | Integrated HR Solutions for START UP'S & MSME’S (Payroll, PF - ESIC, Compliance) - Ample Leap
@jkb1904
@jkb1904 8 ай бұрын
Thank you very much
@unisakamara6234
@unisakamara6234 4 жыл бұрын
The video is nice the steps are cleared but the writing is not so it's have to be zoom for proper vision with all the data entry I'm not seeing any thing in the spreadsheet.
@JessicaRamirez-jd8ze
@JessicaRamirez-jd8ze Жыл бұрын
Learned so much from this video. Thank you.
@abuayubanssary3951
@abuayubanssary3951 6 жыл бұрын
nice and simple. this is how youtube tutorials should be
@sherryleboeuf6238
@sherryleboeuf6238 7 жыл бұрын
I AM USING ONLINE EXCEL AND SEEM TO BE HAVING TROUBLE WITH CALCULATING HOURS TO DECIMAL FORMAT TO PAY. I S THERE ANOTHER WAY I CAN CALCULATE . I HAVE TRIED 13.47*24 AND AS SOON AS THE HOURS ARE OVER 24 THE NUMBER CALCULATION DOES NOT WORK I GET #VALUE!...
@hannynero6139
@hannynero6139 4 жыл бұрын
You are good instructor
@alfredgomez7701
@alfredgomez7701 2 жыл бұрын
hi sir how to put peso sign in a cell if formula is apply ?
@klaingarjosue
@klaingarjosue 2 жыл бұрын
Flawless teaching, I subscribed and like the video. This is a great teacher
@mduduzimavuso2051
@mduduzimavuso2051 2 жыл бұрын
me too
@oanhluong7051
@oanhluong7051 2 жыл бұрын
Also, how do we track back pay for our student employees if we missed their semi payroll? Thanks
@oanhluong7051
@oanhluong7051 2 жыл бұрын
Could you please show us on tr excel how to calculate minimum wage increase? Thanks
@ameliaa548
@ameliaa548 5 жыл бұрын
the 'house worked' is giving me anxiety
@jamekawilliams365
@jamekawilliams365 5 жыл бұрын
Same! 🤣
@channeloffreedomrevivalmin3276
@channeloffreedomrevivalmin3276 2 жыл бұрын
Helo Sir, is it okay to ask anytime about anything to do especially with excel? For example payroll,loan amortisation,appraisal,tally and quick books? I'd love to be helped especially with these videos in series, am in my last univ semester..thank you so much..its my first time here but I love how you teach so how best Can I follow to keep track?
@berthasherman5212
@berthasherman5212 5 жыл бұрын
Excellent video. Thank you for an excellent step by step guide.
@enriquemejia5861
@enriquemejia5861 2 жыл бұрын
Do you recommend making a new one everyweek? Or can I just keep adding to this?
@saad9413
@saad9413 4 жыл бұрын
Learnt a lot, super easy way of describing things. Thanx a lot, keep making such good videos 👍
@sadakshaik1797
@sadakshaik1797 2 жыл бұрын
Thank you so much I will do US payroll... I hope this will helpful for me
@cheahmunhoong
@cheahmunhoong 2 жыл бұрын
讲解非常清楚,非常感谢
@BitcoinEvangelist
@BitcoinEvangelist 4 жыл бұрын
Is this going to count against our grade? just kidding. Thank you for the video! Huge help.
@gv4878
@gv4878 2 жыл бұрын
Can I use the calculator instead?
@user-fn5gr1re4w
@user-fn5gr1re4w 2 жыл бұрын
Is this still beign uses for 2022?
@aaliyahhernandez223
@aaliyahhernandez223 3 жыл бұрын
I wish you could teach me everything in life. Straight to the point with excellent communication lol
@mukasasalimu1926
@mukasasalimu1926 3 жыл бұрын
hih
@nuralam5188
@nuralam5188 5 жыл бұрын
You loking myd a me
@rishikapandey560
@rishikapandey560 2 жыл бұрын
thanks for making this video this helped me a lot in doing my holiday homework
@amL031797
@amL031797 3 жыл бұрын
what about hourly rate with decimals it doesnt add up
@kirbaragu1390
@kirbaragu1390 5 жыл бұрын
hey, I could not get the average for all the three columns.. it shows #NAME? .. What should I do?? TQ
@praseedav287
@praseedav287 5 жыл бұрын
Remove equations
@roxanay6180
@roxanay6180 2 жыл бұрын
LOVE YOUR VIDEO THANKS 🙂
@JamPacked-
@JamPacked- 4 жыл бұрын
Great Help.....just joined you👍
@ethancoursen2982
@ethancoursen2982 2 жыл бұрын
nghe mà ưng hết cả tai , đức phúc cover mãi đỉnh
@omarbarrett4904
@omarbarrett4904 7 жыл бұрын
How do I get a Weekly wage percentage
@gishinternationalelementar7002
@gishinternationalelementar7002 5 жыл бұрын
Thanks!💖🙏 Have learn a lot and understand God bless U luv💖
@birdeye1990
@birdeye1990 4 жыл бұрын
very good, Sir. God bless you very humble. and expalin very well
@danielgetahun6316
@danielgetahun6316 4 жыл бұрын
I appreciate this video very important for Accountant.tnxs
@tonyperez7907
@tonyperez7907 2 жыл бұрын
Thanks bro... good video
@dawarsak1928
@dawarsak1928 2 жыл бұрын
its a good video for payroll
@yobu9150
@yobu9150 4 жыл бұрын
Love your videos. Can you please make another video to keep tracks of vacation pay for employees. Thanks
@kinzaterish8587
@kinzaterish8587 6 жыл бұрын
you just explained it awesomely, thanks a million 👍👍👏👏
@gatmachwuor-ro8yt
@gatmachwuor-ro8yt 10 ай бұрын
That's excellent payroll
@elcomelondekcmo674
@elcomelondekcmo674 2 жыл бұрын
Muy buen contenido hay más que puedas enseñar
@sweetsaros6680
@sweetsaros6680 3 жыл бұрын
Great video ...and very helpfull for me👍
@MrAtaraxios
@MrAtaraxios 4 жыл бұрын
Overtime and double time should be done separately?
@iconic-gamer9665
@iconic-gamer9665 6 жыл бұрын
Who would search this up intentionally?
@nuralam5188
@nuralam5188 5 жыл бұрын
New iPhone all software without I’m legal
@DonEdwardoo
@DonEdwardoo 3 жыл бұрын
Thanks mate
@rishmarishma9435
@rishmarishma9435 4 жыл бұрын
Very descriptive and informative video thank you.
@happyfamilylifescreations
@happyfamilylifescreations 7 жыл бұрын
i loved ur teachin method..so i will be continuing more on this.
@andrecollins4027
@andrecollins4027 4 жыл бұрын
Yeah I'm sure it is not too much 😂😅😅😅😅 what up with you
@andrecollins4027
@andrecollins4027 4 жыл бұрын
Andre collins
@dandikridi705
@dandikridi705 2 жыл бұрын
This video really helps with my startup
@nuralam5188
@nuralam5188 5 жыл бұрын
Looking my iPhone please please no help looking 1my phone
@jaysinghkushwaha4461
@jaysinghkushwaha4461 5 жыл бұрын
mera CTC 500000 h to meri net salary kitni bane hi as par government rules plz sir
@kabuciriyawakeivatuvaivua5158
@kabuciriyawakeivatuvaivua5158 2 жыл бұрын
Love this thank you and god bless you sir 🙌
@suziewilliams1576
@suziewilliams1576 2 жыл бұрын
Thank you so much this really help🥰
@sasukekunuchiha3292
@sasukekunuchiha3292 4 жыл бұрын
hope to see all the keys you press on ur keyboard on the screen .
@elisbethshipanga1809
@elisbethshipanga1809 4 жыл бұрын
I am greatfull for this video,im going to learn alot from this video.God bless you
@shadsluiter
@shadsluiter 4 жыл бұрын
You are so welcome
@gmarod6099
@gmarod6099 2 жыл бұрын
Thank you, Sir!
@breanamittelstrasser1385
@breanamittelstrasser1385 6 жыл бұрын
How would you go about calculating overtime pay?
@shadsluiter
@shadsluiter 6 жыл бұрын
Watch the 2nd and 3rd video in the series. OT pay is calculated.
@mpuminombembe6363
@mpuminombembe6363 4 жыл бұрын
come up with a rate you will use to accommodate the over time, then condition your cells to cater for the over time
@applemelon1546
@applemelon1546 5 жыл бұрын
Dis makes working with excel sooo easy...thanks alot
@alemarfernandez6931
@alemarfernandez6931 3 жыл бұрын
Very well explained, thank you so much sir.
@shadsluiter
@shadsluiter 3 жыл бұрын
So nice of you. I hope you find the rest of the Excel tutorials here as useful.
@franklineochieng6236
@franklineochieng6236 4 жыл бұрын
Thnx indeed this training is the one I do need for my business.
@abduljabbar-zk9oz
@abduljabbar-zk9oz 4 жыл бұрын
very simple and easy to learn..tnx a lot...
@josesagastume329
@josesagastume329 5 жыл бұрын
Please, with taxes, medicare, ss etc
@merscraft
@merscraft 4 жыл бұрын
Thanks for sharing
@caligirl8904
@caligirl8904 4 жыл бұрын
How about commissions pay? How would I do that for my employees
@casandrarodriguez960
@casandrarodriguez960 2 жыл бұрын
This was awesome thank you so much
@shivarubini4826
@shivarubini4826 4 жыл бұрын
Thank u I learned excel in more detail..
@muhammadcham9595
@muhammadcham9595 4 жыл бұрын
This is the perfect opportunity for me thanks very much
@shadsluiter
@shadsluiter 4 жыл бұрын
You're welcome 😊
@WalterGarciaJrIII
@WalterGarciaJrIII 4 жыл бұрын
Thanks a lot
@la3380
@la3380 3 жыл бұрын
Thank you 🙏
@kisses-xb3uq
@kisses-xb3uq 3 жыл бұрын
I really appreciate this I did learn alot as well ‼️👏
@riscab7787
@riscab7787 2 жыл бұрын
Very helpful
@sirenenoire4091
@sirenenoire4091 2 жыл бұрын
Thank you!
Microsoft Excel 02 Payroll Part 2 If formulas and functions
6:16
Programming w/ Professor Sluiter
Рет қаралды 263 М.
Крутой фокус + секрет! #shorts
00:10
Роман Magic
Рет қаралды 24 МЛН
The Payroll Process - How to Payroll #payroll #paye
10:30
BookkeepingMaster
Рет қаралды 117 М.
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 660 М.
The Basics of Payroll for UK Business Owners
10:00
Annette Ferguson - Accountant + Profit Specialist
Рет қаралды 6 М.
Excel for Beginners - The Complete Course
54:55
Technology for Teachers and Students
Рет қаралды 6 МЛН
Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)
14:48
Excel Campus - Jon
Рет қаралды 14 МЛН
Top 10 Most Important Excel Formulas - Made Easy!
27:19
The Organic Chemistry Tutor
Рет қаралды 7 МЛН
Interactive Excel Dashboards & ONE CLICK Update!
52:26
MyOnlineTrainingHub
Рет қаралды 10 МЛН
Microsoft Excel 03 Payroll Part 3 Relative vs Absolute References
19:13
Programming w/ Professor Sluiter
Рет қаралды 109 М.
Payroll in Excel
8:03
Math Guy Zero
Рет қаралды 121 М.
Spreadsheets #1: Introduction
13:27
ExplainingComputers
Рет қаралды 1 МЛН