Simple, Easy, ,effective and to the point..Video deserves million likes thank you.

Excellent tutorial. Very clear to understand and follow.

You don't how much you have helped me ☺

@MicrosoftOfficeTutorials

2 жыл бұрын

Glad to know 😇 tutorial was helpful for you

This is such an excellent tutorial! Thank you!

Very easy and understanding, Not at all complicated bro. Thanks a lot for the tutorial.

Simply superb excellent 👌👌👌

Excellent work, thank you!

Excellent Tutorial. Thanks...…

Thank you! so helpful!!

Very good explanation, easy to build.

Easy to understand.... thanks for video 👍👍👍

Thank you excellent tutorial easy to follow. Great work indeed!!!

Deserve Million Subs!

Great work !!!

I HAVE AN INTERVIEW ON 25 SEPTEMBER 2022. IT VERY HELPFUL TUTORIAL.

Great video

Thanks for simplest video u had made. Got great knowledge. 🙏

Thank you so much!

This is wonderful!

Very much helpful ♥️♥️♥️

Excellant

thank you so much for this tutorial, it's help me alot to prepare aging report

So helpful. Thanks

This is so helpful. Thanks

Insightful

so helpful, thank you very much

Thank you.very useful

Useful

This one is good

Very helpful

thanks for this!

Great

Great job it helped me 👍

Great video, thank you. How about creating a dynamic report showing the totals in this format: This Month, Last Month and this quarter, last quarter and this year, last year at all times without any extra steps. something like a dashboard which always only automatically calculates and shows above mentioned values?

nice video

Nyce

Ageing report is helpful in RM/PM/FG too . Near expiry, expiry and over expired material

Nice

Thank you so much. This is a good tutorial.

@MicrosoftOfficeTutorials

3 жыл бұрын

Thanks

@gunnervin

2 жыл бұрын

@@MicrosoftOfficeTutorials Yup Very helpful

Thanks you

Very well instruction, from aging report how to less the paid amount invoice automatically. thank you

Thanks alot for your efforts. Is it possible to make without today() function?

Thanku

What to do when payment against any of these invoice has been made ? In case of trade payable. Do we need to delete or any alternative?

Sir, what if we have monthly opening & closings value?

hello, what if im using google spreadsheets. what formula would i use?

Can i have the excel sheet for the same for practice

❤

@kashifqasim8069

Жыл бұрын

Great

Can you please share this worksheet

Peace be on you Can you calculate Outstanding Balance of a customer on fifo method for a given period in brackets i.e., 0-30, 31-60, 61-90, 91-120, 121-180 and above 180.

How to create paid on time report preparing

hi .. I have Promised Date, Promised Time _ Invoice Date and Invoice Time if the PDDATE achieved (1) _ how do I set a formula to achieve PDTIME giving a 1

Brother how can i get this excel sheet

The If formula in overdue days is giving errors on my end...please help

If in 90-120 days there is 30,000 due on abc company and today i collect 15,000 then how it will remain only there 15,000 can you say me in another video

whats the need of today date column..?

how can download this file

Formula not work give by NA how to solve

1 ते 100 अंक तारीख के सात बदलना चाहिये (उदा.१/२/२०२१ तो 1 अंक और १/२/२०२१ या तो 2अंक आना चाहिए कोन सा फॉर्म ला यूज़ करे

Bro can i get this file

make sheet downloadable

CAN I HAVE THE EXCL SHEET

@MicrosoftOfficeTutorials

Жыл бұрын

Hi Sunny Please provide your Email ID. I'll send you file

how to drag down with formula like you do?

@MicrosoftOfficeTutorials

Жыл бұрын

Click 2 times on bottom right corner of cell

@MicrosoftOfficeTutorials

Жыл бұрын

If cells show error or wrong results..you need to freeze the lock the range. Select range in formula and press F4 button from keyboard

full nonsense video how vlookup find those days from 0,1,31,61 etc from these table bcz those days were not in that table