No video :(

consolidate multiple worksheet into one pivot table | How to combine multiple worksheet into one

Подписаться 151 тыс.

Просмотров 115 тыс.

50% 1

Learn how to combine/consolidate multiple worksheet into one sheet and make Pivot report based on that.
1.Learn how to create an excel pivot table based on multiple worksheet
2. Learn how to merge multiple worksheet data into one sheet
Download the Practice Workbook Direct Link
drive.google.c...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
(Playlist Folder-Excel Pivot Table-consolidate multiple worksheet into one pivot table.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
Telegram►@Innozantofficial
#pivotatable #pivottablemultisheet#Innozant #pivottablemultiplesheetintone #misexecutiveworkdetails

Опубликовано:

20 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 188

@vipuldevrani 3 месяца назад

सर आपसे बढ़िया सिखाने वाला ट्रेनर मैंने आज तक नहीं देखा अपने 10 वर्षों में जिस ईमानदारी से आप बिना फीस लिए किसी से भी सब कुछ सीखा देते हैं वो अतुलनीय है आपकी जितनी भी प्रशंशा की जाए कम है आपसे सीखकर ही मैंने एक्सेल में बहुत आएगी बढ़ पाया हूँ आपको बहुत बहुत धन्यवाद : विपुल

@AbdulKarim-ms1xb 10 месяцев назад

THANK YOU SON I AM FROM KARACHI PAKISTAN, AND I AM ABOUT 65 YEARS OF AGE BUT I REALLY ENJOYED YOUR LEARNING AND ALSO PREPARED A SEPARATE PIVOT TABLE MYSELF SUCCESSFULLY AND PREY FOR YOUR SUCCESS IN THE FUTURE I REALLY LIKE YOU

@Innozant 10 месяцев назад

Thanks ..Really means a lot to me..Keep learning

@sandeepaswal8944 3 года назад

Dear Teacher I am really grateful for your work. Thank you very much, this will save me a lot of time. These videos are probably the best training videos. You are my favorite excel teacher.

@Innozant 3 года назад

Thanks Sandeep Ji for such a valuable feedback.Have a great day ahead

@darshangohil222 11 месяцев назад

Apke jaisa Guru mil jaye to life ban Jay .Thank you Sir..

@Innozant 11 месяцев назад

Thanks .Keep learning

@gusaisingh4802 2 года назад

Ur video always simple Nd deep explain yehi chiz aapko oro se alg bnati h thnku

@atulshukal4072 3 года назад

बहोत बढीया वर्क नया देकर खुशी पाता हे धन्यवाद साहेब

@Innozant 3 года назад

Thanks Atul ji

@saurabh17sharma68 3 года назад

Mere prabhu aapko koti koti pranam🙏🙏🙏🙏🙏🙏🙏🙏

@Innozant 3 года назад

Thanks Saurabh🙏❤️🙂

@swapnilpawar708 Год назад

I don't have word for appriciate your talent dilip sirji awesome thank you for teach me that forever 🙏

@Innozant Год назад

Thanks Swapnil.. Really means a lot

@devendergusain8974 3 года назад

thnkx u verymuch sir ji watching all your videos from past15 days....

@Innozant 3 года назад

Thanks Devender Ji..Happy Learning

@Altaf_Alam Год назад

Sir Your all the contents are very helpful for me😊.....these contents are perhaps available on youtube ❤️🙏

@Innozant Год назад

Thanks dear

@pramodbhavsar4488 3 года назад

Very nice pivote table with multiple sheet and consolidate amounts in excel awsame idea thank you sir

@Innozant 3 года назад

Thanks Pramod Ji..Advance Pivot video coming soon..

@vsrjob Год назад

Outstanding style of teaching 🌹🌹🌹🙏🏼👌

@Innozant Год назад

Thanks ..Keep Learning

@saadchaudhry9110 Год назад

thanks a lot, from pakistan...keep it up bro. i was stuck and now problem solved

@Innozant Год назад

Thanks dear 👍❤️

@real5731 2 года назад

Best thing about your videos is that they are practical.... Not just showing what a perticular command..... Appreciate your efforts in not just creating example data but also explaining them 👏

@Innozant 2 года назад

Thanks dear...God bless you..Happy learning

@manjunathagangaiah6755 Год назад

I was struggling to extract data from multiple work sheets but this is the very easiest method. Your way of explanation is awesome. Thank you.

@Innozant Год назад

Thanks

@arvindtech408 3 месяца назад

Thank you sir you are best teacher

@hemantgusain1260 3 года назад

Great explanation sir

@Innozant 3 года назад

Thanks Hemant.🙏♥️🙂

@anupagarwal8347 3 года назад

Amazingly simple the way you make it!!!!

@Innozant 3 года назад

Thanks 🙏❤️

@shubhamgupta392 2 года назад

Amazing trick of consolidation data... ❤️

@shivamsinghal6020 9 месяцев назад

Gazab ho Bhai Aap!!!!!

@swadealhadecooking5587 2 года назад

Exactly Kuch na kuch new hota hai 😊🙏🏼

@Innozant 2 года назад

👍❤️

@swadealhadecooking5587 2 года назад

@@Innozant Thank u Sir 🙏

@satishojha6240 3 года назад

Wow sir amazing 😇😇 good night

@Innozant 3 года назад

Thanks Satish Ji,Practice jaroor karte rhiye.Regular.Good Night🙏♥️

@mohdhidayatullah9930 2 года назад

Dear sir its very helpful

@Innozant 2 года назад

👍❤️

@EARishiSteelTubes Год назад

Perfect on to point..! no one can forget the way you teach skills sir..!

@Innozant Год назад

Thanks Rishi..Keep Learning and exploring

@hemendrakumarvarshney8825 Год назад

Excellent way of teaching with full of energy and a smiling face.. 👍🙏

@Innozant Год назад

Thanks Hemendra ji

@shrikantbadge3978 3 года назад

Today was the last date of annual return filing for FY18-19 and 90% excel work he handed to me, ignoring senior employees. Thanks to you Sir.

@Innozant 3 года назад

M really glad to hear this from you.God bless you dear... Learning Kabhi band nhi karna hai aur Aise hi life me aage badhte rahen yhi meri wish hogi humesha .👍❤️

@UsmanGhani-vf3ow 2 года назад

Thank you very much, I am glad to seeing you're easy, knowledgeable,beautiful, relax and comfortable videos and create a confident inside me. Your way of teaching is superb and amazing

@Innozant 2 года назад

Thanks Usman..Keep Learning ❤️👍

@artiverma2357 3 года назад

GOD APKO OR APKEY PRIBAAR KO KHUS RAKHEY

@Innozant 3 года назад

Thanks Arti..Apka bhi humesha healthy brahen aur Professional life me bht aage jayen.❤️🙏

@thangaveluraj5366 3 года назад

As usual, excellent

@Innozant 3 года назад

Thanks dear

@arunssairam 2 года назад

Superb Sir

@imranahmedmirza7045 3 года назад

Excellent video...you are genius

@Innozant 3 года назад

Thanks Imran..Happy learning

@sonuharipur 2 года назад

Thank you so much.. very useful and effective

@Innozant 2 года назад

Thanks Sonu..

@sharmacreatives255 2 года назад

Ur attitude is very beautiful sir 🥰

@Innozant 2 года назад

Thanks Sharmaji ♥️♥️

@shaileshkumar-qf6bd 2 года назад

shukriya guru ji

@superNareshg 3 года назад

Thank you sir for your wonderful learning

@Innozant 3 года назад

Thanks dear❤️

@artiverma2357 3 года назад

U R MY FEVOURITE ONE

@Innozant 3 года назад

Thanks dear..No Words.m❤️❤️❤️❤️❤️🙏🙏

@krishnaaryan2903 11 месяцев назад

Amazing sir

@mgangat 11 месяцев назад

Thank you Sir

@1gopalakrishnarao 3 года назад

Excellent 🙏👍

@Innozant 3 года назад

Thanks Sir.🙏♥️🙂

@karthikeyanka 3 года назад

Thanks 😊🙏 very useful 👍tips

@Innozant 3 года назад

Thanks ❤️🙏

@PaulieVlogs 4 месяца назад

Amazing !!

@rawata185 Год назад

I love you sir

@shrikantbadge3978 3 года назад

Apke videos dekh dekh ke sir me itna sikh gaya ki ab manager bhi aata hai queries puchhne ya fir muze bulake dhimi aawaj me puuchta hai how to do this and that...:))

@Innozant 3 года назад

Sir usko bolo puchne mat ao aur agar aa bhi rahe ho toh Zara salary bhi to badhao😅ab benefits bhi uthao agar mil rahe hai Thanks Shrikant thanks a lot for this valuable comment

@mayanksharma-kw8xo 2 года назад

THANKS

@sarthakbhagu707 3 года назад

Nice sirji great

@Innozant 3 года назад

Thanks Sarthak..Good Morning.🙏♥️🙂

@hemendrakumarvarshney8825 Год назад

Superb.. 👏👏

@anubhav19888 Год назад

Bonus is best tip

@udaichahar1735 2 года назад

Thanks sir

@harsha7677 2 года назад

Thank you for sharing video. It helped us alot. Here we have one similar coloum in all worksheets. If we have two or more similar coloums in all worksheets, how to make one pivot.

@puransingh-sx2tk 3 года назад

Majedar 🙏👌

@Innozant 3 года назад

Thanks dear..Good Night.tc🙏♥️🙂

@SinghSurinder16 3 года назад

Superb sir ji

@Innozant 3 года назад

Thanks Surinder Ji❤️🙏

@mohammadarsh1492 10 месяцев назад

Excellent Sir👌 Par Sir Aapne 2 ways batae. Dono ways me Source Data to same hai par dono ke Pivot table me alag alag Sum aur Grand Total kyu show ho rha hai. Please help sir😢

@forgotten_friend5406 2 года назад

nice method

@kinghundred 3 года назад

very useful sir

@mosadiq123 3 года назад

Very good information

@Innozant 3 года назад

Thanks ❤️🙏

@g2sagar 3 года назад

Wow nice Sir.

@Innozant 3 года назад

Thanks Gangasagar

@rahulrakshe1988 2 года назад

Nice teached

@Innozant 2 года назад

Thanks dear❤️❤️

@dnyaneshwarudhare1074 3 года назад

Great sir....👏

@Innozant 3 года назад

Thanks.God bless you dear

@rahulrakshe1988 2 года назад

Nice sir

@AmanBhargava-tt7id 3 месяца назад

Awesome

@adnanshoukat807 3 года назад

hamesha ki tarhn best

@Innozant 3 года назад

Thanks Adnan..Love you all.🙏♥️🙂

@RamSingh-ol5xz 3 года назад

Excellent sir

@Innozant 3 года назад

Thanks Ram..🙏♥️🙂

@funniesbyhs903 Год назад

Sir aap ek full Course laiyye Jisme All Pivot cover ho, ek bhi cheej na chhutte..🙏🙏kyuki bank me ya aur jagah pivot bahut use hota hai, to esi video aap bna paaye to Job k liye preparation karne me aasani hogi..🙏🙏

@Nsatywali 3 года назад

Nice one

@Innozant 3 года назад

Thanks Naveen ji

@sadashivkage3133 7 месяцев назад

🙏🙏

@bishtlokesh1297 3 года назад

Wah very nice😀

@Innozant 3 года назад

Thanks🙏🙂

@pramodkumar-ke8gd 2 года назад

Great

@Innozant 2 года назад

Thanks Pramod Ji

@learningNewIdea 3 года назад

Mai apke video se bahot kuchh sikha hai aur sikh raha hun , sir please mera online interview llijiye na 🙏

@Innozant 3 года назад

Aaap proquest series attempt kijiye..online interview mujhe dene se better try kijiye opening ka..apni skills ka pata chalega aur improvement kya karna hai wo bhi

@artiverma2357 3 года назад

SUPER SE UPER

@Innozant 3 года назад

Hahaha . Thanks mera pdhaku bacha .Keep it up❤️🙏

@tanmayvt28 2 года назад

Suppose If there are around 20 column headers in one sheet and in the 2nd and 3rd sheet there are 10 column headers, then will this work?

@aritramarketing1491 Год назад

I tried it but didn't work

@prajwalshetty2047 3 года назад

Nice Video 👍

@Innozant 3 года назад

Thanks Prajwal

@prajwalshetty2047 2 года назад

@@Innozant Sir I used separate Power query to append Gross sales of various Branches to find total Gross sales and Sales return of various Branches to find total sales return in two different sheet, in one sheet total Gross sales and in other sheet total sales return. To find Total Net sales, I manually reduce sales return from gross sales. Sir is there any way to do this all calculation in power query itself.

@dhakafady774 10 месяцев назад

wow sir

@AnkitSingh-mh7ee 7 месяцев назад

Hi sir I have a question, I need multiple grand totals in Excel.i need sum and count of a data simultaneously in Excel 2016 .

@gauravbhatia7987 3 года назад

Good

@Innozant 3 года назад

👍♥️

@prahalladjena1634 2 года назад

very nice. How to calculate two different sheets in and out items in a single pivot table in MS Office and Google sheets. please suggest

@bhargavtalreja5480 Год назад

Ismien Sir agar koi cheeze "SUM" ki jagah "COUNT" leni ho ya koi aur function lena ho specific column title(parameter) k liye to kaise change karein?

@RamSingh-ol5xz 3 года назад

Nice

@waleedalqubati3849 Год назад

Habibi 🙏

@achyutsingh Год назад

how to do the reverse : split data as per region is different sheets

@ritenderchauhan3846 2 года назад

Hello - I am using excel 2016 standard version, which doesn't have a power pivot, how can I create a pivot table from two tables having duplicate values in each table, I cannot create a relationship as that would require unique values in at least one table.

@curious1245 Год назад

Sir I am facing pivot overlapping message on refreshing all pivot table. Even I have only one pivot table on one sheet. How to resolve this. Pls advise.🙏

@zzzzz644 2 года назад

Like at 01:55 in video. That shortcut key for pivot wizard doesn't work in excel 2019. what should i do??

@untilanurag2178 2 года назад

So data should be in same format to do this ?

@Innozant 2 года назад

Yes

@tasawarsultan1079 9 месяцев назад

Sir when i same work on sheet but my pivot table not shown the field name its show row column etc .kindly help me

@mayurkotecha8235 2 года назад

Sir I have a question i am not getting creating pivot table in power query load to option directly in office 2016 version is there any solution?

@adnanshoukat807 3 года назад

sir plz aik final test b hmra ly ln. ap sy jo sekha sara revise ho jaye ga.

@Innozant 3 года назад

Adnan Sahab..Abhi bht kuch seekhna hai.Aur bht Jald New Playkist Launch hone wala hai..SkillTest Series....

@adnanshoukat807 3 года назад

@@Innozant ok sir intazar rhy ga.

@ramdanech7215 Год назад

दुसरे वर्कबुक से डेटा पीवट टेबल पे ले सकते है क्या..... सर ?

@himanshuparmar1964 Год назад

WHAT TO DO FOR CONSOLIDATING MULTIPLE WORKSHEET DYANMICALLY ?

@sajansuresh60 2 года назад

How to remove the grand total in this pivot table

@ganeshdate4186 Год назад

Sir same proceed kiya lekin only value and raw aaraha he

@rounakprasad1852 Год назад

If someone updates some data in any of the workbook then will it get updated in pivot table .

@kavita8390 2 года назад

Very informative video. Sir, I have a query, I have total 3 columns , 1- country, 2- products and 3- sales when I select entire data to consolidate , product column appears as values instead of product names. How to fix this, pls advise

@Innozant 2 года назад

Thanks Kavita,Kindly share your query @innozantofficial telegram id

@kavita8390 2 года назад

Hi Sir, I have now sent my query via telegram. Thanks Kavita

@faheemtanoli2203 2 года назад

@@kavita8390 plz share answer with me, i have same query

@swapniladamapure6115 Год назад

How can edit the pivot after reporting?

@arpitasaha7854 Год назад

Sir, how to incorporate countif in pivot table?

@rekha3280 10 месяцев назад

while using consolidate pivot, I am not getting all columns name. please avice, how can i get all column names

@MegaPawan420 4 месяца назад

Mere pass 9 lakh ke 3 sheet hai Kya ek hi pivot table bana sakta hu 1 lakh se kam cells hoti hai to ek pivot ban jati hai 9 lakh pe nahi

@shambhum1829 2 года назад

Please make English video class

@vinothkumarmanoharan2317 11 месяцев назад

Hi Sir, I'm following ur works and downloading that.. that's i forgot to see your msgs..

@anubhav19888 Год назад

Why u didn't select zone in the first place. Then no need to enter name

@GaganArora090 3 года назад

Sir agar yahan data dynamic ho toh tab kya karein...PLZZ breif...do we need to convert data into table?

@Innozant 3 года назад

Dynamic ho means ya to wo table Hoga to use bhi table me convert ya wahan dynamii formula ke through Kiya Hoga to offset se data pull hone ke baad bna lenge dynamic ise bhi

@GaganArora090 3 года назад

@@Innozant sir I tried to do that by converting the raw data into table but pivot table not getting change...

@Innozant 3 года назад

Why it's change automatically..we need the make pivot dynamic na