Відео

Thank you sooooooooooo much for this comprehensive tutorial that solved my issue. I really appreciate your patience and way of teaching. God bless you

which software do you use for recording and editing videos

ITS VERY HELPFUL.YOUHAVE PRESENTED APPREHENSIVELY.THANK YOU

This perticular video made my day easy... Nicely explained... Thanks ❤

Can you make video on how to make followup of yesterday data datewise

I really appreciate your good performance...🏅👋Keep it up....

Dear Sir, I have a Question, i have preapred along with you seeing this youtube. When i enter the leaves, PL, WO in my excel for my employees, it is not showing any updates. Please suggest where my mistake will be, how to correct it. Waiting for your help. Thanking You in advance.

Hello, I want to download your sheet for work, how can I do the next step?

my company works in 3 shifts(US, AUS, UK) and when an employee starts his/her shift , entry is made using ctrl+; & ctrl+shift+; , and similar thing is done when he/she takes break (2 times 30minutes in one day/shift) & also when completing day(8 hours). so doing 7:30 work in a continuous will make one day. (here us(night) shift person logs in @ 8 pm on a day and leaves @4 am next day. Anything above 7:30 is counted as Overtime and added in salary at overtime rate which is specified. Can you please make video showing how to make such dashbaord or calculation sheet.PLEASE PLEASE

my company works in 3 shifts(US, AUS, UK) and when an employee starts his/her shift , entry is made using ctrl+; & ctrl+shift+; , and similar thing is done when he/she takes break (2 times 30minutes in one day/shift) & also when completing day(8 hours). so doing 7:30 work in a continuous will make one day. (here us(night) shift person logs in @ 8 pm on a day and leaves @4 am next day. Anything above 7:30 is counted as Overtime and added in salary at overtime rate which is specified. Can you please make video showing how to make such dashbaord or calculation sheet.PLEASE PLEASE

Can be possible client wise auto update loan amotozation table? Also if possible interest rate change so auto update automatic in excel Extra Payments means (Start at Payment No,Extra Payment,Payment Interval,Extra Annual Payment,Payment,Total Extra Payments) Additional Payment already showing in your video ,Variable or Fixed Rate ,Impact of interest rate HIKE on your loan EMI & repayment schedule & Impact of interest rate CUT on your loan EMI & repayment schedule ? how to create in excel & Suppose provide only interest

I am from Nigeria using naira how do I pay

Can be possible client wise auto update loan amotozation table? Also if possible interest rate change so auto update automatic in excel Extra Payments means (Start at Payment No,Extra Payment,Payment Interval,Extra Annual Payment,Payment,Total Extra Payments) Additional Payment already showing in your video ,Variable or Fixed Rate ,Impact of interest rate HIKE on your loan EMI & repayment schedule & Impact of interest rate CUT on your loan EMI & repayment schedule ? how to create in excel & Suppose provide only interest

All went well. but vlookup formula doesn't work for holidays.... Can u help me

Send excell link

your videos are so very helpfull! and easy to follow, if have time can you give me an insight of how can I create a simple leave planner for employees annually and can overlap from 2024 to 2025 if an employee has decided to take a leave from dec 2024 to jan-2025. just I need to know if the employees leave would cross over the submission dates. thanks in advance

Excelent - Crystal Clear

how to download the file after acquiring membership.

Most Helpful video, Thank you so much Dear, Take Love.

how to download ?

Hi i just finished making this Sheet following your steps. Everything is great except one thing that i noticed. In the formula of Overtime Hours We subtract working hours with ideal working hours. However when we copy and paste the formula for the next date since we did not press F4 for ideal working hours it picks up a different cell which gives us wrong calculation of Overtime Hours.

opens in google sheets not excel

to much informatic that is amazing

hi i need your contact

Hiii i joined your membership unable to download sheet . Please send on email Thansk

Plz grant me access to download the file

can you do the date 2:55 without Saturday and sunday ? no working days on those

But we can not charge double intrest on intrest and calculation should be month wise

I use Check-in Time and use same cell reference but It will not show the time automatically First I need to check Yes Than I need to Go on Check in cell and hit enter then I show the time moreover when I again delete Yes from f6 and I select yes again I need to Enter what should I do

Can not access this sheet, can you please let me access.

Great program

how to download i already subscribed to your channel

Some times patient stay in different wards ie, patient total admission days 4 days, but he staying in 2 days single room and 2 days staying in sharing room so that time how to calculate ward charges

Sir patient actual bill amount is 8000 so that patient to be payable amount 3000 only because that already paid 5000 advance amount,so advance paid amount tobe deduction from the actual bill

Hi, after opting for membership also why we are unable to download the template

Exlent teaching sir very useful information. Thank you.

Iam new subscriber. Thank you for information.

Hello sir, thank you for the video, I sent you an email, could you help me please?

Thank You so much, Filter formula seems to be a much easier solution than macros or helper. I had a query. After copying data upto H column in all the sheets, i have 6 more columns which are there in all the other sheets except the main data sheet. There are formulae for each specific sheet. Is it possible that once new data is auto updated in a person's individual sheet, then automatically the formulae in the 6 columns after H column gets copied to the new data's rows ?

The filter formula is not enabled in my Excel sheet. How do I enable it?

This is one of the perfect video i have been searched for. Very useful, doing great, Thank you!

Found it!

Good morning....where is the description box?

Hi I joined your membership and i am unable to download this sheet.

Second and fourth saturday restrict nahin ho raha. Pls help karein

Thank you Sir for the video, its useful.

can you send me this sheet

i have join your membership how that i open the sheet in edit version