Consolidation in Excel (Hindi) | How to Consolidate Data in Excel

Consolidation in Excel (Hindi) | How to Consolidate Data in Excel
In this video tutorial you will learn how to consolidate data from multiple worksheets in a single worksheet without using any funciton. Actually there is a seperate option in data tab for data consolidation. You can consolidate data very quicky by using this option and the beauty of this is that the output data will be connected to the source data. Whatever change occurs in the source data, the output data will be automatically updated.
✅For more videos please subscribe our channel: / powerexbyjitendra
Sample workbook:
==============================
docs.google.com/spreadsheets/...
==============================
Playlists of our top videos:
1. Stock Management System in Excel
• Stock Management Syste...
2. Advanced Excel Formulas
• Advanced Excel Formulas
3. Awesome MS Word Videos
• MS Word
4. Conditional Formatting in Excel
• Conditional Formatting
5. Data Entry Form
• Data Entry Forms
6. Custom Number Formatting Tricks
• Custom Number Formatting
7. Recent Uploads
• Recent Uploaded Videos
8. Best Excel Shortcut Keys
• Best Shortcut Keys in ...
9. Power Query Tutorials
• Advanced Excel Power Q...
10. MIS Report in Excel
• MIS Report
11. Excel PivotTable
• Excel Pivot Table
12. Task Tracker or To-Do List
• Task Tracker or To-Do ...
13. Excel for Accounting
• Excel for Accounting
14. Excel Lookup Functions
• Excel Lookup Functions
15. Filter
• Filter
-------------------------------------------------------------------
Video is created by Jitendra
Published on Powerex by Jitendra
Language of this tutorial is Hindi.
#consolidationinexcel
#powerxbyjitendra
#excel
Subscribe on Telegram:
t.me/powerexbyjitendra
Contact Us:
Instagram: kumarjitendra11...
Facebook : / powerex-by-jitendra-10...
Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for 'Fair Use' for purposes such as criticism, comment, news reporting, teaching, scholarship, and research.
Fair use is a permitted by copyright statute that might otherwise be infringing.
Non-profit, educational or personal use tips the balance in favor of fair use.
Thanks

[@lakshmimn6820]

Thank u for sharing your knowledge in simple ways

[@apuchowdhury580]

Jitendra Bhai - to the point, no frills & very practical. Do keep it up & continue the series. Thank you so much.

[@NidhiNikhilSethi]

My channel name is: IT Computer Capture

[@TheMharrissiddiqui]

Excellent

[@hellokids1817]

Sir, now we can do table also in sheet 4, awesone❤🎉

[@SuvarrnaM]

very useful excellent sir, thank you very much

[@NidhiNikhilSethi]

My channel name is: IT Computer Capture

[@baharali7429]

Very informative video Sir

[@PowerExbyJitendra]

Thanks🙏

[@tvenkataramanarao5526]

Jitendra ji thank you for sharing this valuable information explained in an easy to understand manner

[@PowerExbyJitendra]

Thank you sir

[@NidhiNikhilSethi]

My channel name is: IT Computer Capture

[@rpmasti.in0]

Sir data analysis par video banay

[@thyjeet]

Thank you Jitendra ji

[@PowerExbyJitendra]

Welcome sir

[@understandthewordsfeelthes3036]

Helpful information 👍👌

[@PowerExbyJitendra]

Thanks a lot

[@understandthewordsfeelthes3036]

Well Explain 👍👌

[@PowerExbyJitendra]

Thanks🙏

[@Shantanu965]

❤❤ love you sir ji

[@PowerExbyJitendra]

Thanks a lot bro

[@Narayan14.]

Superb 👍👌👌

[@PowerExbyJitendra]

Thanks a lot

[@shreeofficialbjr]

Great job

[@PowerExbyJitendra]

Thanks

[@khazaraheemsyed3283]

The consolidate function will work with different range data in different sheets?

[@yashodak1909]

Is there a way to consolidate the data in one file if it is in different files instead of different sheets?

[@baharali7429]

Very nice and very helpful vedio sir, Sir aik vedio transport business management in excel py bhi Banao sir thanks ❤❤❤

[@PowerExbyJitendra]

OK thanks 🙏

[@sangeetabhatnagar738]

Excellent teaching

[@PowerExbyJitendra]

Thanks a lot

[@biswajitkaran89]

Very very useful and informative Sir. Sir your every video is very attractive. ❤❤❤

[@PowerExbyJitendra]

Thank you so much 🌹thanks🙏

[@davidsonsunny2886]

Good info

[@PowerExbyJitendra]

Thanks

[@syedikramullah1114]

Superb sir

[@PowerExbyJitendra]

Thanks a lot

[@brightcomputertechnologych4872]

VERY GOOD

[@PowerExbyJitendra]

Thanks a lot

[@asmagadwale5541]

Amazing 😊😊😊

[@PowerExbyJitendra]

Thanks a lot

[@baigsufi321]

Very good

[@PowerExbyJitendra]

Thanks

[@offcialsupervisor758]

thanks

[@PowerExbyJitendra]

You're welcome!

[@ahp6131]

Hello, how do you calculate product cost ?

[@jayanthamadasekera8248]

Please explain how to write vba code to unlock and lock for macro recording sheet in your debit credit balance sheet video.

[@PowerExbyJitendra]

Watch it : kzbin.info/www/bejne/p5nKhIlja9Bmfa8si=3tT5WnjiWezfCLX5

[@jayanthamadasekera8248]

Thank you so much for your quick responce. Explain very clearly. If you can insert caption in english it will very helpfull for every one out side India.

How to select combination of any 10 numbers from 20 numbers such that the product of select d 10 numbers maximum or minimum?

[@dj_gameshow8058]

Use Max or Min function in combination with Product function

[@rpmasti.in0]

Sir advance excel par video banaye jo office me use hota hai

[@PowerExbyJitendra]

I have so many videos please watch

[@mahammadsamsuddin7606]

Sir, ropa 2019 ka ek automatic salary calculator jismay pay matrix vi hoga eisa ek video banay. Please.

[@Deependra1991]

Product k sat qty n price hoto kese hoga har month ka subtotal consolidation m

[@abuzarshaikh4583]

Wo primary sheet m colum add kr lo na too final sheet m b wo colum add ho jayega (mtlb jo b krna h primary sheet m set kr lo)

[@NidhiNikhilSethi]

Channel kese monitor Hota h

[@PritamPaul717]

🙂🙂🙂🙂❤❤❤❤❤👍👍👍👍

[@PowerExbyJitendra]

Thanks a lot

[@sonusarraf5193]

Hello sir compound interest par video banae

[@PowerExbyJitendra]

Zaroor

[@podamaire]

SLect karenge

[@picnicpoint9129]

Mary pas online sheet hai jis mai dropdown lagy hovy hai wo sheet agar mai waha sy dosri sheet mai paste karta hon to dropdown show nhi hoty ..ye kaisy hoga

[@PowerExbyJitendra]

Nahi hoga apko dobara create karna hoga

[@divms_23]

Importrange formula try kariya

[@NidhiNikhilSethi]

Agr apko next sheet par bhi list icon lage hue tabular format m data chahiye to aap paste special b to try kr skte ho. My channel name is : IT Computer Capture

[@yourvikram]

Hello bhaiya Mai Jharkhand se hu aur ek chhota sa cyber cafe chalata hu. Maine apki ek video ' Fully Automated Report Card' dekh k ek school ka report card banane ka order le liya hu but uski requirement ke anusar bana nhi pa raha hu. Kya aap help kr sakte ho.

[@PowerExbyJitendra]

I will contact you please share your mobile no on my Facebook page

[@sonusarraf5193]

Jisme time 2.5year ho

[@rahulsarangal8123]

Nice bt sir agar sheets 50 se jyada ho tab kya kate

[@PowerExbyJitendra]

No issue process will be same but you can do it quickly using Power Query. .

[@muhammdliyaqatali7352]

Answer please

[@rahulsarangal8123]

@@PowerExbyJitendra make relevant video if possible

[@PowerExbyJitendra]

In this case we use Power Query you check out our playlist of Power Query

[@user-hi3hp9us2k]

एक शीट में A to Z कॉलम में डेटा है , उस डेटा को मुझे रोज अपडेट करने पड़ता है । मेरा प्रॉब्लम ये है कि आ सेल का डेटा B में , Z का Y में,..पेस्ट हो जाता है । ऐसा कोई condition लगा करते है ,A कॉलम में एक सेल का वैल्यू को फिक्स कर के डेटा पेस्ट कर दे तो डेटा चेंज नही होगा ।

[@NidhiNikhilSethi]

My channel name is: IT Computer Capture

[@PowerExbyJitendra]

Best wishes for your channel.

[@understandthewordsfeelthes3036]

Helpful information 👍👌

[@PowerExbyJitendra]

Thanks a lot

[@AbdulRehman-wp9xt]

Excellent

[@PowerExbyJitendra]

Thanks a lot

[@adityabhandari9259]

thanks

[@PowerExbyJitendra]

Welcome