Тёмный

🔥Top 15 Super Ways To Clean Data in MS Excel | How to Clean Data in MS Excel 

mybigguide
Подписаться 3,7 млн
Просмотров 173 тыс.
50% 1

🔥 Join Our Pandrive Computer Course - offline.pcskil...
Top 15 Super Ways To Clean Data in MS Excel | How to Clean Data in MS Excel Aaj ke video mein hum aapko MS Excel mein data ko saaf karne ke top 15 super tareeke batayenge. Data cleaning ek bahut hi mahatvapurna process hai jo humein accurate aur reliable insights prapt karne mein madad karta hai.
1. *Introduction to Data Cleaning:* Hum shuruwat karenge data cleaning ke mahatv aur uske kya-kya fayde hain.
2. *Remove Duplicates:* Duplicates ko kaise pehchane aur kaise unhe hata kar data ko saaf kiya ja sakta hai.
3. *Trim Spaces:* Extra spaces ko kaise hatakar data ko saaf kiya ja sakta hai.
4. *Text to Columns:* Text ko columns mein kaise alag kiya ja sakta hai.
5. *Remove Special Characters:* Kaise special characters ko hatakar data ko clean kiya ja sakta hai.
6. *Data Validation:* Kaise data validation ka istemal karke valid data ko filter kiya ja sakta hai.
7. *Remove Errors:* Errors ko kaise identify kiya ja sakta hai aur unhe kaise correct kiya ja sakta hai.
8. *Date Formatting:* Date ko kaise sahi tareeke se format kiya ja sakta hai.
9. *Using Conditional Formatting:* Kaise conditional formatting ka istemal karke data ko visually clean kiya ja sakta hai.
10. *Remove Blank Cells:* Kaise blank cells ko hatakar data ko saaf kiya ja sakta hai.
11. *Using Filters:* Filters ka istemal karke data ko kaise filter kiya ja sakta hai.
12. *Using Formulas:* Kuch useful formulas ka istemal karke data ko kaise clean kiya ja sakta hai.
Toh dosto, yeh the top 15 tareeke MS Excel mein data ko saaf karne ke. Video dekhiye, sikhiye, aur apne data cleaning skills ko naye uchaiyon tak pahunchaiye.
Shukriya!"
[Include other relevant information and links as needed.]
#mybigguide #computer #excel
------
अगर हर रोज कुछ नया सीखने की प्रचण्‍ड इच्‍छा रखते हैं My Big Guide से सोशल मीडिया पर जुड़ें और टिप्स और ट्रिक्स सीधे अपने फ़ीड में पाएं -
❤️RU-vid - / @mybigguidehindi
👌Facebook - / geekyabhimanyu
🔥Telegram - t.me/mybigguide
📢WhatsApp - www.whatsapp.c...
😍Instagram - / mybigguide
😎Twitter - / mybigguide
🤩Website - www.mybigguide...
📔Course - offline.pcskil...
👍 अभिमन्यु भारद्वाज हिंदी में शिक्षा सामग्री प्रदान करने के लिए जाने जाते हैं। वह अपनी सरल भाषा और स्पष्टीकरण के लिए प्रसिद्ध हैं। अभिमन्यु भारद्वाज एक प्रसिद्ध यूट्यूबर, ब्लॉगर और शिक्षाविद् हैं। वह हिंदी में विभिन्न विषयों पर वीडियो और लेख बनाते हैं। वह "My Big Guide" नाम से एक लोकप्रिय ब्लॉग भी चलाते हैं।
अभिमन्यु भारद्वाज ने अपनी सरकारी नौकरी छोड़कर शिक्षा के क्षेत्र में अपना योगदान देने का फैसला किया। वह विभिन्न प्रतियोगी परीक्षाओं की तैयारी करने वाले छात्रों के लिए उपयोगी वीडियो और लेख बनाते हैं।
My Big Guide चैनल उन लोगों के लिए एक उत्कृष्ट संसाधन है जो हिंदी भाषा में विभिन्न विषयों के बारे में सीखना चाहते हैं। अगर आप हिंदी भाषा में शिक्षा सामग्री ढूंढ रहे हैं, तो My Big Guide RU-vid चैनल निश्चित रूप से आपके लिए देखने लायक है।
👍 About MBG - My Big Guide, Abhimanyu Bhardwaj द्वारा संचालित एक लोकप्रिय RU-vid चैनल है। यह चैनल 3.49 मिलियन से अधिक सब्सक्राइबर्स के साथ हिंदी भाषा में सबसे लोकप्रिय शिक्षा चैनलों में से एक है। यह चैनल विभिन्न विषयों पर वीडियो प्रदान करता है, जिनमें शामिल हैं: -
• कंप्यूटर: MS Office, Windows, Photoshop, etc.
• इंटरनेट: SEO, Blogging, Social Media, etc.
• मोबाइल: Android, iOS, Apps, etc.
• परीक्षा: UPSC, SSC, Banking, etc.
• करियर: Resume Writing, Interview Tips, etc.
My Big Guide चैनल की कुछ विशेषताएं:-
• सरल भाषा: वीडियो सरल और समझने में आसान भाषा में बनाए गए हैं।
• स्पष्टीकरण: जटिल अवधारणाओं को स्पष्ट और संक्षिप्त तरीके से समझाया गया है।
• उच्च गुणवत्ता: वीडियो उच्च गुणवत्ता वाले हैं और देखने में आकर्षक हैं।
• नियमित अपडेट: नए वीडियो नियमित रूप से अपलोड किए जाते हैं।
❤️ Our Other useful RU-vid channel please subscribe -
1 - Abhimanyu Bhardwaj - bit.ly/32hGhQK
2 - My Big Guide - bit.ly/3gvRTtq
3 - My Mobile Guide - bit.ly/3gurBIe
4 - My Computer Course - bit.ly/3xpX8R6
5 - Graphic Gyan - bit.ly/3vsSz7n
6 - Only Excel - bit.ly/2SwHxAB
7- CCC Guide - bit.ly/3gzdEJa
8 - PC Skill - bit.ly/35ttVbZ
9 - My Buying Guide - bit.ly/3f3ENR1
🤩 Our Top Video Playlists in Hindi -
All Videos Of Learn tally in Hindi - bit.ly/2MC9oLa
All videos of Excel in Hindi - goo.gl/aF43Hs
All videos of access to Hindi - goo.gl/LRohxH
All videos of Photoshop in Hindi - goo.gl/AVsjLZ
All videos of Windows 7 in Hindi - goo.gl/z44h2d
All videos of Gmail Tips in Hindi - goo.gl/h3EZzv
All videos of RU-vid Tips in Hindi - goo.gl/zqzoJW
All the videos of technology in Hindi - goo.gl/pfQKsk
अगर आपको My Big Guide चैनल के बारे में कोई और जानकारी चाहिए, तो आप कमेंट में पूछ सकते हैं। धन्‍यवाद आपका दिन शुभ हो 🙏

Опубликовано:

 

28 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 103   
@mybigguidehindi
@mybigguidehindi 5 месяцев назад
🔥 Join Our Pandrive Computer Course - offline.pcskill.in/
@admpro8310
@admpro8310 5 месяцев назад
Sir Pendrive Course Buy Karne ke liye Jaise hi Click Kar raha hu, Price 2499 se change hokar 12k plus ho jata hai... Please Solve the issue... I want to Buy This Course
@Rameshbabu-oy6vz
@Rameshbabu-oy6vz 2 месяца назад
A great and highly useful video
@harsh.pandat
@harsh.pandat 2 месяца назад
Best version of excel konsa h jisme sare features ho
@Khursheedkhan78692
@Khursheedkhan78692 3 месяца назад
Plzz sir sage evolution ke bare me video banao plzz 🙏🙏
@101Yogendra
@101Yogendra 5 месяцев назад
Nicely explained
@mylifedollars8729
@mylifedollars8729 4 месяца назад
Very nice sir
@rajeevgosavi4514
@rajeevgosavi4514 5 месяцев назад
Could you please provide link to download the spreadsheet to follow along.
@SUNILGOYALPOWERMAN
@SUNILGOYALPOWERMAN 5 месяцев назад
आपकी वीडियो के शौक़िया देखता हूँ कुछ ना कुछ नया सीखने के लिए ! बेहतरीन जानकारी सुलभ भाषा में. आपके एक्सीडेंट्स की खबर पढ़ी थी , चिंता भी हुई
@Andhbhakt-Hu
@Andhbhakt-Hu 3 месяца назад
Subscribe karna pada 😊🙏🏻
@shahwazahsan7570
@shahwazahsan7570 2 месяца назад
sir Excel ka practice link chahie practice krne k lie
@amolkhairnar7094
@amolkhairnar7094 4 месяца назад
Aagar GSTR2B ka data Tax rate ke hisab se columnar me convert karna ho to kaise kare
@VibRantsoul95
@VibRantsoul95 2 месяца назад
what is the point of learning all those shortcuts when you already know where you need to go for some particular adjustment. as in for specials ctrl+g then go to specials n all... i already know where I can find it as in home>editing section then under find and select. question is why to spend time to learn all those lengthy shortcuts when we can spend that time to learn what are important functions in excel and understand the dynamics of it.
@BipinDobariya-ShreeVallabh
@BipinDobariya-ShreeVallabh 5 месяцев назад
Thanks for 732 Subscriber, A waiting for 1.0 K Support .. If you like
@rambobhai2435
@rambobhai2435 5 месяцев назад
Watched
@inderjitsingh9717
@inderjitsingh9717 5 месяцев назад
Sir ms office 2021 ka link send kar do sir please
@nikhilshahu830
@nikhilshahu830 5 месяцев назад
Extra space k lie =TRIM() Formula Fake hai
@nikhilshahu830
@nikhilshahu830 5 месяцев назад
Koi other trik batae
@mkpkartik1359
@mkpkartik1359 14 дней назад
=TRIM((PROPER(A3)) Is me error dikhata hai
@madarauchihafan
@madarauchihafan День назад
=TRIM(PROPER(A3))
@madarauchihafan
@madarauchihafan День назад
Try this one 🕐
@rameshwardayal6820
@rameshwardayal6820 5 месяцев назад
Sir please help kar do please sir ji
@Rameshp692
@Rameshp692 5 месяцев назад
क्या हेल्प चाहिए
@rameshwardayal6820
@rameshwardayal6820 5 месяцев назад
@@Rameshp692 sir please help kar do
@Rameshp692
@Rameshp692 5 месяцев назад
@@rameshwardayal6820 wo hi puchh rha hu kya help chahiye
@rameshwardayal6820
@rameshwardayal6820 5 месяцев назад
Sir ji aap apna WhatsApp number do mujhe aap se help chahiye sir please
@gajendraKumar-tc5qv
@gajendraKumar-tc5qv 5 месяцев назад
Pdf ko Ms me convert kaise kare bataye sir please
@naturebeauty1835
@naturebeauty1835 5 месяцев назад
Ji
@Kunal_Gala_Value_Properties
@Kunal_Gala_Value_Properties 5 месяцев назад
Google me search Karo... Pdf to excel online converter.. Bahot sara Site hai jis pe ho jaega..
@karunasagarmallela6065
@karunasagarmallela6065 5 месяцев назад
Pdf to ms apps are available
@owesomeknowledge667
@owesomeknowledge667 4 месяца назад
Ms office me file ke option me jao aor fir jis file me pdf save hai usme jakar pdf select karlo automatically hi pdf converter ho jayega Excel me
@rajeshthapa983
@rajeshthapa983 4 месяца назад
You can use I love pdf,it's an online free service.
@shyampanika2232
@shyampanika2232 4 месяца назад
new generation too much expert my job side mujhe us advance ke sath chalna hai if any advice for me ✔
@mukeshpatel9843
@mukeshpatel9843 3 дня назад
Dataset bhi provide kar diya kijiye sir practice ke liye.
@SaviVishwakarma-ec6og
@SaviVishwakarma-ec6og 4 месяца назад
Nice sir me app ke video se bahut ku shik gai hu or me rojana dekhthi hu computer se riled video
@Markifreelancer
@Markifreelancer 2 месяца назад
Sir can you please provide us the Raw Excel sheet so that we can practice it..
@achalrajput4173
@achalrajput4173 24 дня назад
Sir, practice file description me de dete to aur bhi accha hota pehle hm try krke dekh lete
@r.pstatus6953
@r.pstatus6953 5 месяцев назад
Pdf ko excel meh kaise liya jaye
@harshitasinghdulawat7956
@harshitasinghdulawat7956 2 месяца назад
why alt H O I shortcut is not working in my laptop!!!!
@ysskb
@ysskb 4 месяца назад
sir ye wala practice krna hai kha se milega..
@shyampanika2232
@shyampanika2232 4 месяца назад
sir jee mai eak store keeper hoon i am interest several type of sock ka report up date chahta hoon next morning to mai excel ka kaise use karu right now my age running 48 years as per AAP ka kya advise hai humly request to you.
@vasudevchaturvedi9321
@vasudevchaturvedi9321 21 день назад
Sir please provide this sheet for practice
@barmansanu3765
@barmansanu3765 Месяц назад
ISKA FILE KAHA HAI
@jitendranaidu4398
@jitendranaidu4398 3 месяца назад
Yaha se kuch shortcuts apple me kaam nhi karte hai
@AnkitSingh-ic8ri
@AnkitSingh-ic8ri 2 месяца назад
Kon sa Apple khane wala kya 😂
@sarojdhami2744
@sarojdhami2744 20 дней назад
Thank you Sir
@naturebeauty1835
@naturebeauty1835 5 месяцев назад
Pdf ko excel me kaise krw
@dineshrandive8346
@dineshrandive8346 5 месяцев назад
Payment kar na padega
@ParveenKumar-in4wp
@ParveenKumar-in4wp 4 месяца назад
Excel me data option me jakar 'get data' then select pdf
@AshokKumar-iu1bj
@AshokKumar-iu1bj 5 месяцев назад
Thanks for Valuable information.
@PRAVINKHEDKAR-t3e
@PRAVINKHEDKAR-t3e 4 месяца назад
आपका बहुत धन्यवाद सरजी, मुझे INDEX और एक बार मे लिस्ट से स्पेशल शीट बनाना शिखना हैं जिसमे ऊन हर व्यक्ती का डेटा हो मैने बहुत सर्च किया पर नही हो रहा हैं 🙏🏻🙏🏻🙏🏻🙏🏻
@Avinaskumar-j2l
@Avinaskumar-j2l Месяц назад
सर जी क्या 12 वीं पास भी डाटा एनालिसिस में जॉब कर सकता है अगर शिकने पर 🙏🙏
@rajkumar-sn3vv
@rajkumar-sn3vv 4 месяца назад
Win zip file ya document ko kese kese normal save kare ? Win zip file ko kese unzip Karen?
@MohitKumar-up8qz
@MohitKumar-up8qz 5 месяцев назад
Sir ekk Problem face kar rhe hai. Manual type krne ke wazah se date ka 2000 se jyda data alag alag format me hai aur humko ekk format me krne hai. Lekin custom se bhi kr rhe hain to nhi ho rha hai. Plz help kr dijiye
@ardbhoshangabad2887
@ardbhoshangabad2887 Месяц назад
आपका वीडियो बहुत अच्छा है इसी प्रकार के वीडियो मिलते रहे बहुत बहुत धन्यवाद
@kunasahoo5924
@kunasahoo5924 5 месяцев назад
Please Attached The Excel File Or G-Drive Link On The Comments Section.
@bharatbhushan947
@bharatbhushan947 5 месяцев назад
ctrl +shift+4 se dollor ks sign aa rha hai. Rupey ka nahi.
@pawanlingwal6151
@pawanlingwal6151 Месяц назад
Very simple and interesting articulated the MS Excel formula. Your presenting method also simple
@anondodasgupta5275
@anondodasgupta5275 4 месяца назад
Har cheez ke liye keyboard shortcuts with 4 to 5 keys ki kya zaroorat hai. Most of these can be easily done with menu bars without the need to memorise the shortcuts.
@onlypolice7097
@onlypolice7097 5 месяцев назад
Sir ye data jo aapne clean Kiya vo hme bhi do plz discription me taki practice kar ske dek ke
@bhupender-verma
@bhupender-verma 2 месяца назад
Sir maps kese बनाएं ye video banaiye please
@RobinSingh-si5ye
@RobinSingh-si5ye 25 дней назад
Thanks sir meri nervousness dor ho gyi 😮‍💨🥰❤
@vkbhar
@vkbhar 5 месяцев назад
Bhardwaj Ji, do not drag for the copy formula, just double-click.
@bhanwarrajawat3398
@bhanwarrajawat3398 5 месяцев назад
Hello Sir, every this is ohk, but can you make video related to how to merge all excel file into one excel or all sheet data cover in to one sheet with common heading or title. Also can you explain some basis promt code.
@saquibmajeed1642
@saquibmajeed1642 4 месяца назад
Sir Dhanyawad App ne bahut hi behtrin tarike se samjhaya hai ,kya iska practise file share kar sakte hain description mein
@mdgufransiddiqui580
@mdgufransiddiqui580 5 месяцев назад
Sir I have ordered a pendrive computer course. Where do I see ordered details? Also I have called but not responding.
@PriyankaKumari-hw4he
@PriyankaKumari-hw4he 5 месяцев назад
Tally ka Pendrive ka price kitna hai sir
@Amdavadi_harshuu
@Amdavadi_harshuu 4 месяца назад
Sir, is File Ki Link Diji Ye..😊
@PRADIPSEN-nk7xz
@PRADIPSEN-nk7xz Месяц назад
Very good excel trick. Thank you, Sir
@ChromaMagicYT
@ChromaMagicYT 4 месяца назад
Sir this vedio is very knowledge if you can add the data file for practice it would really helpful
@vijaykchawla
@vijaykchawla 5 месяцев назад
wonderful, TUSSI GREAT HO
@subhashismajumdar3868
@subhashismajumdar3868 Месяц назад
Fantastic 👌👍 Thanks a lot Sir 🙏🙏
@dont_try_to_understand_me_14
@dont_try_to_understand_me_14 5 месяцев назад
You should bring 1 video everyday. You are the best till date than all other. I am at intermediate level of excel and I am learning from you.
@Imran.shaikh988
@Imran.shaikh988 5 месяцев назад
Sir please pc se lock todna skhao
@aliyadania3938
@aliyadania3938 5 месяцев назад
Sir vo ctrol + e work nhi karta ha
@basantadakua2867
@basantadakua2867 5 месяцев назад
sir price 12.5k dikha raha hai
@ragbirchana3573
@ragbirchana3573 4 месяца назад
Great tips for xcel. Thanks
@onlineearningtips4171
@onlineearningtips4171 5 месяцев назад
Abbreviations bhi proper kar dein
@VikramSingh-fd9fe
@VikramSingh-fd9fe 5 месяцев назад
Pdf ko exel me kese change kare
@avengersassemble-l3b
@avengersassemble-l3b 3 месяца назад
THANK YOU SO MUCH FOR
@JoginderSingh-fz5wh
@JoginderSingh-fz5wh 5 месяцев назад
Sir please upload a video on MS Word also
@neetukumar7319
@neetukumar7319 5 месяцев назад
Thank for valuable information
@vahiduzzmaakmal5295
@vahiduzzmaakmal5295 Месяц назад
Wow sir. Man gay🤝🤝
@rameshwardayal6820
@rameshwardayal6820 5 месяцев назад
Hello sir please help kar do
@rajendrakolhe1332
@rajendrakolhe1332 Месяц назад
Really best video
@praveenkumar-dm1xx
@praveenkumar-dm1xx 4 месяца назад
sir bahut achhi video hai
@sachinkumarjain3346
@sachinkumarjain3346 5 месяцев назад
Nice session sir 👍👍👍👍👍👍
@praveenkumar-dm1xx
@praveenkumar-dm1xx 4 месяца назад
aese hi banate rhana
@Ajay_ek_pagal_0408
@Ajay_ek_pagal_0408 5 месяцев назад
Very nice
@ramudgaryadav2760
@ramudgaryadav2760 2 месяца назад
Right sir
@mahmoodmakkah9282
@mahmoodmakkah9282 5 месяцев назад
bahot shukriya, Sir, ji
@BipinDobariya-ShreeVallabh
@BipinDobariya-ShreeVallabh 5 месяцев назад
❤❤ Nice Infornative Video❤❤❤
@Manjudhull94
@Manjudhull94 5 месяцев назад
Thanks sir
@umeshkohli8371
@umeshkohli8371 3 месяца назад
Thank you sir aise hi achhi achhi tricks laate rahiye ❤❤❤❤
@Markifreelancer
@Markifreelancer 2 месяца назад
Bhai practice kese karte ho sir to Excel sheet Nehi dete practice ke liye
@sunilkhairao
@sunilkhairao 5 месяцев назад
Bahot accha sir..!
@paramjeetfathni
@paramjeetfathni 5 месяцев назад
Thanks sir
@0.0Amantrader0.0
@0.0Amantrader0.0 5 месяцев назад
Nice❤
@vhideejey9084
@vhideejey9084 5 месяцев назад
धन्यवाद ♥️
@SandhyaSharma-bw8ip
@SandhyaSharma-bw8ip 5 месяцев назад
Thanku so much sir ❤❤🙏🙏
@rahul72933
@rahul72933 5 месяцев назад
Nice strik
Далее
9 Best Ultimate Excel Tips And Tricks and Fromula
14:08
Новый вид животных Supertype
00:59
Просмотров 176 тыс.
🔥Don't Use Formula | Use Excel Magic Trick Ctrl+E
9:19