Your smiling face is always keep us happy.. love u sir

You are the best teacher of my excel thanku very much sir

Dear sir you have very clear and Crystasl Concept thanks a lot once again, just kerp it up

@Innozant

3 жыл бұрын

Thanks Rohit...

You are the master of Excel , You are the Arjuna of Excel ❤️

@Innozant

2 жыл бұрын

❤️❤️😊 Thanks Suraj.Gid bless you Happy learning ❤️

best teacher award goes to uu sirrrrr

झा जी बहुत नीक ज्ञानवर्धक प्रस्तुति।

@Innozant

9 ай бұрын

Hahaha..Thanks dear .😊

Aapne mere sabhi consept clear kar diye sir thanks

@Innozant

3 жыл бұрын

Thanks Dheeraj ji appreciate karne ke liye mere mehnat ko.

Nice and Thanks Sir 😊

Appreciate your dedication toward work

Really marvellous - Sir, Very Informative and time-saving tricks.- Appreciate the way you teach. -thanks

@Innozant

7 ай бұрын

Thanks

Wah Sir, Khush raho, kya khoobsoorat tareeqey sy samjhatey hn. Zinda Bad. God bless you Sir. Allah Hafiz.

Very appreciable,voice, presentation skill nd deep insight of Excel sheet,I will see nd learn more from your other videos...Thnku sir 😊😊👍

Sir aap ki roz main ek video dekti hoon, jis se ab kaam karne main maja aata hain. You are great sir.

You are a great teacher, and got avery sweet voice👌👌

@Innozant

Жыл бұрын

Really means a lot to me dear Kishan

Shukriya sir extra knowledge ke liye😊

superb bhai i cant understand hindi but i received content of the grouping pivot . thank you .excellant class

@Innozant

2 жыл бұрын

Thanks Nagur.Happy learning 🙏❤️

Very nice video sir..

I watch all video thanks sir

@Innozant

3 жыл бұрын

Thanks..Watch and learn step by step ..all playlist m👍♥️🙏

you rock sir I so much disappointed from excel but after watching your videos I once again motivated to learn excel 😊😊😊

@Innozant

10 ай бұрын

Keep learning,

Tussi Cha gye Paaji... absolutely insane

@Innozant

2 жыл бұрын

Thanks ..God bless You

I thought I would know a lot about pivot tables. I was not aware of many unaddressed topics related to pivot tables. However, I chanced upon this channel.

@Innozant

7 ай бұрын

Thanks Dear.Keep learning

sir you are awsome

Thank you sir 😊😊😊

God of execl❤

Superb sir and thank you 🙏

@Innozant

3 жыл бұрын

Thanks Bhaskar ji

You are doing an amazing job selflessly...I salute your efforts and dedications towards it...Keep it up...

@Innozant

Жыл бұрын

Thanks Rajan.. Really means a lot to me dea..Happy learning 👍❤️

thanks a lot sir

Very nice ✔️

Thank you so much

Great... Thank you so much sir

@Innozant

2 жыл бұрын

Thanks Sameena.. Recommend you to start your learning journey in sequence From Basic Excel onwars then sorting,filter,adv filter,subtotal ttc,Data Validation ,Array & Sumproduct ,Lookup series ,Chart ,Pivot table followed with dashboard. In sequence playlist are available in video description Master assignment excel exetcise are already there for your practice. ❤️🙏

Exllent sir ji

very nice sir

Thankyou very much sir you are doing a great job thank you very very very much once again.

@Innozant

Жыл бұрын

🙏❤️

I like the explanation part..nicely explained

@Innozant

Жыл бұрын

Thanks Narayan

Excellent

@Innozant

2 жыл бұрын

Thanks

good video.

superb

Awesome sir.

@Innozant

2 жыл бұрын

Thanks dear❤️

Superb

nice teaching

Very well explained sir👍

@Innozant

3 жыл бұрын

Thanks Aakriti,Hope you learn from there.Happy learning..Good Night.tc

kiya baat hai sir first time ye concept suna hai main classic pivot ka kiyn k kabi b muje udemy k teacher say nhe mila ye concept

@Innozant

3 жыл бұрын

Thanks Sawai..Happy Learning

Amazing

Thankx

Recently got an offer as Reporting Analyst, your videos helped me a lot thank you sir

@Innozant

Жыл бұрын

Congratulations..Have a wonderful career ahead

@gavidiharish13

Жыл бұрын

@@Innozant Thank you so much sir

Fantastic sir

@Innozant

2 жыл бұрын

Thanks dear

Great teacher ❤️

@Innozant

Жыл бұрын

Thanks Monalisha.. Really means a lot to me

Operation Of Pivot Table 🔥🔥🔥

@Innozant

3 жыл бұрын

yes😀

👌👌❤

Sir, Very Informative and time-saving tricks. Request to share tutorial video for grouping with 15 days and weekly basis. it will help in understanding sales value lower, higher for particular weeks of months.

@Innozant

2 жыл бұрын

Thanks

@harishacharya3022

2 жыл бұрын

👉

Excellent sir g

@Innozant

4 жыл бұрын

Thanks Bhoopendra,Keep watching and enhance your skills

Very nice 👍

@Innozant

Жыл бұрын

Thanks dear

Great 👍

@Innozant

3 жыл бұрын

Thanks 🙏❤️

Hats off sir

@huzaifakanakgeri7142

2 жыл бұрын

Brilliant

@Innozant

2 жыл бұрын

Thanks dear

very nice

@Innozant

2 жыл бұрын

Thanks

Nice

Good

Nice 👌

@Innozant

3 жыл бұрын

Thanks Ram,Bade dino baad?Kahan the

Thanks

@Innozant

3 жыл бұрын

❤️🙏

Osm

@Innozant

2 жыл бұрын

Thanks Sharma Ji .Happy Learning ❤️

🙏🙏🙏🙏

@Innozant

3 жыл бұрын

Thanks Ravi

Nice sir 👍🏻👍🏻👍🏻👍🏻

@Innozant

2 жыл бұрын

Thanks Vijay Ji

@vijaysahal4556

2 жыл бұрын

@@Innozant hi sir I have some query I cnt solve it so plz hlp me I have some small data set nd also allready result there but I cnt understand Topic here is how cn share my data set wid you I hve no your whatsup

Thanks a lot dear Tainer. I am from Bangladesh. Newly subscribed your channel. Really your teaching I am enjoing and learning more. I have question, hope will get answer. Can It is possible to mearge advance table cell?

@Innozant

2 жыл бұрын

Yes we can merge tables using PQ method

Dear, show us how to make % of Target vs Achievement. Thanks

Itna Deeply Kisi Ne Kabhi Nahi Bataya Pivot Table Ko, Pivot Table Mai Sabhi Raw Data Ke Base Par MIS Create Karke Batate Hain, Lekin Aap Pivot Table Use Kaise ki jaati hai wo sikhate hain. 💞💞💞

@Innozant

3 жыл бұрын

Thanks Pawan ji...Kyunki main aplpgon ko complete course Kara raja hu na ki views badhane ke liye sports videos ya tricks videos banana hai😀Halpy learning..seekhiye aur life me age badhiye

⭐⭐⭐⭐⭐

@Innozant

3 жыл бұрын

❤️🙏

Sir how to insert row and column in existing pivot table? Plz guide me sir with example

Can you please make us understand "how to make the data in week wise"..??

What version was the monthly & week & group pivot table video in. I liked the video very much but I have got a lot tp learn for us Give you mobile number Explaining pivot table in more detail Because I am preparing for job from this video channel Also tell about how the data should be

Wah . Maja Aa gaya. But Sir still work on volume please.

@Innozant

3 жыл бұрын

Thanks..Volume is fine now..you may check in latest videos

Dear sir We can apply classical layout or do same in google sheet. Pls let us to know.

@Innozant

2 жыл бұрын

Jha ji soon you may able to leanr comple Google sheet

Please tell me sir it needs any tool for create pivot table group like weekly, monthly ,yearly.

@Innozant

3 жыл бұрын

No dear ,pivot table is used to group the data as per your requirement

i am usuing excel 2013 but grouping is not working...unable to use this trick

Error showing in my excel as "cannot group that selection" please help My formatting of date is correct mm-dd-yyyy

Where is your coaching centre sir

@Innozant

Жыл бұрын

Delhi

East or west Innozant is best

@Innozant

5 ай бұрын

Thanks

Sir how to grouping financial year month wise ie April to March

date format are correct but date group but showing cannot group that selection ...plz help ..

Sir, pivot me har name ke numbers ke baad total aa raha hai kaise remove hoga..please bataye

Sir mere laptop me grouping function not working what i do now

sir, how to do grouping in week wise?

@Innozant

3 жыл бұрын

Jha ji already karaya hua hai grouping..pivot table series dekhen.. grouping ..

Hello Sir, I want my Qtr1 starts from April. What to do?? Pl help

@pramodbhatt6906

2 жыл бұрын

Sir, Waiting for your reply

Sir , second example me jab group karte hai right click karke tab "cannot group that section" message reflect hota ,

@sumanjoshi990

2 жыл бұрын

Mera bhi please reply

my grouping function is not working pls help

Sir formula kesa lgate hai

@Innozant

2 жыл бұрын

Wo to situation par depend krta ha apki kya requirement hain

Same source data se 2 pivots ko alag alag kaise group karen? Ek ko ungrpoup karne se dusra ungroup nahi hona chahiye.

@Innozant

2 жыл бұрын

Kisi video me explain kar denge Balwan ji

Matlab agar layout ko hatana hai to?

Sir to hmm classic ka use kb krege

@Innozant

2 жыл бұрын

Apki requirement ke upar depend krta h

Sir mera sawal tha ki. Humara financial year jo Hota he april se start hokar march par khatam hota he. Par hum jab pivot banate he. Toh wo jan uppar or dec. Last me batata he. Jabki humara jo dec. He 2020 ka he or jan 2021 ka. Toh hum kese use april se march show kare. Plz tell me.

@Innozant

2 жыл бұрын

Add extra column using in pivot using set value

@vishalbhati912

2 жыл бұрын

@@Innozant sir aap plzzz koi video banake samjhayenge ispe. Q ki ye office work k liye bahot useful he.

Y can't do grouping on my excel sheet.

@Innozant

3 жыл бұрын

Are you asking your query or challenging😀

Sr pivot table copy paste keise krte h uski shortcut plz btae

@Innozant

2 жыл бұрын

Jaise normal paste krte hain .ya paste special..Ctrl alt v

@tarun_k_shorts

2 жыл бұрын

@@Innozant kisi Kuch particular customer ka data pivot table me se copy krke another sheet me paste krte h to different ata hai (apne kisi ko comment me btaya bhi tha paste special se or sort cut se both bta dejiye}

@tarun_k_shorts

2 жыл бұрын

@@Innozant paste special

Sir hum date par hi grouping kar rahe toh error aa raha cannot Group that section., jab tak yeh solve nhi hoga hum aage nhi jayenge ,kyoki ki humne jab age k video dekha toh usme bhi yehi error aa raha tha

@Innozant

2 жыл бұрын

Data format check kijiye..wrong date format hoga to erro aayega..proper date format hoga tabhi to date group hoga dear

option nhi aaye to kya kare. Grouping option nhi aa rha h dropdown mei

@Innozant

6 ай бұрын

Kyu ?kaunsa version h

Sometime field list show nhi hoti what is the short cut key ?

@Innozant

Жыл бұрын

Click on pivot table -analize tab-field list is there or Press F6

Sir mujay outstanding report bannni hai for example 31 August tak mari outstanding thi 1000000 or September may billing hue 1lakh or September may recovery hue 8 lakh toh y kasy manage kary jissy balane outstanding amount show ho

@Innozant

2 жыл бұрын

Mujhse kya help chahte hain detail me explain kijiye ek baar

sir yeh toh hame bhi aata h but mujhe Quarter ( Apr to mar chaiye) na ki jan to dec toh wiase kaise hoga sir

@Innozant

3 жыл бұрын

Month function pass krke phle month ka custom list bna lonjis month se jis month tak chaiye phir uske base par pivot table..

@lkumar2727

3 жыл бұрын

@@Innozant Thanks Sir,,,, you r great🥰

@Innozant

3 жыл бұрын

@@lkumar2727 Thanks dear

Sr date par right click krne pr grouping nhi a rha can't group likha a rha h

@Innozant

2 жыл бұрын

Merged pivot hoga..seprate pivot kisi data par click krke bnaiye jisme dat ya time field ho..aayega group ka option dear

@tarun_k_shorts

2 жыл бұрын

@@Innozant thnx

Sir ap excel ke jadugr ho

@Innozant

3 жыл бұрын

Thanks Rajat Ji..Happy learning.

Sir agar table ko hatana hai to kaise krege?

@Innozant

2 жыл бұрын

Select layout and delete

Practice sheet download nhi hote hai koi sa bhi

@Innozant

11 ай бұрын

Video description me master assignment link Diya hua hai use link se download kariye,Playlist wise rakhe hue hain assignment