Видео

can't we do it on a normal excel sheet?

Would you please work on how to create VBA codes from simple to advanced. Focusing on practical use case.

Great work as usual

another good video, is there any way to identify the people who took leave based on days of the week, like people who are on leave on monday/ friday etc?

well made template , was very useful and added some of uour logic in my version as well. i was trying to find certain calculations like how many people are off on friday/monday/ leaves etc, do you have any suggestions how to acheiev this ?

Please show inventory with BOM for manufacturing firm

This is simple and easy to follow. Thank you!

I need it's excel file, because when I edit in google sheet charts are not copying from one sheet to another. I want my all employees to use this task tracking but it's not functional if I copy it. Need solution.

Sir, chart axix par months are not in correct sequence, it should be Jan to Dec....Plz advise how we can correct this

NICE

Hi sir, thank you for the tutorials. Can you also make a monthly salary sheet tutorial??

Sheet link is not working I need this sheet very useful

thank you for free template.,

Very nicely explained

I have started practicing this. But the formula is not working. I tried multiple times and it still shows 0 in the box of Present. Though i selected the present on two dates. Can you help me to recover this?

Thanks!

Thanks for the video, please share the template

Hi, hope you are doing well. I am building a report in power bi for which my source is from SQL. I had joined two tables and did some transformations in SQL itself. Now i am having a derived table from the exiting tables. I need to connect this cleaned table to power bi. Can i create a view for the transformed table and connect to power bi. If yes, will the views table get updated if the underlying tables are being updated. Kindly help I created a view and connected it to power bi, but want to know if there are any other ways.

Fantastic Work. You really deserve more views!!!

Thank you

very helpful, thank you!

can I have a copy for editing please

I made a sheet like yours. But date wise closing stock opening stock is not auto updating. Please help me!

Thank you big time for your work! I appreciate it!

Great sir 🎉🎉🎉

Impressive dashboard created 👍

THANKSS MANNNN

Amazing job sir 👍👏👏

❤❤❤

what if i want to add leave entitilement sick leave,emergency leave,mission,annual leave.how to fomulate that? Thank you.i look like easy for me that excel.more power

Thank you sir 😊👍

Where the heck do you download this. The link provided is a page full of links 'ads'.

Gorgeous

How did you fill the dates after adding columns

how to assign task ?

NeoTech Navigators. I wish to see you in Nigeria one day!!!!

I did the formula right the =IF(AND(F$5>=$E6,F$5<=$C6),$E6,"") why isnt it working why cant i see the pending text its just blank

Looking forward to learn more from you and more tutorial video.

Thank you this is very helpful

Could you please help me? The formula for the days left is not working. I have already tried a lot of other formulas, but there is always some other problem. Thank you!

I've managed to complete this process for 2024, now I want to do 2025. Do I have to redo redo the the complete process do add the holidays?

well expained. Thank You.

kindly share the link to this data set for practice, i really loved how you explained things so simply🤗

Thanks for the video, it's helpful!

Very useful video. Thanks

amazing. Thank you!

Very helpfull! I started with the default Google Spreadsheet Calendar template, but I wanted to create dynamic months exaclty like you showed. And the formulas of the template are much more complicated. Like you can read in several reactions I placed on other comments in the list, I did encounter some challenges, but the advantage of such a simple design, is the increased flexibility to slightly change the approach and still be able to get the desired result. So all credits to you sir for this fine example. Learned several things by using it.

How can we add attendance percentage

Good day Sir, why am I getting a zero value return at point 12:33 minutes