Thanks for watching and commenting. Request you to watch the rest of our videos to gain more ideas. All Videos of Prabas MSOffice in Tamil - தமிழ்: th-cam.com/play/PLXqX9fbIzJMboP2SYGh-sGft3Vi6H8RGH.html
+karthikeyan Mohan Thanks bro, I have already added few interesting waterfall chart videos. Visit the following link: th-cam.com/video/lXQHYG1aMTA/w-d-xo.html th-cam.com/video/waQ5b3EJLL8/w-d-xo.html th-cam.com/video/XHjNVsK3HXQ/w-d-xo.html These links will help you. I will also add the normal waterfall chart concept in tamil
Sir Excellent support is this videos thank you very much sir Sir How to add it automatically to a specific chart when we are working on a regular pivot table
Please make your question clear brother. 1) Report create pannanuma 1) Repeat as Total podanuma Create aan Excel sheet with your question and some sample data, then share it with me through email ( prabas.msoffice@gmail.com )
No bro yan 3 sheet iruku 1.project 2.spare 3. Maintenance ithuda total thani thani sheetla iruku. Ok. But yanaku oru sheet la Ex. Spare la irukra value change panna main sheet value change aaganum pl explain i already mail to you..
Bro, just watch this video. Thanks a lot... Learn new things from excel... I have a doubt.. Is the formula will remain after i close the file? Is there i need to do formula each time i open the file or the formula will remain until i delete it. My 2nd question is: Beside sum formula, can i use other formula for example vlookup, if formula, etc....
Answers for your questions: 1. Formula will not be deleted, it remains as you created 2. There is a limitation, you can use only basics formulas not the pre-made functions.
Bro... Enaku 100000 , customer oda id iruku avanga different request kudupanda different date la... Enaku output... customer id one ah irukanum athuku multi request with date um varanum...single row la... Used with single formula... Plzzz help me bro
Nyc bro
Thanks for watching and commenting. Request you to watch the rest of our videos to gain more ideas.
All Videos of Prabas MSOffice in Tamil - தமிழ்: th-cam.com/play/PLXqX9fbIzJMboP2SYGh-sGft3Vi6H8RGH.html
Ur teaching good
NICE VIDEO SIR,side by side kindly upload macros basics sir..
Sure.
Nice sir
Super ji
I appreciate your dedication for educating others!!!
Keep watching other useful videos too.
Excel Tips in Tamil - தமிழ்: th-cam.com/play/PLXqX9fbIzJMb0EgMGAZJ2m0iC8wsD_Cz1.html
Superb, expect to receive more on this chapter
Sure we will
It's new info for me , thanks you sir.
Very interesting video bro. Now I came to know this formula available in pivot table....
Yes we can create our custom formulas in Pivot Table
Good for beginners
hi, I like as well try to add another formula "balance" please Thanks, keep doing your great service
+MOHAMAD SIDDEEK
Sure Mohamad keep watching.
Thank you nice explain.
Hi, This video is useful..... can u upload a video regarding creating a macro.
+S.Ashok kumar
Sire Buddy, you could except it soon.
Super bro, please add video for water fall chart in Tamil.
+karthikeyan Mohan
Thanks bro, I have already added few interesting waterfall chart videos. Visit the following link:
th-cam.com/video/lXQHYG1aMTA/w-d-xo.html
th-cam.com/video/waQ5b3EJLL8/w-d-xo.html
th-cam.com/video/XHjNVsK3HXQ/w-d-xo.html
These links will help you.
I will also add the normal waterfall chart concept in tamil
Thanks sir, pls add video for macros.
Sir
Excellent support is this videos thank you very much sir
Sir
How to add it automatically to a specific chart when we are working on a regular pivot table
Will upload soon
Thanks
sir we need practice excel data sheet download link in your all vidoes.
Bro in excel 2010 there is no option in Analyze (grand total) calculated field how can I get it from...??
Check in other places too. That may be located in other places with different name.
Sir is it possible to correct the database through pivot table while analysing like chennai instead of chennnai
No, you can not do like that using pivot table.
❎❎❎
Formula put in zoom mode sir
Okay brother. Thanks.
Bro yanaku oru sheet la podra total value again innoru sheet la yappdi rept pannanum sollunga... pl
Please make your question clear brother.
1) Report create pannanuma
1) Repeat as Total podanuma
Create aan Excel sheet with your question and some sample data, then share it with me through email ( prabas.msoffice@gmail.com )
If you need a report based on the data from another sheet.
1) you could use Pivot report (or)
2) you could use powerquery
No bro yan 3 sheet iruku 1.project 2.spare 3. Maintenance ithuda total thani thani sheetla iruku. Ok.
But yanaku oru sheet la Ex. Spare la irukra value change panna main sheet value change aaganum pl explain i already mail to you..
Will check brother.
Sir, can we use date format within countifs formula
I couldn't find analyses tool bar in excel.. pls suggest
+Ameer Hamja
If you are talking about Pivot "Analysis" Tab, I can be identified as Pivot "Options" in order versions.
Prabas msoffice Bro u mean older version
Hi...
Help me out to get refreshing automatic pivot table from the source data
How to disable right click on macro button...
+Sri Balaji
It is possible, try to create a video for this soon.
Bro, just watch this video. Thanks a lot... Learn new things from excel... I have a doubt.. Is the formula will remain after i close the file? Is there i need to do formula each time i open the file or the formula will remain until i delete it.
My 2nd question is:
Beside sum formula, can i use other formula for example vlookup, if formula, etc....
Answers for your questions:
1. Formula will not be deleted, it remains as you created
2. There is a limitation, you can use only basics formulas not the pre-made functions.
th-cam.com/play/PLXqX9fbIzJMbyD30T_0MnBuKrT1P26c7B.html
@@Prabasmsoffice what is the example of pre made functions?
@@Prabasmsoffice will watch and comment soon.
excel samples upload pannuga sir nange workout panna
I am having salary work book in Excel,I want saary slip at a strech for all employees.p;ease exp;ain how to do it
Bro can we use sum if like formula??
Yes
in this video also no practice file
we need practice file bro
Due to some technical glitch, it got removed from the website. I will try to update this too. Thanks for flagging this issue to me.
Updated. Please check and let me know.
@@Prabasmsoffice Bro its not showing there is no link bro
Bro... Enaku 100000 , customer oda id iruku avanga different request kudupanda different date la... Enaku output... customer id one ah irukanum athuku multi request with date um varanum...single row la... Used with single formula... Plzzz help me bro
+DHIVYA D
Posible, but your sample file will help me to help you better. Share it with me.
Okk bro
Sir intha option office 2007la panamudiymaa
Yes, it is available.
Thankyou
Thanks for watching this tutorial