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

Рет қаралды 303,305

5 ай бұрын

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

Пікірлер: 85

@lakshmimn6820 16 күн бұрын

Thank u for sharing your knowledge in simple ways

@apuchowdhury580 3 ай бұрын

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

@hellokids1817 Ай бұрын

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

@TheMharrissiddiqui 3 ай бұрын

Excellent

@tvenkataramanarao5526 3 ай бұрын

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

@PowerExbyJitendra 3 ай бұрын

Thank you sir

@NidhiNikhilSethi Ай бұрын

My channel name is: IT Computer Capture

@rpmasti.in0 5 ай бұрын

Sir data analysis par video banay

@baharali7429 5 ай бұрын

Very informative video Sir

@PowerExbyJitendra 5 ай бұрын

Thanks🙏

@SuvarrnaM 3 ай бұрын

very useful excellent sir, thank you very much

@NidhiNikhilSethi Ай бұрын

My channel name is: IT Computer Capture

@thyjeet 3 ай бұрын

Thank you Jitendra ji

@PowerExbyJitendra 3 ай бұрын

Welcome sir

@biswajitkaran89 5 ай бұрын

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

@PowerExbyJitendra 5 ай бұрын

Thank you so much 🌹thanks🙏

@khazaraheemsyed3283 16 күн бұрын

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

@understandthewordsfeelthes3036 5 ай бұрын

Helpful information 👍👌

@PowerExbyJitendra 5 ай бұрын

Thanks a lot

@understandthewordsfeelthes3036 5 ай бұрын

Well Explain 👍👌

@PowerExbyJitendra 5 ай бұрын

Thanks🙏

@Shantanu965 3 ай бұрын

❤❤ love you sir ji

@PowerExbyJitendra Ай бұрын

Thanks a lot bro

@sangeetabhatnagar738 3 ай бұрын

Excellent teaching

@PowerExbyJitendra 3 ай бұрын

Thanks a lot

@Narayan14. 5 ай бұрын

Superb 👍👌👌

@PowerExbyJitendra 5 ай бұрын

Thanks a lot

@baharali7429 5 ай бұрын

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

@PowerExbyJitendra 5 ай бұрын

OK thanks 🙏

@shreeofficialbjr 4 ай бұрын

Great job

@PowerExbyJitendra 4 ай бұрын

Thanks

@ahp6131 2 ай бұрын

Hello, how do you calculate product cost ?

@syedikramullah1114 5 ай бұрын

Superb sir

@PowerExbyJitendra 5 ай бұрын

Thanks a lot

@davidsonsunny2886 5 ай бұрын

Good info

@PowerExbyJitendra 5 ай бұрын

Thanks

@asmagadwale5541 3 ай бұрын

Amazing 😊😊😊

@PowerExbyJitendra 3 ай бұрын

Thanks a lot

@brightcomputertechnologych4872 5 ай бұрын

VERY GOOD

@PowerExbyJitendra 5 ай бұрын

Thanks a lot

@jayanthamadasekera8248 5 ай бұрын

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

@PowerExbyJitendra 5 ай бұрын

Watch it : kzfaq.info/get/bejne/p86Xhrlem9GXd4E.htmlsi=3tT5WnjiWezfCLX5

@jayanthamadasekera8248 5 ай бұрын

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.

@offcialsupervisor758 5 ай бұрын

thanks

@PowerExbyJitendra 5 ай бұрын

You're welcome!

@baigsufi321 4 ай бұрын

Very good

@PowerExbyJitendra 4 ай бұрын

Thanks

@rpmasti.in0 5 ай бұрын

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

@PowerExbyJitendra 5 ай бұрын

I have so many videos please watch

27 күн бұрын

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 4 күн бұрын

Use Max or Min function in combination with Product function

@Deependra1991 4 ай бұрын

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

@abuzarshaikh4583 4 ай бұрын

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)

@mahammadsamsuddin7606 5 ай бұрын

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

@sonusarraf5193 5 ай бұрын

Hello sir compound interest par video banae

@PowerExbyJitendra 5 ай бұрын

Zaroor

@NidhiNikhilSethi Ай бұрын

Channel kese monitor Hota h

@PritamPaul717 2 ай бұрын

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

@PowerExbyJitendra 2 ай бұрын

Thanks a lot

@podamaire 3 ай бұрын

SLect karenge

@yourvikram 5 ай бұрын

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 5 ай бұрын

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

@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

@user-hi3hp9us2k 4 ай бұрын

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

@sonusarraf5193 5 ай бұрын

Jisme time 2.5year ho