How To Consolidate Data From Multiple Worksheets in a Single Worksheet Excel | Hindi

How To Consolidate Data From Multiple Worksheets in a Single Worksheet Excel 2007 2010 2013 2016 Hindi - You can quickly summarize the data contained in multiple Excel worksheets by using the Data Consolidation tool. It does not require a complicated formula. You can easily consolidate data from multiple worksheets into one worksheet. This tutorial teaches you how to use the consolidate command in excel and shows you how to add sales data for parts from two different stores. This also teaches you how to consolidate the data so that it is dynamically linked and so that when any spreadsheet is updated, the consolidated worksheet will also be updated.
you can also consolidate data from multiple workbooks in one workbook...
How To Combine/Consolidate Multiple WORKBOOKS into one in Excel || HINDI • How To Combine/Consoli...
Hope you will like the video. Thanks for watching.
-------------------------------------------------------------------
-------------------------------------------------------------------
Subscribe to my channel:
/ deepakeduworld
-------------------------------------------------------------------
-------------------------------------------------------------------
like my facebook page:
/ deepakeduworld
-------------------------------------------------------------------
-------------------------------------------------------------------
my facebook profile:
/ nehra92
-------------------------------------------------------------------
-------------------------------------------------------------------
follow on linkedin:
/ deepakeduworld
Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं
_____________________________________________________________
MS WORD के videos के लिए ये playlist देखे
• 📰 MS Word 2010 Tutoria...
_____________________________________________________________
ADVANCED MS EXCEL के videos के लिए देखे ये playlists
• 📊 ADVANCED Excel Tutor...
_____________________________________________________________
ADVANCED MS EXCEL FORMULAS के videos के लिए देखे ये playlists
• ⏹ ADVANCED Excel Formulas
_____________________________________________________________
HTML5 & CSS3 के videos के लिए ये playlist देखे
• ⏹ HTML5 CSS3 Tutorial...
_____________________________________________________________
COMPUTER के TECHNICAL videos के लिए ये playlist देखे
• 📺 Computer Tips & Tricks
_____________________________________________________________
Thanks for Watching
Happy Learning
DEEPAK NEHRA
____________________________________________________________
_

[@DeepakEduWorld]

🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
*Show Me ♥ By Like Share & Comment*
🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
*𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*

[@imranmohammad186]

@Excelhurdles Hi do you know how we use vlookup search data with the help of two cells
Like we find the A cell. Or. Find the Data B cell . If you know this pls share how is it possible.

[@sairaaslam3292]

Pakistan se hoon ... Behaddddd shukriya ...itna acha samjhate hain k " repeat" ki zroorat hi nahi rehti

[@sunitaraul5954]

Sir your vedio is very helpful for Excel learners, clear explanation and perfect language is the things which pull us to watch your videos.. thank you very much 👍

[@ssinda25]

आप का वीडियो सभी सीखने वालों के लिए एक वरदान साबित हो रहा है

[@zahidjamil5950]

kiya baat ha sir g ALLAH PAK ap lo khush rakhy sir g knowledge huna bari bat ni ha but jo ap k pass us ko deliever kasy kiya jay ye bht bari bat ha sir ap ka way of teaching kaml ha

[@DeepakEduWorld]

+zahid jamil thanks.. G

[@firozabbas5129]

nice sir aap bahut ache se samjhate hain

[@sumairaurooj240.]

Your video is very good I easily understand your methods

[@shahrozkhushik7205]

Wah Deepak sir wah me apka kesy sukrya ada karon me Pakistan sy hon Rashid Mera name he mene boht kuch seekha he apke videos sy aur number bhii achy liye hen tere videos mene taqreebaan 100 sy bhi zyada videos deekhii he Allah apko khush rakhe umaid he agy boht kuch seekhengy apkii videos sy me class ka cr. Bna hon

[@shivkumarsingh1812]

Undaj apna apna bahut badiya thanks alot mere brother

[@sandeepkumar-ll2iq]

Very good video to learn and how to apply
thanks

[@soumyaghosh20-ix-c93]

Excellent explanation..

[@diliplondhe2934]

Very easy teach to us. Lot of thanks sirji

[@sandhyamandal9847]

Very very helpful video, thank you sir

[@zaheenahmed5938]

Your video is very informative.Your teachings method is very simple ❤️❤️❤️

[@anjalimeena3590]

Superb video nd your videos is Very helpful for me always thank u sir

[@manojjrkhiara240]

Superb. Thank you so much

[@techmt4174]

Thank u Sir I m watching video daily

[@uttampandey3103]

yau are the best teacher of ms excel

[@alokdiko]

Thanks lots Sir it's very needful video

[@shuaibmalik6578]

Deepak bhai excellent explanation

[@sanjanaray395]

Very very helpful video Sir . You have explained it so clearly .

[@prakashbudha7209]

मुझे भौत अच्छा भिडियो लाग् रहि हे यस भिडियो । यस भिडियो कि, पठानेका जो पि होगा हृदय देखि नै आभार प्रकट करना हु और भौत भौत धन्यवाद देता हु ।

[@l.b.1754]

Thank you sir
This video was very helpful

[@pankajkashyap398]

I am biggest fan your best channel

[@silpakitchenhouse2506]

Your teaching tips are very good other than.
Thank you

[@sayangaming4843]

Easily explained very nice

[@pratikshaaangane7563]

Thank you I got lots of knowledge

[@ashukumar7403]

Very nice and easy way....sir ji

[@rajendramehra4651]

Really nice video Kamal kaa trick hai..
Sir auto update subtract and addition par bhi koi short video banaiye..

[@venkat_1956]

Very easily explained. Thank you sir...

[@rimpalkaur4699]

Thanks sir for your help and your teaching way is very well sir

[@computerorigin7434]

Superb 👍👍👍👍

[@sunilmandlik9160]

God bless you Sir

[@thakurgayathri8140]

ek dam makhan marke ! wow paaji

[@pradyumnakumartripathy7152]

Well explained. Thank you sir.

[@bumarani839]

Your video lesson interesting and informative

[@sumeetpalan6143]

Thank you for sharing this consolidate video, very nice sir.

[@lalitbhardwaj1260]

sir mast tarika h aapka sikhane ka

[@anjaneyulukodam9961]

Thanks for your kind explanation, teaching.
Good morning sir,

[@rimpalkaur4699]

your teaching way very nice , thanks sir and please continue.

[@dindayalprajapati9561]

Sir, I like this video. very very thanks

[@sairam1200]

Excellent sir...

[@amardeepsingh3914]

Bhai ye 7 dislikes kyu... Haad hi hai, itni easily samjhate ho tum, ki lagta hai excel kuch hai hi nhi..! Great job buddy

[@DeepakEduWorld]

+amar deep singh thqnks Dude...

[@varunorsingh]

whole video was good but ending of all ur videos was amazing. Jai Hind Vande matram

[@fun7122]

Thanks a lot sir video was very clear I could manage to understand very Nice explaining Pawer you have got video was helpful for me

[@narendrakumar-hu9jq]

NICE DEEPAK SIR

[@abdulwaseem7993]

Sir kindly upload videos on printing......means how to print professionally in ms word and Excel.......

[@deepakpatel0411]

Good, Thanks for giving valuable information about excel...

[@qaisaraltaf2877]

What. Fantastic video you are great sir

[@Gajendrabhagwat]

You are best

[@VickyAnmol.01]

धन्यावाद भाई

[@rajatverma8164]

Dear sir ,
I'm watching every vedio. And your vedios are very supportive to me . Now I am facing a new challenge in my work so that I need to help....

[@master_gyan]

bahot khoob

[@ganeshmore8088]

Very nice deepakji

[@khustarnoorani4917]

Great Helpful video
God bless you!

[@smasthan1628]

HI Deepak,thanks its very useful video, example if i add one more new tab year 2018 sheet then in this case how to include this data ? please clarify

[@marslanmanzoor6964]

Sir , i really appreciate your effort...Great respect and love from Pakistan 🇵🇰🇵🇰🇵🇰👍👍

[@AbhishekKumar-gs9ub]

This video is very helpful sir ... thank you for this

[@shaukatsamad2510]

Excellent

[@sangeetasbhaktiandmotivati9215]

very nice explanation..thank u sir

[@aartimarbal2534]

Very nice sirji thank you

[@futureonlineguru2879]

Super video sir

[@vijaylaxmisharma6318]

Bhaiya you are genius

[@chakrabortypartha4217]

Thank u Sir very helpful vedio.

[@vinayakpotadar4093]

Specialy u speech clearly & nice sir

[@satyanarayansarang6077]

super sir.........very helpful....

[@tinkughosh5561]

Way of teaching good

[@TVSCDN]

Very nice 👍😊 thanks

[@AsifAli-kt9kg]

U r best my brothrr

[@magbulmansuri4636]

verynicely teached

[@balance1772]

Please bring videos on power query

[@evideos]

THANK YOU
DEEPAK Edu World👌

[@satyamthepassionate5430]

Best 👍💯 sir.

[@DeepakEduWorld]

😊😊😊

[@baqirarzoo4394]

Very nice video 👍

[@we3605]

Just brilliant. Very good Deepak. Keep it up.

[@maviashah6598]

Thank you very much very helpe teacher

[@robot38243]

Excellent 👌👍

[@asmrindia]

VERY NICE SIR
YADI DATA AISA HAI JISE KEWAL EK SHEET ME MERGE HI KARNA HO TAB, JAISE SHEETS ME NAME, ID, DOB, SUBJECT, DESIGNATION ETC. HO, TAB SUM KI BAJAYE KYA LENGE?

[@arijeetsharma2708]

Outstanding as usual

[@DeepakEduWorld]

😊

[@Nimhira]

Sir your way of teaching is too good.... V simple v informative video. Thanks for yr help.

[@DeepakEduWorld]

+Nimmi Hira 👍

[@vipinpanchuri7284]

Very Helpful...

[@afshagul4387]

Very good sir

[@priyankathakur538]

to helpful for us....

[@dhaneswarbuda3895]

Thank you sir

[@mdmaniksarker1218]

Really amazing.

[@anitagarwal334]

Thanks Sir, ur videos are awesome and very helpful.. :D

[@MrRamesh012]

Thank u sir this video

[@durgeshwagadre9740]

Deepak yr nice explain

[@vijaylaxmisharma6318]

Very helpful video bhaiya

[@salmankasgar6070]

THANK YOU SIR

[@nilanjanachoudhury8545]

thanks sir

[@abhayghui2409]

Thanks sir...

[@naveedak5572]

Thank you deepak sir :)

[@sohailshahid7361]

Deeapak sir!have you made course video over access 2016,I wanna learn from you.

[@DeepakEduWorld]

I have not yet published..

[@maualnaazadschoolnisarsir6044]

Thanks
Go ahead

[@Neeti192]

Kya excel me merge cell me formula copy krna possible hai wo bhi tbh jb cell size sbke different ho

[@DeepakEduWorld]

Ys its possible

[@Neeti192]

Deepak EduWorld how its plz tell me is better if u make a video it more helpful to mr

[@muhammadrafee9234]

Dear Deepak make a complete vedio on ms access please

[@rajinvedios5867]

Awesome

[@DeepakEduWorld]

😊

[@bittusingha5802]

Thanks you so much sir

[@ankitmalani2000]

Other functions bhi use kar Ke video bano like average,max,min