Easy Payroll System In Excel

Рет қаралды 250,100

3 жыл бұрын

#Advance #InventoryManagement #excelforbeginners #geniusworld
Learn How to Create Payroll or Salary Statement in MS Excel. How to Calculate DA, HRA, PF, Gross Salary, EPF, LIC, Total Deductions, and Net Salary in Hindi, also learn how to format or Design Salary Sheet for your employees. Learn Excel basic formulas Sum, Percentage, Subtraction, etc. It is a complete ms excel training tutorial.
Excel Tutorials:
/ @geniusworldteam
Don't forget to subscribe to our channel for more great Excel tutorials!
Visit us at: / genius-world. .

Пікірлер: 81

@ericadenison1019 2 ай бұрын

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.

@geniusworldteam 2 ай бұрын

Thank You so much !!!!

@dearest-tulip Ай бұрын

I love that with the power of tutorials, one does not need a college course to learn how to construct spreadsheets

@geniusworldteam Ай бұрын

Thank You So Much !!!

@merakigemini 10 ай бұрын

Thank you. Learned a lot. :)

@highdesertbutterflygrove 11 ай бұрын

Excellent and straight to the point. I appreciate how simplified your video is.

@geniusworldteam 11 ай бұрын

Thank you so much for your kind appreciation

@marjoriemclaren1851 10 ай бұрын

Great example in an excel spreadsheet! it made it easier to understand.

@geniusworldteam 10 ай бұрын

Thank you so much!!!

@bubacarrnjie4281 10 ай бұрын

I really appreciated the video because it boost my understanding about salaries

@geniusworldteam 10 ай бұрын

Thank you so much

@jamaicanstyle1111 Жыл бұрын

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

@geniusworldteam Жыл бұрын

Thank you so much !!!

@samanthafoster1227 Жыл бұрын

Thank you very much for sharing🙏 I’m starting my small business and this will help me alot

@geniusworldteam Жыл бұрын

Your welcome & Best wishes for your business !!!!

@okumualfred6663 Жыл бұрын

@robyemmanuel710 Жыл бұрын

Excellent, Thank you for sharing.

@geniusworldteam Жыл бұрын

Thank you !!!

@dinowmoalimnour71 18 күн бұрын

Very smart thank you ❤

@geniusworldteam 18 күн бұрын

Your Welcome !!!!

@grantdotson193 2 жыл бұрын

Very intelligently taught.

@desiannwilliams1852 4 ай бұрын

I like this. Will be using it in my payroll journey

@geniusworldteam 4 ай бұрын

Thank you for your feedback!!!

@ericadenison1019 2 ай бұрын

Yes I use excel for our small company too, works well. Just added a cheque printing template.

@Bintemujeeb Жыл бұрын

Thnk you for sharing such an informative video

@geniusworldteam Жыл бұрын

Your Welcome !!!

@bbroom78 8 ай бұрын

Thank you, it was very clear ♥

@geniusworldteam 8 ай бұрын

Your welcome

@hlulanipeseverence5269 2 ай бұрын

Thank you so much this is very simple and helpful 🙏🙏

@geniusworldteam 2 ай бұрын

Your welcome!!!

@maearianboter6052 Жыл бұрын

Thank you and God Bless

@geniusworldteam Жыл бұрын

Thank you too and your welcome !!

@eRIck-130ms-e2v 4 ай бұрын

This is one of the simplest video ever

@geniusworldteam 4 ай бұрын

Thank you so much !!!

@rahavan8939 4 ай бұрын

Super sir...thank you so much 🎉🎉🎉🎉

@geniusworldteam 4 ай бұрын

Your welcome

@user-vr8qn3jf7l 8 ай бұрын

excellent and accurate job

@geniusworldteam 8 ай бұрын

Thank you

@victortedjere8652 2 жыл бұрын

Thanks for sharing. Is there a template for public sector payroll?

@geniusworldteam 2 жыл бұрын

Thank you for your interest. We have made it by using the simple technique but we will make the payroll on public sector soon.

@sundayspecialstsoai7751 Жыл бұрын

How about the ones that have different hourly for the weekday and weekends? I didn't understand when you got to the overtime

@geniusworldteam Жыл бұрын

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

@NineEyedOracle Жыл бұрын

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. :)

@egoreruamoses8857 3 ай бұрын

Great and very helpful

@geniusworldteam 3 ай бұрын

Thank You !!!!

@OkayIMThatGuy Жыл бұрын

where can i get the template?new to excel need to create a payroll for my class

@miamolydie3417 11 ай бұрын

Simple and straightforward, 😊 🎉

@geniusworldteam 11 ай бұрын

Thank you

@andu3206 3 ай бұрын

Thanks very much 😊

@geniusworldteam 3 ай бұрын

Your welcome !!!

@joelsimonpraiseandworship649 3 ай бұрын

Simplified very well

@geniusworldteam 3 ай бұрын

Thank you for your feed back !!

@giftsbeautyvlog144 29 күн бұрын

Thanks so very much

@geniusworldteam 29 күн бұрын

Your Welcome !!!!

@erprabhakaran 8 ай бұрын

I love you 💗 thank you

@geniusworldteam 8 ай бұрын

Your welcome!!!

@isaacmugala1656 4 ай бұрын

Bravo

@Mr.patron28 10 ай бұрын

great video

@geniusworldteam 10 ай бұрын

Thank you

@dorcasgyasi514 2 ай бұрын

Neat work

@geniusworldteam 2 ай бұрын

Thank You !!!

@MegersaAhmed-py9hc 11 ай бұрын

Yes for every

@geniusworldteam 11 ай бұрын

Thank you

@alex_HRM 9 ай бұрын

This is very simple

@geniusworldteam 9 ай бұрын

Thank you for your feedback

@alex_HRM 9 ай бұрын

@@geniusworldteam I will like to talk to u privately

@emmanuelumar8319 8 ай бұрын

Thanks

@geniusworldteam 8 ай бұрын

Your welcome!!!

@TajudinAbdii 2 ай бұрын

@SeankirkGammon 8 ай бұрын

So bless

@geniusworldteam 8 ай бұрын

Thank you so much !!!

@katedivinagracia1145 7 ай бұрын

Is this the standard computation in all the companies??

@geniusworldteam 7 ай бұрын

We have used the basic technique to explain the way. Definitely organizations use this technique to solve multiple criteria

@saliyadubela Жыл бұрын

well

@geniusworldteam Жыл бұрын

Thank you

@user-ps5ld9mk1v 4 ай бұрын

please is more helpful

@geniusworldteam 4 ай бұрын

Thank you !!!

@JemalBuli-vx5ef 7 ай бұрын

Jeml

@wegarajapaksha9000 7 ай бұрын

💜️🥹