@@chinodecamisa9662 yeah, last year I was taking a course on utilizing Microsoft office, including excel. Not on my own volition, but as a prerequisite for my degree plan. While it was a very informative class, it was definitely all stuff I could've learned for free
Excellent very well done, for small business once they learn to print cheques they don't need to buy payroll software. I use excel for payroll I love it! I think once people truly understand how delightful and easy excel is to use for payroll ie. in small companies there will be far less demand for compensation and payroll software. Our company has less then 20 people, I can just add whatever I need.
Thank You So much for your feedback. We are working on the course in two sections Ms Excel for Beginners and Advanced Ms excel. Hopefully we will start both simultaneously soon !!!
Gross Pay = (pay per hour)(total hours worked) + (overtime pay per hour)(total overtime hours) Income Tax = Gross Pay * income tax rate (%) Net Pay = Gross Pay - (Gross Pay * income tax rate %) - other deductibles Pay: Hourly wage or salary rate. Total Hours Worked: Total regular hours worked in a given period. Overtime: Additional pay rate for hours worked beyond regular hours, typically higher than regular pay. Total Overtime Hours: The number of hours worked beyond the regular work hours. Gross Pay: Total earnings before deductions (includes regular and overtime pay). Income Tax: Percentage of Gross Pay deducted for taxes. Other Deductibles: Additional deductions like insurance, retirement contributions, etc. Net Pay: Final earnings after all deductions (Income Tax and Other Deductibles).
Dear Sir, We have used the usual time for routine hours and then over time. You can find the format as well about how we can set the over time to work on it. Hopefully it will works
You could make two pay columns: Weekly Pay Rate and Weekend Pay Rate, then calculate the cost per number of hours for each. It would be very similar to how he split the overtime value here. The overtime is just an additional column to calculate hours worked at a different pay rate. The calculation he's running is to figure hours worked at a regular pay rate + hours worked at an overtime rate. So, to make this straightforward: If I work 2 hours at a regular pay rate of $10 per hour, I have made $20, right? If I work 2 more hours at an overtime pay rate (time and a half or 1.5x) of $15.00, I will have made $30 from the overtime that I have worked, right? Add those two together (20+30) and you get $50.00. That formula looks like this: (2 x 10) + (2 x 15) = $50. You solve in PEMDAS fashion. I hope this answers all of the questions you had. It's 6 months later so you may have already resolved the question for yourself, I'm sure. But just in case. :)
Thank You for your comment. We have used the general formula in order to make it simple. We can add mutiple columns like medical expense or allowances to make it more realistic. Thank You.
I love that with the power of tutorials, one does not need a college course to learn how to construct spreadsheets
Thank You So Much !!!
@@geniusworldteam😊
Duh really 😮
@@chinodecamisa9662 yeah, last year I was taking a course on utilizing Microsoft office, including excel. Not on my own volition, but as a prerequisite for my degree plan. While it was a very informative class, it was definitely all stuff I could've learned for free
Excellent very well done, for small business once they learn to print cheques they don't need to buy payroll software. I use excel for payroll I love it! I think once people truly understand how delightful and easy excel is to use for payroll ie. in small companies there will be far less demand for compensation and payroll software. Our company has less then 20 people, I can just add whatever I need.
Thank You so much !!!!
Excellent and straight to the point. I appreciate how simplified your video is.
Thank you so much for your kind appreciation
Great example in an excel spreadsheet! it made it easier to understand.
Thank you so much!!!
Thank you for this … great video am planning on trying a new job with data entry payroll this help me a lot help me to understand the basics
Thank you so much !!!
Very intelligently taught.
Thank you very much for sharing🙏 I’m starting my small business and this will help me alot
Your welcome & Best wishes for your business !!!!
11
I really appreciated the video because it boost my understanding about salaries
Thank you so much
This is one of the simplest video ever
Thank you so much !!!
Very simple to understand
Thank You !!!!
Excellent, Thank you for sharing.
Thank you !!!
I will follow your channel
Thank You so much for your kind words !!!
Super sir...thank you so much 🎉🎉🎉🎉
Your welcome
Thank you. Learned a lot. :)
Thank you and God Bless
Thank you too and your welcome !!
Thank you, it was very clear ♥
Your welcome
excellent and accurate job
Thank you
Thank you so much this is very simple and helpful 🙏🙏
Your welcome!!!
Please can you do a video of excel for beginners
Thank You So much for your feedback.
We are working on the course in two sections Ms Excel for Beginners and Advanced Ms excel.
Hopefully we will start both simultaneously soon !!!
Thnk you for sharing such an informative video
Your Welcome !!!
Very smart thank you ❤
Your Welcome !!!!
Simple and straightforward, 😊 🎉
Thank you
Great and very helpful
Thank You !!!!
great video
Thank you
I love you 💗 thank you
Your welcome!!!
Simplified very well
Thank you for your feed back !!
Appreciate it.
Thank You !!!!!
Thanks very much 😊
Your welcome !!!
Neat work
Thank You !!!
Gross Pay = (pay per hour)(total hours worked) + (overtime pay per hour)(total overtime hours)
Income Tax = Gross Pay * income tax rate (%)
Net Pay = Gross Pay - (Gross Pay * income tax rate %) - other deductibles
Pay: Hourly wage or salary rate.
Total Hours Worked: Total regular hours worked in a given period.
Overtime: Additional pay rate for hours worked beyond regular hours, typically higher than regular pay.
Total Overtime Hours: The number of hours worked beyond the regular work hours.
Gross Pay: Total earnings before deductions (includes regular and overtime pay).
Income Tax: Percentage of Gross Pay deducted for taxes.
Other Deductibles: Additional deductions like insurance, retirement contributions, etc.
Net Pay: Final earnings after all deductions (Income Tax and Other Deductibles).
Is this the standard computation in all the companies??
We have used the basic technique to explain the way. Definitely organizations use this technique to solve multiple criteria
Thanks so very much
Your Welcome !!!!
I like this. Will be using it in my payroll journey
Thank you for your feedback!!!
Yes I use excel for our small company too, works well. Just added a cheque printing template.
Bravo
This is very simple
Thank you for your feedback
@@geniusworldteam I will like to talk to u privately
Thanks
Your welcome!!!
I shared it
Thank you so much !!!
How did you get the other deductibles?
We have used the main elements that usually found in any organisation !!!!
How can you get the other deduction
Thank you for your comment.
I have simply create columns as per random data. You can use deductions as per your own requirements.
🎉
Thank You
Thanks for sharing. Is there a template for public sector payroll?
Thank you for your interest.
We have made it by using the simple technique but we will make the payroll on public sector soon.
Yes for every
Thank you
How about the ones that have different hourly for the weekday and weekends? I didn't understand when you got to the overtime
Dear Sir,
We have used the usual time for routine hours and then over time. You can find the format as well about how we can set the over time to work on it.
Hopefully it will works
You could make two pay columns: Weekly Pay Rate and Weekend Pay Rate, then calculate the cost per number of hours for each. It would be very similar to how he split the overtime value here. The overtime is just an additional column to calculate hours worked at a different pay rate. The calculation he's running is to figure hours worked at a regular pay rate + hours worked at an overtime rate. So, to make this straightforward: If I work 2 hours at a regular pay rate of $10 per hour, I have made $20, right? If I work 2 more hours at an overtime pay rate (time and a half or 1.5x) of $15.00, I will have made $30 from the overtime that I have worked, right? Add those two together (20+30) and you get $50.00.
That formula looks like this:
(2 x 10) + (2 x 15) = $50. You solve in PEMDAS fashion.
I hope this answers all of the questions you had.
It's 6 months later so you may have already resolved the question for yourself, I'm sure. But just in case. :)
So bless
Thank you so much !!!
How can this be in first result?? Barely understand what he says
We can freeze table array by pressing F4. It will make result more accurate
well
Thank you
where can i get the template?new to excel need to create a payroll for my class
what money is represented by column pay, i thought it is gross but it is not,
Thank You for your comment.
We have used the general formula in order to make it simple. We can add mutiple columns like medical expense or allowances to make it more realistic.
Thank You.
please is more helpful
Thank you !!!
Ok
Jeml
💜️🥹
How can you get the other deduction
We have use random categories.
You can use deduction categories as per your own need like Provident Fund etc