10 ways to Clean Data in Excel - Malayalam Tutorial

എക്സലിൽ ഡേറ്റ ക്‌ളീൻ ചെയ്യാൻ ഉപയോഗിക്കുന്ന വ്യത്യസ്ത മെത്തേഡുകളെ കുറിച്ചാണീ ഈ വിഡിയോയിൽ വിശദീകരിക്കുന്നത്.
10 different methods to clean data in Excel are explained in this video.
1. Remove Extra Spaces
2. Remove Duplicates
3. Fill Blank Cells
4. Change Letter Cases
5. Highlight Errors
6. Text to Columns
7. Find and Replace
8. Spell Check
9. Convert Dates from Text Format to Date Format
10. Remove Line Breaks (Remove Line Feeds)
Microsoft Excel പഠിക്കാനും, Data Analysis Skill മെച്ചപ്പെടുത്താനും ആഗ്രഹിക്കുന്നവർക്ക് വേണ്ടി പൂർണമായും മലയാളത്തിൽ തയ്യാറാക്കിയ ഓൺലൈൻ കോഴ്സ്.
www.udemy.com/course/microsof...
Subscribe to my first KZread channel for more
/ ajayanandxlncad
🟠 Books on Excel xlncad.com/excel-resources/
🔵 Download my free ebook on Excel Macros eepurl.com/gpT0RD
🟢 Read my articles on Excel xlncad.com/
🟣 Join my free course on Excel Tables www.udemy.com/course/tables-i...
Disclosure: Some of the links are Affiliate Links! If you buy something through one of those links, you won't pay a penny more, but we will get a small commission, which helps keep the lights on. Thank you for your support!
#ExcelMalayalam #CleanDataExcel #MalayalamExcel

Пікірлер: 66

  • @manudevan4522
    @manudevan45223 жыл бұрын

    Bro oro videoyum ente office workine orupadu usefull ayi

  • @ziagi0076
    @ziagi00763 жыл бұрын

    I reffer to all of My friends Sir. Loved it. ❤️❤️❤️

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 жыл бұрын

    Thank you for that :)

  • @vijuvlogs-db2kv
    @vijuvlogs-db2kv Жыл бұрын

    It was really helpful. Appreciate.

  • @XLnCADMalayalam

    @XLnCADMalayalam

    11 ай бұрын

    😀

  • @salmanfaris3039
    @salmanfaris30392 жыл бұрын

    Thanks sir very best class 🥰👍

  • @amruthasanthosh4225
    @amruthasanthosh4225 Жыл бұрын

    It is very useful and interesting

  • @XLnCADMalayalam

    @XLnCADMalayalam

    Жыл бұрын

    Glad to hear that😀

  • @nidhinmuraleedharan8286
    @nidhinmuraleedharan82863 жыл бұрын

    It's awesome chettaii... Very usefull

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 жыл бұрын

    Thank you 🙂

  • @ziagi0076
    @ziagi00763 жыл бұрын

    Njan orupad thedi nadanna videos aan Sir ithellam. Oru rakshayumilla. Thank You so much for a wonderful work Sir. ❤️❤️❤️

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 жыл бұрын

    That's an awesome compliment. Thank you :)

  • @surajshowkath3359
    @surajshowkath33594 жыл бұрын

    Very useful,Thank you

  • @XLnCADMalayalam

    @XLnCADMalayalam

    4 жыл бұрын

    You are welcome

  • @jayasankars5173
    @jayasankars51733 жыл бұрын

    വളരെ പ്രയോജനപ്രദം.... നന്ദി...

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 жыл бұрын

    My pleasure

  • @your-destination4257
    @your-destination42572 жыл бұрын

    Your videos are usefull

  • @XLnCADMalayalam

    @XLnCADMalayalam

    2 жыл бұрын

    Glad you think so!

  • @shajicherian1892
    @shajicherian18923 жыл бұрын

    Thanks

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 жыл бұрын

    It's my pleasure. Which one is your fav. Tool or Method?

  • @10morrisonka
    @10morrisonka4 жыл бұрын

    As usual , excellent explanation !! Such a sweet and wonderful Malayalam, Sir !! 🤓🤓🤓😍😍😍 Hugs from MtNegro !! P.S. I looove kk

  • @XLnCADMalayalam

    @XLnCADMalayalam

    4 жыл бұрын

    My pleasure Madam :) Have you seen the names in the Examples? No points for guessing it Right 😉😎

  • @10morrisonka

    @10morrisonka

    4 жыл бұрын

    @@XLnCADMalayalam Mister, have you seen I wrote I love kk ( kitkat) ?:-)😚😚😚

  • @XLnCADMalayalam

    @XLnCADMalayalam

    4 жыл бұрын

    @@10morrisonka I see that Madam 😊 Now, l know what to bring while visiting MonteNegro 😉

  • @musthm1140
    @musthm11402 жыл бұрын

    Great very useful

  • @XLnCADMalayalam

    @XLnCADMalayalam

    2 жыл бұрын

    Thank you :)

  • @bineeshvydu9707
    @bineeshvydu97074 жыл бұрын

    Oru nandi paranjilla enkil daivam porukkilla.... thanks

  • @XLnCADMalayalam

    @XLnCADMalayalam

    4 жыл бұрын

    You are welcome :)

  • @abdulnazervalappil
    @abdulnazervalappil2 жыл бұрын

    Super classes

  • @abdulnazervalappil

    @abdulnazervalappil

    2 жыл бұрын

    Thanks 👍

  • @SuperJaice
    @SuperJaice4 жыл бұрын

    👌👌👌....

  • @XLnCADMalayalam

    @XLnCADMalayalam

    4 жыл бұрын

    😀✋

  • @anilkpk
    @anilkpk3 жыл бұрын

    Nice presentation....

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 жыл бұрын

    Thank you! Cheers!

  • @naseehmk8790
    @naseehmk87902 жыл бұрын

    Good🥰🥰🥰

  • @XLnCADMalayalam

    @XLnCADMalayalam

    2 жыл бұрын

    Thank you! Cheers!

  • @vpshuhaib830
    @vpshuhaib8304 жыл бұрын

    Sooper

  • @XLnCADMalayalam

    @XLnCADMalayalam

    4 жыл бұрын

    😀

  • @vallavilasreekumar4420
    @vallavilasreekumar44204 жыл бұрын

    Very good explanation Thanks A small request Automatic invoice number generate cheyyunnathine kurichu oru video cheyyamo

  • @XLnCADMalayalam

    @XLnCADMalayalam

    4 жыл бұрын

    Glad to hear that. Regarding your request, I recommend to watch my video on Creating Serial Numbers Automatically, video on Creating Invoice Template in Excel and Videos on Macros.

  • @manissery1956
    @manissery19564 жыл бұрын

    Good work Mr Ajay. Unfortunately recently only subscribed yr channel. Regret I might have lost a number of topics from you. Kindly let me know how to get back to yr previous lessons.

  • @XLnCADMalayalam

    @XLnCADMalayalam

    4 жыл бұрын

    Glad to hear that Mr. Haridas. You can go through the *Videos* section of this channel and find the previous releases. Moreover, videos are also arranged into different playlists according to the topics covered in it. Please check the playlist section for the same.

  • @manissery1956

    @manissery1956

    4 жыл бұрын

    @@XLnCADMalayalam വളരെ നന്ദി. ഓരോ കമന്റിനും മറുപടി തരുന്ന തങ്ങൾക്ക് 1000 നന്ദി.

  • @abdullatheefp8755
    @abdullatheefp87552 жыл бұрын

    Upper case ലോവർ case arrange ചെയ്തു disorder കിടക്കുന്നത് delte ചെയുമ്പോൾ എല്ലാം ഡിലീറ്റ് ആവുന്നു.എങ്ങനെ പരിഹരിക്കാം

  • @ziagi0076
    @ziagi00763 жыл бұрын

    Type cheyunna timil thanne Automatic Proper casilekk Letters varan enthan vazhi?

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 жыл бұрын

    You can use AutoCorrect feature for the same. There a good number of videos available on this topic.

  • @thejinbharath4658
    @thejinbharath46584 жыл бұрын

    When I copy and paste on the next sheet, the filter is on, so it doesn't paste

  • @XLnCADMalayalam

    @XLnCADMalayalam

    2 жыл бұрын

    You mean to say that you can't 'turn off' the Filter?

  • @shaibinbabu3149
    @shaibinbabu31494 жыл бұрын

    =sum(c1+c2-c3) enn eqtion upayogich c5 il 50nu mukalil answers kandethi, but kittiya answers mattoru sheetilekk copy cheyyan sadikkunnilla... can u help me?

  • @XLnCADMalayalam

    @XLnCADMalayalam

    4 жыл бұрын

    If you want to copy the values only, use Paste as Values option. Moreover, watch my videos on Basic Excel Tutorial to get a clear idea about writing Excel formulas.

  • @shaibinbabu3149

    @shaibinbabu3149

    4 жыл бұрын

    @@XLnCADMalayalam thank u

  • @sunilkumarak5793

    @sunilkumarak5793

    Жыл бұрын

    Answer ഏത് cell ൽ കിട്ടണമോ, ആ cell select ചെയ്ത് "=" ടൈപ്പ് ചെയ്‌ത്, answer ഇപ്പോൾ ഉള്ള sheet ൽ പോയി സംഖ്യ ഉൾക്കൊള്ളുന്ന cell സെലക്ട് ചെയ്യുക entre key press ചെയ്യുക..

  • @bibinbabu2486
    @bibinbabu24864 жыл бұрын

    Line break cheyyan wrap text kodthalum sari akile ?

  • @XLnCADMalayalam

    @XLnCADMalayalam

    4 жыл бұрын

    When 'Wrap Text' is applied, it will look like the line breaks are gone. But line breaks remain. Copy the data and paste it into any text editor see that.

  • @bibinbabu2486

    @bibinbabu2486

    4 жыл бұрын

    @@XLnCADMalayalam ok thank you brother

  • @sunilkumarak5793

    @sunilkumarak5793

    Жыл бұрын

    നീളമുള്ള Cell ൽ wrap text ഫലപ്രദമാവില്ല. അതിന് break ആവശ്യമുള്ള സ്ഥലത്ത് വച്ച് Alt+entre key press ചെയ്യുന്നതാണ് നല്ലത്

  • @satinafetish2979
    @satinafetish29794 жыл бұрын

    Extra space ulla kolam delete cheyyumbol formula error വരുന്ന്

  • @XLnCADMalayalam

    @XLnCADMalayalam

    4 жыл бұрын

    When we delete a column containing values that are used in different formulas, those formulas will return #REF error.

  • @gccnowshad4483
    @gccnowshad44832 жыл бұрын

    വ്യത്യസ്തങ്ങളായ കോളങ്ങളിൽ നിന്നും ഒറ്റ കോളത്തിലേയ്ക്ക് കൊണ്ട് വരുന്നതിനുള്ള എന്തെങ്കിലും വഴി ഉണ്ടോ, ഉണ്ടെങ്കിൽ ആ വിഡിയോ ലിങ്ക് ഷെയർ ചെയ്യുമോ

  • @XLnCADMalayalam

    @XLnCADMalayalam

    2 жыл бұрын

    Please check my videos on COCATENATE, CONCAT Functions and Flash Fill in Excel.

  • @sunilkumarak5793

    @sunilkumarak5793

    Жыл бұрын

    പുതിയ cell select ചെയ്യുക, = ടൈപ്പ് ചെയ്‌ത ശേഷം ആദ്യത്തെ data ഉൾക്കൊള്ളുന്ന cell sellect ചെയ്യുന്നു അതിനു ശേഷം & എന്ന് ടൈപ്പ് ചെയ്യുന്നു, ആവശ്യമെങ്കിൽ " " ഇത് പോലെ double quots നുള്ളിൽ space കൊടുത്ത് രണ്ടാമത്തെ data ഉള്ള cell sellect ചെയ്യുന്നു.. ഇതു പോലെ എത്ര cell ൽ data ഉണ്ടോ അത്രയും cell കൾ sellect ചെയ്യുക entre key press ചെയ്യുക. ഓരോ cell value വിനും ഇടയിൽ & എന്ന് ചേർക്കാൻ മറക്കരുത്...

  • @aswanishsr
    @aswanishsr4 жыл бұрын

    ലൈൻ ബ്രേക്ക് ഒഴിവാകുന്നില്ല

  • @XLnCADMalayalam

    @XLnCADMalayalam

    4 жыл бұрын

    What happened? What is the message?

  • @Samu-gz3qj
    @Samu-gz3qj24 күн бұрын

    Very slow. It will be interesting if you speak little faster.

  • @jobyjohnsonjohnson4319
    @jobyjohnsonjohnson43193 жыл бұрын

    Very useful. Thank you

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 жыл бұрын

    Glad it was useful!