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
Bro oro videoyum ente office workine orupadu usefull ayi
I reffer to all of My friends Sir. Loved it. ❤️❤️❤️
@XLnCADMalayalam
3 жыл бұрын
Thank you for that :)
It was really helpful. Appreciate.
@XLnCADMalayalam
11 ай бұрын
😀
Thanks sir very best class 🥰👍
It is very useful and interesting
@XLnCADMalayalam
Жыл бұрын
Glad to hear that😀
It's awesome chettaii... Very usefull
@XLnCADMalayalam
3 жыл бұрын
Thank you 🙂
Njan orupad thedi nadanna videos aan Sir ithellam. Oru rakshayumilla. Thank You so much for a wonderful work Sir. ❤️❤️❤️
@XLnCADMalayalam
3 жыл бұрын
That's an awesome compliment. Thank you :)
Very useful,Thank you
@XLnCADMalayalam
4 жыл бұрын
You are welcome
വളരെ പ്രയോജനപ്രദം.... നന്ദി...
@XLnCADMalayalam
3 жыл бұрын
My pleasure
Your videos are usefull
@XLnCADMalayalam
2 жыл бұрын
Glad you think so!
Thanks
@XLnCADMalayalam
3 жыл бұрын
It's my pleasure. Which one is your fav. Tool or Method?
As usual , excellent explanation !! Such a sweet and wonderful Malayalam, Sir !! 🤓🤓🤓😍😍😍 Hugs from MtNegro !! P.S. I looove kk
@XLnCADMalayalam
4 жыл бұрын
My pleasure Madam :) Have you seen the names in the Examples? No points for guessing it Right 😉😎
@10morrisonka
4 жыл бұрын
@@XLnCADMalayalam Mister, have you seen I wrote I love kk ( kitkat) ?:-)😚😚😚
@XLnCADMalayalam
4 жыл бұрын
@@10morrisonka I see that Madam 😊 Now, l know what to bring while visiting MonteNegro 😉
Great very useful
@XLnCADMalayalam
2 жыл бұрын
Thank you :)
Oru nandi paranjilla enkil daivam porukkilla.... thanks
@XLnCADMalayalam
4 жыл бұрын
You are welcome :)
Super classes
@abdulnazervalappil
2 жыл бұрын
Thanks 👍
👌👌👌....
@XLnCADMalayalam
4 жыл бұрын
😀✋
Nice presentation....
@XLnCADMalayalam
3 жыл бұрын
Thank you! Cheers!
Good🥰🥰🥰
@XLnCADMalayalam
2 жыл бұрын
Thank you! Cheers!
Sooper
@XLnCADMalayalam
4 жыл бұрын
😀
Very good explanation Thanks A small request Automatic invoice number generate cheyyunnathine kurichu oru video cheyyamo
@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.
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
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
4 жыл бұрын
@@XLnCADMalayalam വളരെ നന്ദി. ഓരോ കമന്റിനും മറുപടി തരുന്ന തങ്ങൾക്ക് 1000 നന്ദി.
Upper case ലോവർ case arrange ചെയ്തു disorder കിടക്കുന്നത് delte ചെയുമ്പോൾ എല്ലാം ഡിലീറ്റ് ആവുന്നു.എങ്ങനെ പരിഹരിക്കാം
Type cheyunna timil thanne Automatic Proper casilekk Letters varan enthan vazhi?
@XLnCADMalayalam
3 жыл бұрын
You can use AutoCorrect feature for the same. There a good number of videos available on this topic.
When I copy and paste on the next sheet, the filter is on, so it doesn't paste
@XLnCADMalayalam
2 жыл бұрын
You mean to say that you can't 'turn off' the Filter?
=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
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
4 жыл бұрын
@@XLnCADMalayalam thank u
@sunilkumarak5793
Жыл бұрын
Answer ഏത് cell ൽ കിട്ടണമോ, ആ cell select ചെയ്ത് "=" ടൈപ്പ് ചെയ്ത്, answer ഇപ്പോൾ ഉള്ള sheet ൽ പോയി സംഖ്യ ഉൾക്കൊള്ളുന്ന cell സെലക്ട് ചെയ്യുക entre key press ചെയ്യുക..
Line break cheyyan wrap text kodthalum sari akile ?
@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
4 жыл бұрын
@@XLnCADMalayalam ok thank you brother
@sunilkumarak5793
Жыл бұрын
നീളമുള്ള Cell ൽ wrap text ഫലപ്രദമാവില്ല. അതിന് break ആവശ്യമുള്ള സ്ഥലത്ത് വച്ച് Alt+entre key press ചെയ്യുന്നതാണ് നല്ലത്
Extra space ulla kolam delete cheyyumbol formula error വരുന്ന്
@XLnCADMalayalam
4 жыл бұрын
When we delete a column containing values that are used in different formulas, those formulas will return #REF error.
വ്യത്യസ്തങ്ങളായ കോളങ്ങളിൽ നിന്നും ഒറ്റ കോളത്തിലേയ്ക്ക് കൊണ്ട് വരുന്നതിനുള്ള എന്തെങ്കിലും വഴി ഉണ്ടോ, ഉണ്ടെങ്കിൽ ആ വിഡിയോ ലിങ്ക് ഷെയർ ചെയ്യുമോ
@XLnCADMalayalam
2 жыл бұрын
Please check my videos on COCATENATE, CONCAT Functions and Flash Fill in Excel.
@sunilkumarak5793
Жыл бұрын
പുതിയ cell select ചെയ്യുക, = ടൈപ്പ് ചെയ്ത ശേഷം ആദ്യത്തെ data ഉൾക്കൊള്ളുന്ന cell sellect ചെയ്യുന്നു അതിനു ശേഷം & എന്ന് ടൈപ്പ് ചെയ്യുന്നു, ആവശ്യമെങ്കിൽ " " ഇത് പോലെ double quots നുള്ളിൽ space കൊടുത്ത് രണ്ടാമത്തെ data ഉള്ള cell sellect ചെയ്യുന്നു.. ഇതു പോലെ എത്ര cell ൽ data ഉണ്ടോ അത്രയും cell കൾ sellect ചെയ്യുക entre key press ചെയ്യുക. ഓരോ cell value വിനും ഇടയിൽ & എന്ന് ചേർക്കാൻ മറക്കരുത്...
ലൈൻ ബ്രേക്ക് ഒഴിവാകുന്നില്ല
@XLnCADMalayalam
4 жыл бұрын
What happened? What is the message?
Very slow. It will be interesting if you speak little faster.
Very useful. Thank you
@XLnCADMalayalam
3 жыл бұрын
Glad it was useful!