I m from Patna (Bihar) worked more than eighteen years as a Lead / Document controller manager. Really appreciate and thank you Sir, you said valuable things, not just for getting a job but also for a successful life
bahot he nice concept hai sach m aaap k student khush naseb hai jo phyical class join kr rhy hain kiya baat hai sir aaap ki sach muje udemy m paise kharch kr k itna kcuh samaj nhe paya jis m....par aaaap k vidoes say bahot bahot bahot labh mil rha hai bs dua kijyega muje acha rasta mile main agee new job k liye apply kr paon aaap ki dua say
Dear Sir your videos are too much helpful to me, and I am very thankful to you for your videos. I face a problem regarding pivot table. I would like to change position of pivot table column, but I can't do so. Please help me.
Pivot table & its options are very well explained in the most simple manners .No one can described better than what you have done . Thx. My request is that please add one more step in the same video. That is " Cleansing of raw data " before going towards for the creation of Pivot table . All efforts will go waste if raw data is not displayed properly. Pivot table would give distorted summary & so the data analysis. Clearing of raw data becomes more necessary when such data's are imported from many sources & in many types of file .
Thanks Jagdish ji for your valuable feedback and appreciation. Thanks for your data cleaning suggestion as well.Kindly note we created a seprate Playlist of Powrer query for the same.Happy learning.
sir, just wesome your teaching style, very esasily understood your job, heartly thanks this channel & you also. I have two colmns data set. 1. sales person 2. sales amount, I want to get specifiq value (e.g.">=5000") only pulling in pivot table. is it possible ? please help.
Pranam Gurujii... I noticed a unique feature, but good feature, of your personality. You prefer to wear T-shirt over Shirt. You wear Shirt in this video. Just noticed, that's why sharing... Pranam🙏🙏🙏 Gurujii
@@Innozant Yes Guruji, You not only teaches mind, but Soul also . My Soul is absorbing your teaching. May divine Mother bless all of us... Pranam 🙏🙏🙏Guruji
sir, apne btaya nhi abhi tk ki kese kr skte hai pivot table ko completely use sirf keyboard se . please bta dijiye na agr pta hai to. agr nhi pta to it's ok khi aur se pta kr lunga.
Isme batana kya hai Deepak ji pivot creation using mouse using keyboard dono kr skte hain..jaise mouse me drag krte hain waise keyboard se ctrl and ahift key konuse ktte hur field placing krte hain. Ye aapne bht badhiyan line likha hai ki pata hai to bata dijiye nhi to kahin aur se pata kar lunga👍
@@Innozant sir, but keyboard se pivot table ki field me kese jayenge. uske liye konse shortcuts use kre keyboard se. mouse se to simply drag and drop krke ho jata hai but keyboard se sb try krke dekh liya nhi hota. sir please thoda detail me bta dijiye nhi to ispe koi video hi bna dijiye pivot table wali series me. alt and tab key press krne se to ribbon and tabs me hi ghomte rehte hai but pivot table fields me to ja hi nhi pate. to fir kese unhe select and drag krenge field areas me. ye hai meri problem. ese smjh nhi ara sir.🙏
@@Innozant sir mera kl interview tha 1st round clear ho gaya h next round ke liye 2-3 din me cll ayegi mis executive ke liye technical round dena h plz agr apse prsnl baat ho jayegi to Meri help ho jayegi to Plz apna prsnl contect No De digiye
I m from Patna (Bihar) worked more than eighteen years as a Lead / Document controller manager. Really appreciate and thank you Sir, you said valuable things, not just for getting a job but also for a successful life
Dear sir, I require to learn advance ms access. Please make video and you also made few video of VBA. But I require full playlist of it. Please make.
Sir ap sey Acha koi nhi samjhaa sakta Thanks
U r great sir mujhi smj aya achy sai
Best...
Itna easy tarika se koi nahi samjhata hai..
Thanks
BHOT ACHE SIR KEEP GOING ....
Thanks Devender ji
bahut hi achhha sikhate hai Aap.dhanywad.
you are just amazing....way of teaching ...Awosome.....😃😃😃😃😃😃
bahot he nice concept hai sach m aaap k student khush naseb hai jo phyical class join kr rhy hain kiya baat hai sir aaap ki sach muje udemy m paise kharch kr k itna kcuh samaj nhe paya jis m....par aaaap k vidoes say bahot bahot bahot labh mil rha hai bs dua kijyega muje acha rasta mile main agee new job k liye apply kr paon aaap ki dua say
Thanks dear..jaroor hoga apke career me enhancement ...acha kroge aap life me..bht mehnat kar re ho..wo dikhne laga hai mujhe .happy learning
@@Innozant bs dua kijiyega aaap sir sub k liye
@@sawaimalhi8439 to bro job lagi
@@fmsaifi5565 yes bro
@@sawaimalhi8439 kisme work krte ho excel me aur bro salery kya he..
Mast Introduction of Pivot Table. Thank You, Sir
Thanks
Sir I really like you all method 🔥🔥
Wow sir behtarin explanation 🙏🏻
Thanks dear
Thank ❤❤ you so muchh Sir Concept Clear karne ke liye..
Boss ur simple amazing I am a beginner in this n I m following all ur videos and have learn it n stl learning it keep up the gud wrk
Thanks dear.
really means a lot to me❤️
Your all videos are best , your way of explanation is also best
Thanks Sandeep 😊...ji
Thanks Sandeep ji..Tc..gn
Excellent teaching with good content
Thanks Syam for valuable comment ❤️🙏
you are making my life easy
Thanks Dilip
Did you copy a data of noorain Ansari ? As the "pillars of pivot table "explained by him in his class many years back.
Excellent, like the way you teach.
Thanks Rohini..God bless you
Best channel and best samjhaya sirbapne
Thanks dear
One of the best teacher, thank you
Informative and useful video
Thanks Jaspal Ji for your valuable comment
Thank you sir aap ki teaching awesome thank you so much
Very nice video..... Thank you very much sir... Dil sa salute hai aap ko..?
thanks a lot sir
sir ,i love your teaching style .... very good ..thank you :)
Thanks Sreejee..keep exploring
very help full
I just love all your lectures and it seems my journey of searching for the best tutorial videos ends here!
Thanks Bhavesh ji..God bless you .. happy Learning ♥️
Outstanding teaching sir Hart's of thank
Thanks
Dear Sir your videos are too much helpful to me, and I am very thankful to you for your videos.
I face a problem regarding pivot table.
I would like to change position of pivot table column, but I can't do so.
Please help me.
Thank you sir for explaining the theory so simple and in easy way with practical too.
Thanks Shwet ji❤️
Sir mai bas itna bolna chahunga ki..mai jo v kuch sikha hu wo apse sikha hu sir 🙏🙏 aap mere guru h
Keep growing.God bless You dear
Best wonderful teaching innocent
great explain sir
Pivot table & its options are very well explained in the most simple manners .No one can described better than what you have done . Thx.
My request is that please add one more step in the same video. That is " Cleansing of raw data " before going towards for the creation of Pivot table . All efforts will go waste if raw data is not displayed properly.
Pivot table would give distorted summary & so the data analysis.
Clearing of raw data becomes more necessary when such data's are imported from many sources & in many types of file .
Thanks Jagdish ji for your valuable feedback and appreciation. Thanks for your data cleaning suggestion as well.Kindly note we created a seprate Playlist of Powrer query for the same.Happy learning.
Best tutorial I have ever seen
Sir Pls can you make full tally prime tutorial
Thanks
Shandar teacher hain aap janab, VBA p bhee aik detailed playblist agar buna daywain to meherbani howay gee,
VBA and Power bi series starts.Kindly find playlist for the same
Thanks
Excelent taching method. Thank yo so much.
❤️❤️❤️🙏
Superb Sir..
U explained well sir.. Waiting for next video...
Very good video❤❤❤❤
Very nice explained 👍
Thanks Ali
Very nice sir ji 👍
Nice video sir 😇
sir, just wesome your teaching style, very esasily understood your job, heartly thanks this channel & you also. I have two colmns data set. 1. sales person 2. sales amount, I want to get specifiq value (e.g.">=5000") only pulling in pivot table. is it possible ? please help.
Yes using calculated field ...pura series dekhiye khud answer mil jayega apke sawal ka
nice video sir thank you
👍🏻👍🏻 like kardiya sir
Thank you sir
Thank u so much 🥰
Very nice !!!
Thnk u sir ❤️
Shabbir - Excellent
very nice sir
Thanks sir for the pivot table playlist.
Thanks Satish ji🙏❤️
kash class lagne se pehele aapak videos dikh jate to
mere paise barbaad na hote ... ur veery good teacher ur explaination is like cherry on cake
Thanks Nandini..koi baat nahi...aap sequence me course kariye channel se apko jarurat hi nahi hogi kuch aur karne ki..God bless u..keep learning ❤️👍
@@Innozant currently waching ur pivot table playlist its 😍 sir
@@nandiniikhankar8397 Great..Keep Learning 👍❤️
Thank you sir ❤🌹🌹😊
Thanks Ravi
Hi ,
loved the way you explain topics. Very useful trips and tricks. Can you share the link to learn sql, python and R Please......
Thanks Rajni...Soon you may able Leaen Power BI and sql with us
Love you ❤️
Daily apka vedio dekhta hu aur office me try krta hu
Thanks Rajat Ji..Happy Learning dear
Tumhari salery kitni h bro
I love you sir kya padhate he 😄 😊😊👍
♥️
Very Nice
Thanks dear
sir do you have series in pivot table so that i can learn
Hi Kriti , Complete playlist of Pivot table is there .you may find seprate playlist of Pivot table and learn in sequence
bhut badiya
Thanks Arri..Apko baat krni thi? Innozant website se contact number leke aap WhatsApp kar lena aap
Good
Nice video!
NICE AND GOOD. MAY I HAVE A FILE , SIR?
Great sir
❤
Thankx
Good
👍👍❤️
Sir ap cube formulas ka format bna rahay hay plz reply
Haan banayenge cube par video
Sir aap excel ka kon sa version use karte ho
Ye office 2016 hai ab office 365 krte h use.
hello sir can we do that pivot table without mouse also
Yes we can..kindly watch our pivot table shortcut videos for the same
Hii Sir,
Pivot table file drive link not working, could you please solve it.
Pranam Gurujii... I noticed a unique feature, but good feature, of your personality. You prefer to wear T-shirt over Shirt. You wear Shirt in this video. Just noticed, that's why sharing... Pranam🙏🙏🙏 Gurujii
❤️❤️❤️ Thanks Hemant Ji..Hope you are enjoying learning journey with Innozant
@@Innozant Yes Guruji, You not only teaches mind, but Soul also . My Soul is absorbing your teaching. May divine Mother bless all of us... Pranam 🙏🙏🙏Guruji
You are doing very well🔥🙏🏻🙏🏻
Thanks Nandu❤️❤️
Sir aap apni video ke end mey next video ka link de dena, toh phir step by step video dekhne mey asan hoga.
Dear Already Playlist ke in sequence videos hain harek playlist ke liye
sir next video bna do pivot ki nice video sir
link not working
DownloadPivot Table Practice File
🙏🙏
Sir pivot table ka practice set not found dikha raha hay.pls help.practice nehi karungi to problem hogi sir
Hello Sayani,
Direct link be kej ho gya hai ,aap master assignment link hai use open kriye comple playlist wise assignment hain saarre available
@@Innozantok..thank thank you so much sir🙏 download kar liya maine
Sir pivot Pura Kar dijiyega .
Sir....file download ni ho rahi h...link se pivot table ki
Assignment master folder se kar lein download
sir, apne btaya nhi abhi tk ki kese kr skte hai pivot table ko completely use sirf keyboard se .
please bta dijiye na agr pta hai to.
agr nhi pta to it's ok khi aur se pta kr lunga.
Isme batana kya hai Deepak ji pivot creation using mouse using keyboard dono kr skte hain..jaise mouse me drag krte hain waise keyboard se ctrl and ahift key konuse ktte hur field placing krte hain.
Ye aapne bht badhiyan line likha hai ki pata hai to bata dijiye nhi to kahin aur se pata kar lunga👍
@@Innozant sir, but keyboard se pivot table ki field me kese jayenge.
uske liye konse shortcuts use kre keyboard se.
mouse se to simply drag and drop krke ho jata hai but keyboard se sb try krke dekh liya nhi hota.
sir please thoda detail me bta dijiye nhi to ispe koi video hi bna dijiye pivot table wali series me. alt and tab key press krne se to ribbon and tabs me hi ghomte rehte hai but pivot table fields me to ja hi nhi pate. to fir kese unhe select and drag krenge field areas me. ye hai meri problem.
ese smjh nhi ara sir.🙏
Alt J+T+L
Uske baad jis field ko rakhna hai pivot table me use space bar se select kren
@@Innozant Ok sir ji
thank you so much
yhi shosrtcut chahiye tha. bhut dino se ise dhundh rha tha but nhi milra tha.
thanks a lot🙏
sir ji pivot Table Practice File is not download, please provide the same
Kindly download it from master assignment link where all playlist are there
Apka video jabardast he lekin drive me se file dhund ne bahut dikkat hota he..kindly drive me konse location me he wo bhi likh dijiye.. plzzz
ok direct link update kar deta hu file ka soon.
sir,practice file open nhi ho rhi hai
Master assignment file link se download kar lijiye
Ap ho to excel h aur job h
Thanks for your valuable feedback dear
@@Innozant sir mera kl interview tha 1st round clear ho gaya h next round ke liye 2-3 din me cll ayegi mis executive ke liye technical round dena h plz agr apse prsnl baat ho jayegi to Meri help ho jayegi to Plz apna prsnl contect No De digiye
best of luck dear...Koisa hua interview ye batana..
@@Innozant hr round ho gaya h sir bss technical round hona h plz help kr digiye as a prsnlly sir
@@The_Rajat_ bro..Excel me job lagi
Sir ..pivot table ka data file kaha se milega
Already rakha hua hai assignment master folder me..Link available in video description
404 ka error aa raha hai
Sir
pivot table ko heart of excel kyun kaha jaata hai sir
Offcourse reporting ka saara kaam pivot se...
Ye row data sir mare pass 2011 se hai ansari sir ke pass se
⭐⭐⭐⭐⭐
sir coarse ka fees affordable nahi hai.............................
Aap video course le sakte hain ya channel se bhi padh sakte hain
Thank you sir
Thanks dear ❤️🙏
Very good
Very nice
Thanks Sonika..Keep learning 👍👍❤️