This is the Ninth part of a series on Excel tips that can increase your productivity. We will discuss the feature CONSOLIDATE
In this video, we will discuss the #9 Tip to increase productivity- CONSOLIDATE
Increase your productivity by 10X in Excel with the CONSOLIDATE feature in DATA Ribbon that will speed up your working with data.
We will discuss the feature CONSOLIDATE.
With Excel’s CONSOLIDATE feature you can consolidate your worksheets (located in one workbook or multiple workbooks) into one worksheet.
The Excel consolidate function lets you select data from its various locations and creates a table to summarize the information for you.
CONSOLIDATE is a feature in DATA Ribbon which helps you set both Labels at Top as well as the Left column easing consolidation of data.
Badhayein apni Excel mein productivity kai guna CONSOLIDATE feature ke saath.
Excel mein CONSOLIDATE ek kamal ka feature hai jis se aap badhi se badhi sheets ke data ka jod turant nikal saktein hai
यह एक्सेल का बड़े काम का और बहुत ही मजेदार Feature है। इसकी मदद से आप बढ़ी से बढ़ी शीट के डाटा के जोड़ तुरंत निकाल सकते हैं।
Ham is Video mein Dekhenge CONSOLIDATE ka Jaadu.
Excel ek samandar hai is mein anginat features hain. Iss series mein hum baat karenge kuch features ki jisse hum apni productivity ko badha sakte hain kai guna aur apna kaam asaan bana sakte hain
Yeh series Hindi/English aam bhasha mein hai. Asha hai aap ke kaam ayegi. Khud bhi dekhein, apne doston ke saath bhi share karein.
My other videos on Using Excel 👇
TOP 10 EXCEL TIPS in Hindi/English Series
#1 Quick Access Toolbar https://youtu.be/OOuvqvSH8A8
#2 Keyboard Shortcuts https://youtu.be/tu52UdJR5MM
#3 Custom Sort https://youtu.be/sThclPC2AIU
#4 Horizontal Sort https://youtu.be/DHKrDDYq_1o
#5 Go to Special https://youtu.be/SofqWqJu27E
#6 Advanced Filter https://youtu.be/QD_lCjqI1us
#7 Table https://youtu.be/IVGIBq7tY6I
#8 Subtotal https://youtu.be/AnEfgHP4g90
#9 Consolidate https://youtu.be/WERAbDJ3ga8
#10 Flash Fill https://youtu.be/PpDr4JPdT5U
Excel Tips & Tricks- Hindi
#Pivot Table https://youtu.be/KFJJIRPytPg
#80/20 Rule with Pivot https://youtu.be/N5_oTaD2bJI
Excel Productivity Hacks
◾Autofilter, Flash Fill https://youtu.be/IGjw-YFHvLU
◾Using Tables https://youtu.be/nKJdgFtjZ_E
◾Consolidate https://youtu.be/7AwJLMJ6OeE
◾TEXTJOIN https://youtu.be/o-7uLzl7J6k
◾SUBTOTAL https://youtu.be/01rrV7_fw64
◾SUBTOTAL Outline https://youtu.be/tVhdN9orSQ8
◾Evaluate Formula https://youtu.be/-6iSLH-x8b0
3 Simple Powerful Tools for Tax Audit 🎯
#1 Excel https://youtu.be/bGzoTGtdNb4
#2 eCAAT https://youtu.be/3vl4KXyuO44
#3 MDA Audit Tool https://youtu.be/V_alqesIUhI
Excel as an Audit Tool https://youtu.be/Ne3w6Jj2ZSU
The Data Analysis Story with Excel https://youtu.be/0ZUxLCDUNsc
Bank Audit Series
Part 1: How to convert bank reports to Excel
Part 2: How to use Filter in Excel to analyse Loan Balance Report. https://youtu.be/4Z6W40gSWOA
Part 3: How to use the Power of Pivots to analyse Loan Balance Report. https://youtu.be/whdEZDSdoIM
Bank Audit in Computerised Environment
1. Thumbs up, if you learned something new today. 👍
2. Subscribe to get regular updates on Excel.
3. Comment below with your biggest takeaway from this video.
#CONSOLIDATE, #Consolidatesheets, #Exceltraining, #Exceltips, #Audit, #msmehta, #icai, #auditwithexcel, #charteredaccountant, #Advancedexceltraining, #Advancedexceltips, #Advancedexceltips, #MicrosoftExcel, #ExcelTipsandtricks
🚩 Connect with me
✅Website: https://www.msmehta.com
✅Email: msm@msmehta.com
✅LinkedIn: https://www.linkedin.com/in/manmeetmehta
🔔Subscribe to my YouTube channel: https://www.youtube.com/c/ManmeetSinghMehta?sub_confirmation=1
Popular Tags -Top 10 Tips For Excel, How to increase the productivity with CONSOLIDATE, What is CONSOLIDATE Function, Productivity tips in excel in hindi, Excel tutorial, How to use CONSOLIDATE in Excel, Excel mein CONSOLIDATE kaise istemal karein, What is CONSOLIDATE, How to combine data from various sheets with CONSOLIDATE, Excel Ka Jaadu, data entry jobs, work from home, Data Entry Tips, Excel tips and tricks,
