Consolidation in Excel (Hindi) | How to Consolidate Data in Excel
Vložit
- čas přidán 29. 08. 2024
- 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.co...
==============================
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
Jitendra Bhai - to the point, no frills & very practical. Do keep it up & continue the series. Thank you so much.
My channel name is:
IT Computer Capture
learned alot from this . Wao its great way to teach
Thank u for sharing your knowledge in simple ways
Sir, now we can do table also in sheet 4, awesone❤🎉
Jitendra ji thank you for sharing this valuable information explained in an easy to understand manner
Thank you sir
My channel name is:
IT Computer Capture
Very nice and very helpful vedio sir, Sir aik vedio transport business management in excel py bhi Banao sir thanks ❤❤❤
OK thanks 🙏
The consolidate function will work with different range data in different sheets?
Very very useful and informative Sir. Sir your every video is very attractive. ❤❤❤
Thank you so much 🌹thanks🙏
very useful excellent sir, thank you very much
My channel name is:
IT Computer Capture
Sir data analysis par video banay
Excellent teaching
Thanks a lot
Thank you sir
Very informative video Sir
Thanks🙏
Helpful information 👍👌
Thanks a lot
Sir advance excel par video banaye jo office me use hota hai
I have so many videos please watch
Thank you Jitendra ji
Welcome sir
Please explain how to write vba code to unlock and lock for macro recording sheet in your debit credit balance sheet video.
Watch it :
czcams.com/video/qhgSV-6k3GM/video.htmlsi=3tT5WnjiWezfCLX5
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.
Make video on vlook up for large data
Okay 👍
Sir product name ek saath one time main kaise add kare. Jo aap ne one by one kiya hain
Is there a way to consolidate the data in one file if it is in different files instead of different sheets?
Yes
Amazing 😊😊😊
Thanks a lot
❤❤ love you sir ji
Thanks a lot bro
Well Explain 👍👌
Thanks🙏
Sir, ropa 2019 ka ek automatic salary calculator jismay pay matrix vi hoga eisa ek video banay. Please.
Great job
Thanks
Superb 👍👌👌
Thanks a lot
Excellent
Product k sat qty n price hoto kese hoga har month ka subtotal consolidation m
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)
Superb sir
Thanks a lot
How to select combination of any 10 numbers from 20 numbers such that the product of select d 10 numbers maximum or minimum?
Use Max or Min function in combination with Product function
Hello, how do you calculate product cost ?
Very good
Thanks
VERY GOOD
Thanks a lot
Good info
Thanks
thanks
Welcome
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.
I will contact you please share your mobile no on my Facebook page
एक शीट में A to Z कॉलम में डेटा है , उस डेटा को मुझे रोज अपडेट करने पड़ता है । मेरा प्रॉब्लम ये है कि आ सेल का डेटा B में , Z का Y में,..पेस्ट हो जाता है । ऐसा कोई condition लगा करते है ,A
कॉलम में एक सेल का वैल्यू को फिक्स कर के डेटा पेस्ट कर दे तो डेटा चेंज नही होगा ।
Hello sir compound interest par video banae
Zaroor
Channel kese monitor Hota h
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
Nahi hoga apko dobara create karna hoga
Importrange formula try kariya
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
Nice bt sir agar sheets 50 se jyada ho tab kya kate
No issue process will be same but you can do it quickly using Power Query. .
Answer please
@@PowerExbyJitendra make relevant video if possible
In this case we use Power Query you check out our playlist of Power Query
SLect karenge
🙂🙂🙂🙂❤❤❤❤❤👍👍👍👍
Thanks a lot
Jisme time 2.5year ho
My channel name is:
IT Computer Capture
Best wishes for your channel.
Excellent
Thanks a lot
Helpful information 👍👌
Thanks a lot
thanks
You're welcome!