Pivot Table in Tamil | Pivot table in excel in tamil
ฝัง
- เผยแพร่เมื่อ 23 ธ.ค. 2019
- 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, the class is very simple and abundant knowledge, its very useful to all including myself.
Thank you so much sir....super explanation about pivot table and usage....
Very useful information bro Thanks for the video and your time and Efforts 🙏
Good details. Teaching skill developed well done congras sir
Really super, awesome coaching
Thanks a lot for your wonderful lesson. Today I could know about pivot table because of your lesson.
Thank you so much sir.. superb ah clear ah solli koduthathuku.. god bless you 🙏
Thank you very much, brother. The session was very usefull.
Very super, Sir. I expect more videos in this regard from you. Thanks & regards.
Sir, Thank You Very Much! I am eagerly awaiting your video about dynamic searchable drop down list.
Thanks a lot sir !! You saved my time 🙏🙏🙏
Very useful ,thanks
Unmayavey Sama useful and clear lesson sir please don't stop keep teaching us 😍
Thank you for the wonderful and clear explanation
I am a new subscriber. Thank you so much sir, I am comfortable learing from you!
THANK YOU BROTHER. VERY VERY USEFUL.
Thanks for shares ur knowledge.
Thank you. Good information
very useful thanks.
Thank you sir clearly teaching
Thank you so much sir romba clear ah iruku video
super .thank you
Thank You so much,
Thank you so much sir
Nice tks for demo
Good explanation bro
Really Super Bro
Thank you Sir.
awesom..undrstd vry well. kindly please attach the sample file for practice
Thank you sir
Thank you bro
Excellent
Thanks a lot✨
Super nice
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???
Sir Row labels-la new item add panrathu epdi...
Thanks
Sema
🎉
Super sir your work
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.
@@tamilvathiyar yes, but my client doesnt want to do it by macros
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
@@tamilvathiyar 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? 😔😊..
Need for practice file
Sir purchase order pending list ethula pannalama sir
Yes , we can.
Sir voice clear teaching panunga.. I know pivot table edhu adhu edhu sir
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
Sub heading kudutha pivot table accept pannuma
Yes , you can enable in settings.
Android mobile phone ல் MS EXCEL APPல் PIVOT TABLE எப்படி பயன்படுத்துவது?
தயவு செய்து விளக்கவும்
Bro 1000 name eruku individual oru name yaduka Soluraga atha yapty filter panurathu
Please try vlookup
Tq brother
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