You excel videos are very useful for self-learning and your voice is very much mesmerising and conveys the contents in a very logical way and interesting to follow the flow
Superb, so far I thought pivot tables are only for graphs/pictures, now only it's understood that it's something beyond the pictures which are very much essential for my report (s), thanks again
Bro.. I need employee LOGIN , logout (hours based) , production hours and their production counts ..how to create PIVOT in time basis in different format.. please upload.. Your presentation and voice was too clear & easy to understand..Nice😀😀
Yes sir, I have selected sheet,after selecting pivot table error indicating field name not valid. can you share me your mail id. I will share my sheet .thanks
Bro i have a one doubt.... Duplicate values ah highlight pannanum... Apm duplicate values ah separate ah next sheet la paste pannanum.... 605250 intha id.... Excel la 3 times irukku so enaku.... 3 times separate sheet la veanum... Epdi pandrathu bro... Help me????
+DHIVYA D Handling duplicate value is an excellent working. There are many types apart from the native methods. Scenarios are different. 1) identify duplicates 2) select them and press Alt + : 3) copy the selection 4) paste them wherever you want For more information, share the working file and come for a discussion.
You can find the practice file in our usual following link: www.prabastech.in/free-downloads/ It will be available with the same name of the youtube video.
Bro... Enkitta.... Customer id 100000 iruku... Athuku different dates,modification list iruku ithu ellamea duplicate values ah vum iruku... Oru customer id more than times varum athuku modification list um change agum... Date um change agum... Enaku result... Customer id one time.... Next column la date athukana modification information... Then next date, athukana modification list um veanum.... Ithu epdi bro kondu varrathu....
Simple brother, this can be done by using Pivot table itself. If it is really urgent, we can talk further. Or else share the excel file with me and wait for the video to be published from Prabas MSOffice.
Analyses is new for me. சகோ data cursor கொன்டு select பன்னாமல் ctrl A கொடுத்து select பற்னினால் என்ன error வரும்.. நான் பார்த்தவரை நீங்கள் cursor use பன்னி selrct பன்ன சொலகிறீர்.
could you please share the excel which you are using for this demo
docs.google.com/spreadsheets/d/1en5nJp_PU7YVNfu17xlkUYwC_gpCF80DlExqrlRCIpg/edit?usp=drivesdk
@@Prabasmsoffice is it possible to download ?
Yes
@@Prabasmsoffice I can't download this file bro....
@@Prabasmsoffice no option is available for download this file bro...
You excel videos are very useful for self-learning and your voice is very much mesmerising and conveys the contents in a very logical way and interesting to follow the flow
Thanks for appreciating Prabas MS Office. Happy learning.
Thank you very much it was comprehensive presentation ....
Superb, so far I thought pivot tables are only for graphs/pictures, now only it's understood that it's something beyond the pictures which are very much essential for my report (s), thanks again
Good understanding. Keep learn, be safe & learn more.
@@Prabasmsoffice
Yes, really it's a time to learn more
Fact
Usefull and Understanding
Do you know the practice file is also available, do check.
a very very useful video for all sir thanks this video your teaching and presentation awesome sir everybody can understand easier thank you sir
+Aliyar Husain
Thanks buddy, keep watching and learning.
outstanding presentation
Do not forget to practice the same. Happy learning. கற்க கசடற.
Excellent
Thanks for watching the video.
Bro.. I need employee LOGIN , logout (hours based) , production hours and their production counts ..how to create PIVOT in time basis in different format.. please upload.. Your presentation and voice was too clear & easy to understand..Nice😀😀
Please provide the link of the dataset for practice.
Thankyou 🥰
What is steps to get updated the Pivot table for the excel which I update the details daily?
Sir,creating a pivot table, the field name is not valid,error indicating.
Could you please mention your doubt with some more examples..
Yes sir, I have selected sheet,after selecting pivot table error indicating field name not valid. can you share me your mail id. I will share my sheet .thanks
@@subramanirangasamy3320
Prabas.msoffice@gmail.com
Mail sent to your id. give your suggestions
Sir, Veryusefull after giving your ideas, i can able to do pivot table
thanks a lot.
Need your service further upcoming days.
super
Thank you sir
Try to download the practice file and practice it.
Sir,i want this practical file.
In which version you are using
+Ashok Bala
Office 2016
Sir enaku report filter Mari manual formulas use panni Na Panna mudiumma
Sir pivot table manual Panna mudiuma
+sathya raj
Yes, to some extent we can create manually using formula.
Vlookup link send pannunga sir
th-cam.com/play/PLXqX9fbIzJMbrdIRG0XW23TCIUnMPJiXM.html
Thanks for the video. Can you upload useful excel tricks related to stock markets?
+Ramesh Kumar
Sure will add that in my queue list.
Thanks.
Bro intha video voda practice file bro....???
I will check and update it sister.
@@Prabasmsoffice Ok bro. Let me know
Updated. Please check and let me know.
Please check twice. It is there ma.
@@Prabasmsoffice Yes bro i got sorry bro
Bro i have a one doubt.... Duplicate values ah highlight pannanum... Apm duplicate values ah separate ah next sheet la paste pannanum.... 605250 intha id.... Excel la 3 times irukku so enaku.... 3 times separate sheet la veanum... Epdi pandrathu bro... Help me????
+DHIVYA D
Handling duplicate value is an excellent working. There are many types apart from the native methods. Scenarios are different.
1) identify duplicates
2) select them and press Alt + :
3) copy the selection
4) paste them wherever you want
For more information, share the working file and come for a discussion.
Okkk bro.... Tqqqq
Sir nanga work panni paka neenga panra format konjam link la kudutha use fulla irukum sir
You can find the practice file in our usual following link: www.prabastech.in/free-downloads/
It will be available with the same name of the youtube video.
Kindly share the practice file which will help us
www.prabastech.in/free-downloads/
Bro... Enkitta.... Customer id 100000 iruku... Athuku different dates,modification list iruku ithu ellamea duplicate values ah vum iruku... Oru customer id more than times varum athuku modification list um change agum... Date um change agum... Enaku result... Customer id one time.... Next column la date athukana modification information... Then next date, athukana modification list um veanum.... Ithu epdi bro kondu varrathu....
Simple brother, this can be done by using Pivot table itself.
If it is really urgent, we can talk further. Or else share the excel file with me and wait for the video to be published from Prabas MSOffice.
If the real data is a confidential one, then prepare dummy data and share it with me.
Okk bro... Will u share that...plzzz send me ur mail id bro...
+DHIVYA D
It can be found in Channel's about tab.
It is Prabas.msoffice@gmail.com
Bro...send u excel pic mail..
Analyses is new for me. சகோ data cursor கொன்டு select பன்னாமல் ctrl A கொடுத்து select பற்னினால் என்ன error வரும்.. நான் பார்த்தவரை நீங்கள் cursor use பன்னி selrct பன்ன சொலகிறீர்.
+Ameer Hamja
People can understand easily when we use mouse rather than shortcuts.
+Ameer Hamja
You can use shortcuts
K bro.. i thought if any difference is it..
நன்றி.. நான் ஏதும் வேறுபாடு இருக்குமோ என்ற சந்தேகத்தில் கேட்டேன் சகோ... super
could you send me ms office 2016 for Mac
www.amazon.com/Microsoft-Office-Home-Business-Download/dp/B011DMUIQY/ref=pd_sim_366_2/143-0423537-9403850?_encoding=UTF8&pd_rd_i=B0153V61XU&pd_rd_r=1f6b6b57-5e87-11e9-a6d1-89beb44619b8&pd_rd_w=s2uad&pd_rd_wg=YkokC&pf_rd_p=90485860-83e9-4fd9-b838-b28a9b7fda30&pf_rd_r=SHX6HGWX6ZPF941T7HRD&refRID=SHX6HGWX6ZPF941T7HRD&th=1
Nice ma
H r u sir
I am good, thanks.
Hope you are doing great.
Give examples
+Dhana Raj
Whether You are asking about an another video with some more examples or you need example files to practice it.