Sir Main apka fan ho Gaya hu. Aap meri life change kr de rahe hai. Thank you sir itani a6i Tarah se video banane ke kiye. Apko Mera bahut bahut dhanyabad
Hello sir, Just saw your introduction to power pivot video and its really great. Can i find all the videos related to power pivot and power query in your channel.
Hi sir.you teach excel at advance level.thanks for that.i have just one query is it any need to join your courses.because you already teaching deeply on TH-cam and gives us training.please suggest.
speaking honestly you dont need to invest your money in our course if you are thoroughly able to understand every thing taught in the virtual training .but, if you want one on one attention then u are surely welcome to our institute its always open for you . so you dont need to worry about anything and all the best for the future
Thanks sir, I have learnt alot from you.. but I hv 1 problem. How can I calculate cumulative achievement % in a pivot table. How to do field calculation for that.
Using pivot table find Total any no ODR ID Count AND Total Unique no is repeated and some are unique ODR ID COUNT no are duplicate 2 or 3 time and some are unique Mobile No wise in the Same Pivot Table i have use dis . count but not possible
Dear Sir It makes me very happy that much awaited power pivot series is about to start. In power pivot intro tutorial your way of teaching really impressed me. I wish every success of your channel. Thanks Jayanta Bhattacharyya
@@Innozant its request can you make one video bunch of hidden command in excel which we can add and use in customize tab hope this is good topic and helpful for your subscriber If you had already made please share link
sir i eagerly waiting for this series. thank you so much. but i have some problems with my excel software.whenever i transfer data or use something in power query,it always shows unexpected error code 0xFFFFFFFF.And this happends not only with huge data but also for small data with only 10 rows.And i know power query is important for power pivot.if you don't mind,can you please send me thr download link of your excel latest version (i mean 2019)?because i think there is something error with my version.mene google and youtube pe search kiya ye problem but koi solution nhi mila.baki functions to perfectly work kr rhe h bs power query and power pivot me kuch error ara h.data transform hi nhi hora.file select krte hi loading hoti h and unexpected error.please help me sir if you can🙏
thats means last example of pivot table where i use power query not done ? First try to implement that with power query still the same prob you may found then it may be your excel us currupted or some other reason.Aur saare function yadi work kar rhe hain phir ye bhi chalna chaiye..connction check ktke dekhna db ka wo create kr pata hai ya nhi
@@Innozant sir i think power query currupted h meri.data tab me new query me jake file select krni hoti h ya fir table select krke query create krni hoti h kisi se bhi work nhi krra.sb kuch try kr liya.data query me load hi nhi hora.aur agr glti se transform.ho bhi jata h to air koi feature apply kro to firse vhi same error ata h. ap apne wale excel ka download link de skte ho kya?apne bhi shyad google se hi download kiya ho?
haan..but yaad nhi hai link Ishu..kisi youtube ke video me link tha description me whin sw kiya tha download..but dahi chal ra hai mera to..wk baar kisi aur link se krke dekhiye ya main kal dekhta hu ek baar aur btata hu link
@@Innozant ok sir g.then i am waiting.mil jaye to theek na mile to koi bat nhi jyada tension mt lena ap. me to bs isliye puch rhi thi kyoki mobile data se download krna hota h mujhe.aur agr fir se mujhe koi currupted link mil gya to bar bar download krna possible nhi.agr fir bhi nhi chla to kya hi kr skte h.adjust kr lungi me.thank you so much sir🙏
@Shalu Jain vo sirf old version me hota h.latest versions me inbuilt power query hi chlta h.jo ap bol rhe ho vo excel 2010,2013 versions me chlta h.2016 ke bad se inbuilt power query aa gya excel me.alg se install nhi ho skta
Bhai aap itta zyada bolre aur batare bhoot kam, 13 min me hi bata sakte thae magar sirf intro me hi lagadiye aap pura video. Islye skip krna padhra apki video ko.zara kaam krte krte boldiyeto bhi samj jate log.
Ye tips and tricks video channel nhi hai..complete course jab karte hain to bus topic ko touch krke nhi nikal jana hota hai in depth explain karna hota hai..yadi time ki kami hai aapke paas aur jaldi se crash course karna chahte hain uske liye ye phir galat channel hai....aur bht resource hain padhne ke liye wahan kam.time me Seekhiye
@@Innozant Are Sir g aap naraz hojare kaiku, mai bus explanation bada hogaya bol ke bola, aap galat mat smjhiye, mai apku demotivate ya phir nicha dikhane k liye nai bola, agar apku bura laga to usk liye sorry, mai apk videos dekhta hu thode tricks sikha apk hi videos se...actually i was excited to see the trick but there was no content about the power pivot.islye mai kuc zyada boldiya jaisa apku laga shaad.Many Thanks👍
Aakash ji ye Jadoo wale tricks video nhi hain ..Is channel par in depth course learning hota hai..Aapse gujarish hai kripya dubara video na dekhen na bore ho.Entertainment nhi educational channel hai ye . Respect your parent and teacher.😊
Sir Main apka fan ho Gaya hu. Aap meri life change kr de rahe hai. Thank you sir itani a6i Tarah se video banane ke kiye. Apko Mera bahut bahut dhanyabad
Thanks Deepraaz..Happy Learning. God bless you dear
Tq u sir bht din SE wait Kar rha tha power pivot Ka...thank u very much sir.👍
Thanks Aftab ji🙏❤
@@Innozant Sir Please aek Video bane "Lookup" ke hawale se please sir please.
Apse seekhne m bhot maaja aata hai , you give lessons also and explain things very lighly
Thanks dear
Your content and explanation is simple and easy to understand.
Thank you for your contribution sir.😊
Great yaar itna detail me bohot hi kam log shikhate hai..Appreciated Sir👌👌👏👏
Thanks Raza...Aisw hi complete course tutotual learn krenge humlog dear
@@Innozant zaroor👌👌😊
आप हमारे जिंदगी मे आये उजाले की तरह to give us right direction सर.
Thanks Shrikant Ji for such a lovely appreciation..God Bless you dear.❤🙏
आपके बोलने का अंदाज बोहोत जबरदस्त हैं सर. that's why I am your fan.
Thanks Shrikant Ji .Happy Learning
Thanku sir for power pivot explanation.sir humko machine nahi banna hai knowledgeable banna Hai jo aapki video se ho jaye ga.good night 👌👌👌
Thanks Satish Ji.Happy learning dear.
I wish I watched your videos WHEN YOU UPLOADED IT I WAS IN THE GOOD COMPANY RIGHT NOW
You are not late dear..start your learning journey now.
I would like to thank to innozant chenal and too innozant family, cause I m graceful of you sir.
Love you sir, 🙏
Thanks Pawan for your respect,love and support dear..really mean a lot to me
Very informative... Thank you sir
Sir, awesome pls continue it daily power series
Weekly.daily me aur kai saare playlist ek saath chal re h dear
I hope nothing else
Great explanation sir,
Thanks Hemant ji
Again first like nd comment
Thanks Sahil🙏❤
Hats off bare Vai, Love from Bangladesh
Thanks dear
Sir aapki wjh se humara ghar chal rha hai 👏🏻
Nahi dear ..Wo aapne mehnat kiya hai..
Koshish kariye khud ki skills itne ache se improve krenge ki aapki wajahse aur logon ka Ghar chal sake👍❤️
Thanks for this whole playlist ❤
Hello sir, Just saw your introduction to power pivot video and its really great. Can i find all the videos related to power pivot and power query in your channel.
Yes dear . please find seprate Playlist for both
Sir sach bole toh.hungry to grab to learn.come soon sir.❤️
Sure Situ..Soon dear ..gn..tc.
Zabardast video once again Sir. Thank you
Hi is there any that we can query power pivot data like sql query and place the data in excel. If possible, could you please make a video for that
Bahut accha explaination
Great Gurujii 🙏🙏🙏
sir advanced power pivot aur dax ka content youtube pe nahi hai aisa kyo
Awaiting for your next video sir on PP
sure soon
Thanks you have made this course, just a feedback your voice is not clear sometimes.
Sir 2007 me power query avelble nhi h kya ?
Hello sir mai apka regular viewer hoo aur mera kaam Google Sheets pe hota hai jo ki bahut hang hota hai to kripya is topic per bhi vidio banaye sir
Hello…I have PDF file which have some coloured text can I get the data in word or excel with the colour?? Please help.
Sir way u present the things connect masses.Keep it up.
Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks
Must awaited Series😀😃🤗🤩🥰😘😍🙏🙏🙏
Love you Pavan Ji for this much respect and love dear🙏❤
all 10 videos cover power pivot and advanced power pivot?
Very nice sir
Interesting and likely to learn sirji 👍
Thanks Yogesh
nice video
Thank you for power pivot.
Thanks Tejpal
Please complete power pivot table series
Pehle power query finish kar dete hain phir jal krate hain power pivot
@@Innozant Please Sir, kindly do
I am eagerly waiting for the power pivot series
Please share when will be series coming, if possible
Very nice sir!!
Thanks Badal..Gn.tc
Nice Sir😊
Awesome Class As Always
Thanks dear
Thank you so much.
Thanks Arif ji
Thank You Sir
Hi sir.you teach excel at advance level.thanks for that.i have just one query is it any need to join your courses.because you already teaching deeply on TH-cam and gives us training.please suggest.
speaking honestly you dont need to invest your money in our course if you are thoroughly able to understand every thing taught in the virtual training .but, if you want one on one attention then u are surely welcome to our institute its always open for you .
so you dont need to worry about anything and all the best for the future
Thank you so much sir.you are inspiration for all of those who want to succeed in their life.🙏👍
thanks rushali for the wishes may god bless you and the whole innozant family's best wishes are with you .
best of luck for the rest of your career
Great Sir, I am very excited to know about it.. excellent explanation.. Sir
Thanks Anup ji❤🙏
Thanks sir...
Thanks Aman ji..Happy learning..gn
Great 👌
It's helpful
Thanks Chandan❤️🙏
Good video
Thanks Sunil Ji
Great learning 👌👍
Thanks
Sir ageing report bhi bata dijiye please formule se bahut hard or time taking lag rahi hai
Sir apka course kaise purchase karo
Live class ke liye aap team innozant se connect kariye ,Video course aap innozant ke website se buy kar sakte hain
sir mere paas 2016 standard hai usem nhi aa rha hai
Sir aap vba kab suru karege???
Kuch time baad..kai saare playlist chal re hain ek saath itna manage nhi ho payega..thts why
@@Innozant ok sir
Thanks sir
Thanks dear
Sir, today I contact innozant but, there was some another guy named Dilip Jha. Confuse. Pls let me know. Thanks
Hahahaha..There is only one guy...why you confused ?😊❤️
gangadhar hi shaktimaan hai😂😂😂
Aaj he CV main update karne ja raha hoon advance power Pivot 😂😂😂😂 dil se
👍🙏❤😀
Sir you haven't uploaded macros series yet.
Yes Shahida..Will upload soon
please help solve the problem
Power query and power pivot m kya difference hai ??
aane wale videos me saare doubt clear hote jayenge..Have patience dear
Thanks sir, I have learnt alot from you.. but I hv 1 problem. How can I calculate cumulative achievement % in a pivot table. How to do field calculation for that.
Sharw data sheet for the same
Using pivot table find Total any no ODR ID Count AND Total Unique no is repeated and some are unique ODR ID COUNT no are duplicate 2 or 3 time and some are unique Mobile No wise in the Same Pivot Table i have use dis . count but not possible
Thnq sir 🙏🙏
❤🙏
Dear Sir
It makes me very happy that much awaited power pivot series is about to start. In power pivot intro tutorial your way of teaching really impressed me. I wish every success of your channel.
Thanks
Jayanta Bhattacharyya
Thanks Jayanta for your love and support..Good night..tc.
When will next part release
soon
Guru jii🙏
Thanks Raman Ji..Happy Learning dear
Nice
Thanks Asif sahab💖🙏
Not Understand [@SalesRep]
Plz Explain
Query?
sir. ur all videos are very helpful. but please remove background music. this wasnt there in vlookup Playlist. this background music is irritating
Thanks Isha for your valuable suggestions...Wo edit krte time sound jyada reh gya tha background ka..ok let me try to reduce voice of possible
Sir I hv mail one query request you to pls revert with solution
OK..Will let you know dear..Time nhu rhta h bikul bhi.
@@Innozant okay sir thanks for ur rply
Mai Toh Sikhne Ke Liye Interested Rahta Hu Humesha, Kyoki Mujhe Khud Se Behtar Hona Hai.
good
❤️❤️❤️
@3:48 you mistakenly said 1048516 which instead of 1048576
Ohh ..kindly rectify it.. Thanks for notifying us❤️❤️👍
@@Innozant its request can you make one video bunch of hidden command in excel which we can add and use in customize tab hope this is good topic and helpful for your subscriber If you had already made please share link
Sir Google in scripting per video banana
Acha Kuch time baad dear.
sir i eagerly waiting for this series.
thank you so much.
but i have some problems with my excel software.whenever i transfer data or use something in power query,it always shows unexpected error code 0xFFFFFFFF.And this happends not only with huge data but also for small data with only 10 rows.And i know power query is important for power pivot.if you don't mind,can you please send me thr download link of your excel latest version (i mean 2019)?because i think there is something error with my version.mene google and youtube pe search kiya ye problem but koi solution nhi mila.baki functions to perfectly work kr rhe h bs power query and power pivot me kuch error ara h.data transform hi nhi hora.file select krte hi loading hoti h and unexpected error.please help me sir if you can🙏
thats means last example of pivot table where i use power query not done ? First try to implement that with power query still the same prob you may found then it may be your excel us currupted or some other reason.Aur saare function yadi work kar rhe hain phir ye bhi chalna chaiye..connction check ktke dekhna db ka wo create kr pata hai ya nhi
@@Innozant sir i think power query currupted h meri.data tab me new query me jake file select krni hoti h ya fir table select krke query create krni hoti h kisi se bhi work nhi krra.sb kuch try kr liya.data query me load hi nhi hora.aur agr glti se transform.ho bhi jata h to air koi feature apply kro to firse vhi same error ata h.
ap apne wale excel ka download link de skte ho kya?apne bhi shyad google se hi download kiya ho?
haan..but yaad nhi hai link Ishu..kisi youtube ke video me link tha description me whin sw kiya tha download..but dahi chal ra hai mera to..wk baar kisi aur link se krke dekhiye ya main kal dekhta hu ek baar aur btata hu link
@@Innozant ok sir g.then i am waiting.mil jaye to theek na mile to koi bat nhi jyada tension mt lena ap.
me to bs isliye puch rhi thi kyoki mobile data se download krna hota h mujhe.aur agr fir se mujhe koi currupted link mil gya to bar bar download krna possible nhi.agr fir bhi nhi chla to kya hi kr skte h.adjust kr lungi me.thank you so much sir🙏
@Shalu Jain vo sirf old version me hota h.latest versions me inbuilt power query hi chlta h.jo ap bol rhe ho vo excel 2010,2013 versions me chlta h.2016 ke bad se inbuilt power query aa gya excel me.alg se install nhi ho skta
Find highest and lowest value.
TEBAL
Highest Lowest
20 44
40 45
60 51
Drop-down list
Highest/ Lowest =
😊😊😊😊😊😊
👍👍👍👍👍
Hi sir
What is your problem man? It is so annoying to focus when you keep moving right to left and left to right ...
It was old videos dear that time unable to do good editing,Sorry for your inconvenience
high music
Noted...will work in next video
Bhai aap itta zyada bolre aur batare bhoot kam, 13 min me hi bata sakte thae magar sirf intro me hi lagadiye aap pura video. Islye skip krna padhra apki video ko.zara kaam krte krte boldiyeto bhi samj jate log.
Ye tips and tricks video channel nhi hai..complete course jab karte hain to bus topic ko touch krke nhi nikal jana hota hai in depth explain karna hota hai..yadi time ki kami hai aapke paas aur jaldi se crash course karna chahte hain uske liye ye phir galat channel hai....aur bht resource hain padhne ke liye wahan kam.time me Seekhiye
@@Innozant Are Sir g aap naraz hojare kaiku, mai bus explanation bada hogaya bol ke bola, aap galat mat smjhiye, mai apku demotivate ya phir nicha dikhane k liye nai bola, agar apku bura laga to usk liye sorry, mai apk videos dekhta hu thode tricks sikha apk hi videos se...actually i was excited to see the trick but there was no content about the power pivot.islye mai kuc zyada boldiya jaisa apku laga shaad.Many Thanks👍
Bhai Kam ki bat kr yr sirf boring kr rha hai😤😤
Aakash ji ye Jadoo wale tricks video nhi hain ..Is channel par in depth course learning hota hai..Aapse gujarish hai kripya dubara video na dekhen na bore ho.Entertainment nhi educational channel hai ye .
Respect your parent and teacher.😊
If you can stop blabbering, It could have made sense
you talk much sir
Thank You Sir
Find highest and lowest value.
TEBAL
Highest Lowest
20 44
40 45
60 51
Drop-down list
Highest/ Lowest =
Find highest and lowest value.
TEBAL
Highest Lowest
20 44
40 45
60 51
Drop-down list
Highest/ Lowest =
whats Problem while creating this list..you wang combined list i hope .
sir combined nhi Hoga Kya ye