Consolidation in Excel Hindi | How to Consolidate Data from Workbooks in Excel
Вставка
- Опубліковано 20 сер 2024
- Consolidation in Excel Hindi | How to Consolidate Data from Workbooks in Excel
Our last video was about consolidation of the data from multiple worksheets and
In this video you will learn how to consolidate data from multiple workbooks in a single workbook without using any function. 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:
==============================
drive.google.c...
==============================
Link of Last Video:
• Consolidation in Excel...
-----------------------------------------------------------
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/powerexby...
Contact Us:
Instagram: ...
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
Thank you sir for your help 🙏
Thanks
Excel ma logruthim hacta formula ka use Kesy krty hn
How to consolidate text data one below the other
Same question
very nice sir but when you would have tell good things so there were shown darkness view on the screen.
Sir koi employee jan m present tha but feb m nahi fir march m present tha April m nahi uss trah ke sheet ko kaise karenge
Thanks for your session.
Q: If the consolidated file is closed and update in the source file/files, then the consolidated file will be updated automatically?
No you will have to keep opened both of the files.
@@PowerExbyJitendra Ok. Thank you. But won't the consolidated file be updated when open caz if any workbook linked with another workbook then there is showing a command 'Update Link'?