Data Tools in Excel  ⚡ माइक्रोसॉफ्ट एक्सेल में Data Tab के Data tools ऑप्शन का उपयोग कैसे करते हैं ?
Channel: Excel Infotech
Date: 2021-10-27

In this video you learn Excel data tab menu's Data tools block options. Microsoft Excel 2007/2010/2013/2016/2019. How to use Text to column option, How to use Remove duplicate, How to Consolidate  flash fill etc. 

👉 Contact us 🤑🤑
➡️ Connect with us :ssdmtrust1505@gmail.com
➡️Follow @https://www.facebook.com/TecKnowledge... 
➡️Follow @https://twitter.com/vinodku83957405 
➡️Follow Instagram  Excel_Infotech 
➡️Website : http://www.advanceexcelinfotech.blogspot.com
★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★
हर रोज नया वीडियो ट्यूटोरियल हिन्‍दी में पाने के लिये हमारा यूट्यूब चैनल सबस्‍क्राइब करें और घर बैठे ही जॉइन करें Excel Infotech स्‍मार्ट क्‍लास 👈


Topic Covered:-
1. How To Use Text To Column 
2. How To Use Flash Fill
3. How To Use Remove Duplicate 
4. All Option in Data Validation 
5. How To Use Consolidate 
6.  How to Use Relationship 

#Tags:-
#Texttocolumn
#FlashFill
#RemoveDuplicate
#DataValidation
#Consolidate
#Relationship
 
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 favour of fair use

👉Result Sheet             https://youtu.be/kBwu7ZE14k8
👉Attendance Sheet    https://youtu.be/QYfdSjTW5Os
👉Bill Sheet                    https://youtu.be/VRVxSkhp1rI
👉Bonus Sheet              https://youtu.be/PhFMqMaHcfo
👉Payment Sheet          https://youtu.be/-dC94lnJmek
👉Vlookup                      https://youtu.be/LrM6v6S9HJU
👉Hlookup                      https://youtu.be/LMF7RSgjKcc
👉Vlookup & Hlookup   https://youtu.be/1jCCRLCuczw
👉Double Hlookup         https://youtu.be/jpSvxcAPerY
👉Double Vlookup          https://youtu.be/U0ut0ghHibE
👉Match Vlookup           https://youtu.be/rHm_1BXy4Yg
👉Match Hlookup           https://youtu.be/klANjOzrUUI
👉Match formula            https://youtu.be/XWWe1RFEqbI
👉Salary sheet                 https://youtu.be/mmRcrA2ynQI
👉DOB Sheet                   https://youtu.be/n-XT6ja9hIA
👉PMT IPMT PPMT         https://youtu.be/X5aFU6J3owk
👉FV Formula                  https://youtu.be/LkQc0Dn5tzU
👉Indirect Formula         https://youtu.be/9A0wMzE7wVo
 👉 Database Function  https://youtu.be/KV3UrhLvjFk
👉 GST Sheet             https://youtu.be/2ZmkZx7tu7I
👉 Fully Automatic Stock Sheet     https://youtu.be/rA7bMLfBhZM
👉 Top 10 Formulas     https://youtu.be/U6meQIpAASc
👉 Paste Option      https://youtu.be/UHSsLnloz-Y 
👉 Bold italic underline   https://youtu.be/dA4y2Sys1b0
👉 Conditional Formatting   https://youtu.be/8ijU0VUGzck
👉 Cells Option      https://youtu.be/TESTWgpl0iQ
👉 Pivot table     https://youtu.be/qRvSXyRhGFM
👉 Recommended Pivot Table   https://youtu.be/LqtAdHAkqho
👉 Illustration in excel    https://youtu.be/Fe5UHdNdMLo
👉 Add-ins     https://youtu.be/PlC50lrjjSw
👉 Chart Menu      https://youtu.be/5Tozntp47YU
👉 3D Map In Excel   https://youtu.be/jhphDH4Oc1o
👉 Sparkline     https://youtu.be/h08Jsqs5Dvo
👉 Hyperlink   https://youtu.be/Sbrh3VJt2U8
👉 Hyperlink   https://youtu.be/Sbrh3VJt2U8
👉 Header & Footer   https://youtu.be/HxUqFav9RsI
👉Themes & Page Setup   https://youtu.be/z_rxDN6dNMo
👉 Scale Fit Option      https://youtu.be/wTwW3w2G_O4
👉 Arrange           https://youtu.be/rYm6cPDJ3Bg
👉 Page Layout Tab       https://youtu.be/sxQJktmUgUA
👉 Define Names     https://youtu.be/_CG7eVvEoC8
👉 Auditing Option   https://youtu.be/mc61Z2epm6E 
👉 Formulas Tab    https://youtu.be/0cHF-zL40Rs
👉 Transform Data    https://youtu.be/aJj2SEc32Lc
★★★★★★★★★★★★★★★★★★★★★★★
Don't forget to - LIKE 👍 | SHARE 🤗 | COMMENT 💁 | SUBSCRIBE 🤓