Pivot Table in Tamil | Pivot table in excel in tamil
Вставка
- Опубліковано 13 вер 2024
- Complete Excel Class :Link : • Excel Learning in Tami...
Microsoft VBA Excel Macro Link : • VBA Excel MACRO in Tam...
Microsoft Word and become an expert Link : • MS Word Complete Tutor...
Thank you very much.. I have learned everything about pivot table.. Please do more video's..
Thank you so much sir.. superb ah clear ah solli koduthathuku.. god bless you 🙏
Good details. Teaching skill developed well done congras sir
Thank You so much, the class is very simple and abundant knowledge, its very useful to all including myself.
Thank you for the wonderful and clear explanation
Really super, awesome coaching
Thank you sir
super .thank you
Thank you so much sir....super explanation about pivot table and usage....
Thank you bro
Unmayavey Sama useful and clear lesson sir please don't stop keep teaching us 😍
Excellent
Very super, Sir. I expect more videos in this regard from you. Thanks & regards.
Thank you so much sir romba clear ah iruku video
I am a new subscriber. Thank you so much sir, I am comfortable learing from you!
Thank you very much, brother. The session was very usefull.
Very useful ,thanks
Very useful information bro Thanks for the video and your time and Efforts 🙏
Thanks a lot sir !! You saved my time 🙏🙏🙏
Thank you sir clearly teaching
Thanks for shares ur knowledge.
Thanks a lot for your wonderful lesson. Today I could know about pivot table because of your lesson.
Thank you. Good information
THANK YOU BROTHER. VERY VERY USEFUL.
Thank You so much,
Thank you so much sir
Sir, Thank You Very Much! I am eagerly awaiting your video about dynamic searchable drop down list.
Nice tks for demo
awesom..undrstd vry well. kindly please attach the sample file for practice
Thanks a lot✨
Super nice
very useful thanks.
Really Super Bro
Good explanation bro
🎉
Super sir your work
Thanks
Sema
Great tutorial. One question,
If I change the header name to something else, will it automatically be updated on Pivot?
For instance, Instead of "Category", I change to "Class", will the pivot table and charts automatically update this data? Currently, Im not able to do so, I have to manually select the new header on the pivot. if there is any solution, please let me know. Literally, I want the data (including headers) to be updated dynamically
Auto update technically will leads to data issue in General. Still you can do it by using macros.
@@vathiyartn yes, but my client doesnt want to do it by macros
Elam bro but same sheet la payment method and most sale product with sale reg and sale preson name ipdi 4 r 5 data's ah same page la kondu vara mudiuma???
brother, please teach me advanced use of pivot table. it is very fundamental
One five video please list available bro, please check that one..If possible I will one more video.. Thanks
@@vathiyartn sir i want same data for practicing pivot table.. PDF format create panni description la podunga bro.. viewers ku practice panna romba useful ahh irukkum.
Brother enaku pivot la basic ye purila konjo help pana mudyum ah? 😔😊..
Sir Row labels-la new item add panrathu epdi...
Android mobile phone ல் MS EXCEL APPல் PIVOT TABLE எப்படி பயன்படுத்துவது?
தயவு செய்து விளக்கவும்
Sir purchase order pending list ethula pannalama sir
Yes , we can.
Need for practice file
Bro 1000 name eruku individual oru name yaduka Soluraga atha yapty filter panurathu
Please try vlookup
Tq brother
Sir enaku header option eh andha pivot table la click panra dialog box la kaata matudhu
Pivot table fields nu box la filter column rows values only 4 matum kaatudhu
Sir voice clear teaching panunga.. I know pivot table edhu adhu edhu sir
Sub heading kudutha pivot table accept pannuma
Yes , you can enable in settings.
Vlook Ethuku lam use panalam
For any data retrieve from vertical position..
For ., example
Ippo vertical position la nireya datas column wise ah iruku....ippo ungaluku PARTICULAR datas mattum venumna V- lookup use panni particular column data mattum view pannikalamnga...
Real-time....example
A b c d e f g h (Column head)
1 2 3 4 5 6 7 8
4 5 6 7 8 9 4 5
Ithula ungaluku A and H mattum venumna vlookup use panni separate ah edukalam...
Output...,
A h
1 8
4 5
@@anandhakrishnan2132 bro naa excel learn pantu vara.. but onume purila silathellam konjo help pana mudyum ah plss 😔🙏🙏
A=118 B=1.3 C=84 D=89 E=0.94 F=0.08 G=0.38 H=WRONG
A=RANDBETWEEN (117,151)
B=RANDBETWEEN (10.8,13.4)
C=RANDBETWEEN(D-20,D+20)
D=RANDBETWEEN(68,92)
E=C/D
F=((0.48*B*((A)/E)/1000))
G=(6700-(5*25))*F*((1/(500-25))-(1/(800-25)))*0.9
THIS FORUMULA, I have given in cells
BUT I REQUIRE
F 2.220
H= IF(AND(F 2.220),"OK","WRONG")
IS IT POSSIBLE, PLEASE GUIDE ME HOW TO DO
Yenna mannu mathiri solli Tara venne
Thank you Sir.