You can watch the video of the webinar here, might want to fast forward the glitched part.
As a compensation, I will be taking you through the crux of what I shared in the webinar with plenty easy to follow screenshots.
1. Text to Column
Sometimes, you copy data from other applications into Excel and they don't get arranged the way you want. Maybe you copied customer data records with first name, last name and email and instead of Excel putting them in different columns/fields, you get them sandwiched into one field. How do you easily remedy that?
Well, I am happy to introduce you to Text to Column.
To fix this, go to Data Menu, Text to Column and in a matter of 3, 4 clicks you are done. Even for a hundred thousand records table.
2. TRIM
Got text data with the spacing irregularly done? No worries, meet TRIM.
It can turn records that look like this:
Into this pleasant looking one:
3. PROPER and UPPER
Got text or names written with all lower case or terrible mix of the cases? Time to fix them looking Proper or all in UPPER.
4. Go To Special, Blanks
There is something definitely special about Go To Special beyond its name.
Have you got records arranged disorderly and you want to align the arrangement. Take for example, the one in the screenshot below.
With Go To Special, select Blanks. Then right click on the highlighted Blanks and Delete, shifting cells to the left. And, voila! It is done!
5. Removing Duplicates
Say you have a table with duplicate records. How do you remove the duplicate entries, leaving one unique record?
You guessed right: by using remove duplicates.
Here is a sample problem to attack.
First, we'll make Excel show us the duplicate records using conditional formatting. It's not a requirement. Just doing it for fun or maybe you really want to see the duplicate records before deleting them.
Now let's remove the duplicate values. Go to Data Menu, Remove Duplicates.
See result below. Sparkling clean. No more greasy duplicates.
6. Text 2 Number
Sometimes, you import or copy numeric data into Excel and they show up as Text. For you to run regular calculations, with peace of mind, on them you need to convert them back to numbers.
If you are lucky, which is the usual case, Excel will show you a diamond tool tip to guide you in converting the Text numbers to Number numbers😀.
Say today you weren't that lucky. No diamond tool tip. How do you proceed, and considering there are hundreds or thousands of records to fix at once.
Well, use what I call Text 2 Number.
Just type 1 in any empty cell, copy it and paste special on the problematic entries but as Value and Multiply.
That fixes it in one step for you.
7. Go To Special, Errors
How do you select Error cells in your report and maybe replace them with something more meaningful or delete them all at once?
Again, meet Go To Special.

8. Find and Replace Formula Parts
Find and Replace can work also on formula components. I often use it in making giant templates or in cleaning up my formulas after considerable report structure change.
9. Spelling Check and Auto Correct
Surprised? Well, Excel does have spell check and auto correct.
And those are the Data Cleaning tips we treated yesterday during the webinar.
Don't forget to forward this to friends and family members who will find this useful and love you more for it. And you should subscribe to our webinar directory to be in the loop of all future webinar announcements.
Took me time to read all the comments, but I really enjoyed the article. It proved to be Very helpful to me and I am sure to all the commenters here! It’s always nice when you can not only be informed, but also entertained!
ReplyDeletedata science training in guntur
Machine Learning Projects for Final Year machine learning projects for final year
DeleteDeep Learning Projects assist final year students with improving your applied Deep Learning skills rapidly while allowing you to investigate an intriguing point. Furthermore, you can include Deep Learning projects for final year into your portfolio, making it simpler to get a vocation, discover cool profession openings, and Deep Learning Projects for Final Year even arrange a more significant compensation.
Python Training in Chennai
Python Training in Chennai
Angular Training Project Centers in Chennai
Cleaning agendas make it simpler for individuals to guarantee that all zones of their homes are tended to.best hardwood floor mop and vacuum cleaner
ReplyDeleteGreat article with excellent information found resourceful and enjoyed reading it thank you, looking forward for next blog.
ReplyDeletetypeerror nonetype object is not subscriptable
ReplyDeleteReally, this article is truly one of the best, information shared was valuable and resourceful Very good work thank you.
Data Scientist Training in Hyderabad
I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own Blog Engine blog now. Really the blogging is spreading its wings rapidly. Your write up is a fine example of it.
ReplyDeletemachine learning course training in Hyderabad
wow, great, I was wondering how to cure acne naturally. and found your site by google, learned a lot, now i’m a bit clear. I’ve bookmark your site and also add rss. keep us updated.
ReplyDeletebusiness analytics training in Hyderabad
I have to search sites with relevant information ,This is a
ReplyDeletewonderful blog,These type of blog keeps the users interest in
the website, i am impressed. thank you.
Data Science Course in Bangalore
I have to search sites with relevant information ,This is a
ReplyDeletewonderful blog,These type of blog keeps the users interest in
the website, i am impressed. thank you.
Data Science Training in Bangalore
Aivivu - đại lý chuyên vé máy bay trong nước và quốc tế
ReplyDeletevé máy bay đi Mỹ giá rẻ 2021
ve may bay từ mỹ về việt nam hãng eva
vé bay hà nội sài gòn
vé máy bay ra hà nội
vé máy bay sài gòn đà lạt pacific airlines
i am glad to discover this page : i have to thank you for the time i spent on this especially great reading !! i really liked each part and also bookmarked you for new information on your site.
ReplyDeletedata science training in bangalore
Excellent Blog! I would like to thank for the efforts you have made in writing this post. I am hoping the same best work from you in the future as well. I wanted to thank you for this websites! Thanks for sharing. Great websites!
ReplyDeleteData Science Training in Bangalore
I am a new user of this site, so here I saw several articles and posts published on this site, I am more interested in some of them, hope you will provide more information on these topics in your next articles.
ReplyDeletedata analytics training in bangalore
I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors.
ReplyDeletedata science course fees in bangalore
I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page!
ReplyDeletedata analytics course in bangalore
I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging endeavours.
ReplyDeletedata science certification in bangalore
Great post i must say and thanks for the information. Education is definitely a sticky subject. However, is still among the leading topics of our time. I appreciate your post and look forward to more.
ReplyDeleteData Science Course in Bangalore
Thanks for posting the best information and the blog is very helpful.data science institutes in hyderabad
ReplyDeleteInformative blog
ReplyDeletedata analytics courses in hyderabad
Thanks for posting the best information and the blog is very important.artificial intelligence course in hyderabad
ReplyDeleteI curious more interest in some of them hope you will give more information on this topics in your next articles.
ReplyDeleteBest Data Science courses in Hyderabad
instagram takipçi satın al - instagram takipçi satın al - tiktok takipçi satın al - instagram takipçi satın al - instagram beğeni satın al - instagram takipçi satın al - instagram takipçi satın al - instagram takipçi satın al - instagram takipçi satın al - binance güvenilir mi - binance güvenilir mi - binance güvenilir mi - binance güvenilir mi - instagram beğeni satın al - instagram beğeni satın al - polen filtresi - google haritalara yer ekleme - btcturk güvenilir mi - binance hesap açma - kuşadası kiralık villa - tiktok izlenme satın al - instagram takipçi satın al - sms onay - paribu sahibi - binance sahibi - btcturk sahibi - paribu ne zaman kuruldu - binance ne zaman kuruldu - btcturk ne zaman kuruldu - youtube izlenme satın al - torrent oyun - google haritalara yer ekleme - altyapısız internet - bedava internet - no deposit bonus forex - erkek spor ayakkabı - webturkey.net - minecraft premium hesap - karfiltre.com - tiktok jeton hilesi - tiktok beğeni satın al - microsoft word indir - misli indir
ReplyDeleteThanks for posting the best information and the blog is very important.data science institutes in hyderabad
ReplyDeleteI am glad to discover this page. I have to thank you for the time I spent on this especially great reading !! I really liked each part and also bookmarked you for new information on your site.
ReplyDeleteData Science Course Syllabus
I am glad to discover this page. I have to thank you for the time I spent on this especially great reading !! I really liked each part and also bookmarked you for new information on your site.
ReplyDeleteData Science Training in Chennai
Fantastic article I ought to say and thanks to the info. Instruction is absolutely a sticky topic. But remains one of the top issues of the time. I love your article and look forward to more.
ReplyDeleteData Science Course in Bangalore
Thank you quite much for discussing this type of helpful informative article. Will certainly stored and reevaluate your Website.
ReplyDeleteData Analytics Course in Bangalore
i am glad to discover this page : i have to thank you for the time i spent on this especially great reading !! i really liked each part and also bookmarked you for new information on your site.
ReplyDeleteartificial intelligence training in chennai
Very wonderful informative article. I appreciated looking at your article. Very wonderful reveal. I would like to twit this on my followers. Many thanks! .
ReplyDeleteData Analytics training in Bangalore
Terrific post thoroughly enjoyed reading the blog and more over found to be the tremendous one. In fact, educating the participants with it's amazing content. Hope you share the similar content consecutively.
ReplyDeletedata science course in varanasi
Nice to be seeing your site once again, it's been weeks for me. This article which ive been waited for so long. I need this guide to complete my mission inside the school, and it's same issue together along with your essay. Thanks, pleasant share.
ReplyDeleteData Science training in Bangalore
youtube abone satın al /n trendyol indirim kodu
ReplyDeletecami avizesi
cami avizeleri
avize cami
no deposit bonus forex 2021
takipçi satın al
takipçi satın al
takipçi satın al
takipcialdim.com/tiktok-takipci-satin-al/
instagram beğeni satın al
instagram beğeni satın al
btcturk
tiktok izlenme satın al
sms onay
youtube izlenme satın al
no deposit bonus forex 2021
tiktok jeton hilesi
tiktok beğeni satın al
binance
takipçi satın al
uc satın al
sms onay
sms onay
tiktok takipçi satın al
tiktok beğeni satın al
twitter takipçi satın al
trend topic satın al
youtube abone satın al
instagram beğeni satın al
tiktok beğeni satın al
twitter takipçi satın al
trend topic satın al
youtube abone satın al
takipcialdim.com/instagram-begeni-satin-al/
perde modelleri
instagram takipçi satın al
instagram takipçi satın al
takipçi satın al
instagram takipçi satın al
betboo
marsbahis
sultanbet
aşk kitapları
ReplyDeletetiktok takipçi satın al
instagram beğeni satın al
youtube abone satın al
twitter takipçi satın al
tiktok beğeni satın al
tiktok izlenme satın al
twitter takipçi satın al
tiktok takipçi satın al
youtube abone satın al
tiktok beğeni satın al
instagram beğeni satın al
trend topic satın al
trend topic satın al
youtube abone satın al
takipçi satın al
beğeni satın al
tiktok izlenme satın al
sms onay
youtube izlenme satın al
tiktok beğeni satın al
sms onay
sms onay
perde modelleri
instagram takipçi satın al
takipçi satın al
tiktok jeton hilesi
instagram takipçi satın al pubg uc satın al
sultanbet
marsbahis
betboo
betboo
betboo
الشركة الاولي في مدينة الخرج التي تقدم جميع الخدمات من حيث التنظيف ومكافحة الحشرات والتعقيم باحدث المعدات والاجهزة العالمية عمال في غاية الاتقان والخبرة .
ReplyDeleteشركة تنظيف مكيفات بالخرج
شركة تنظيف مساجد بالخرج
شركة تعقيم بالخرج
شركة مكافحة حشرات بالخرج
شركة رش مبيدات بالخرج
شركة مكافحة نمل ابيض بالخرج
I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors.
ReplyDeletedata science training in chennai
takipçi satın al
ReplyDeleteinstagram takipçi satın al
https://www.takipcikenti.com
Thanks for posting the best information and the blog is very important.data science course in Lucknow
ReplyDeleteThanks for sharing this.
ReplyDeleteWhenever I open an Excel file on my computer, a message appears stating that the file format does not match the file destination and is corrupted or unsafe. What is that mean, and how this issue can be fixed? Assignment Writing Services
ReplyDeleteSo-called sash balances of various kinds are on the market, which seem to work rather well, especially when they are new; these work on the principle of winding and unwinding a spring. Be sure the windows are sufficiently counterbalanced in some way so that they operate freely and easily.https://www.westseattlewindowcleaner.com/pressure-washing-bellevue-homeowners-best-friend
ReplyDeleteseo fiyatları
ReplyDeletesaç ekimi
dedektör
instagram takipçi satın al
ankara evden eve nakliyat
fantezi iç giyim
sosyal medya yönetimi
mobil ödeme bozdurma
kripto para nasıl alınır
instagram beğeni satın al
ReplyDeleteyurtdışı kargo
seo fiyatları
saç ekimi
dedektör
fantazi iç giyim
sosyal medya yönetimi
farmasi üyelik
mobil ödeme bozdurma
bitcoin nasıl alınır
ReplyDeletetiktok jeton hilesi
youtube abone satın al
gate io güvenilir mi
referans kimliği nedir
tiktok takipçi satın al
bitcoin nasıl alınır
mobil ödeme bozdurma
mobil ödeme bozdurma
mmorpg oyunları
ReplyDeleteinstagram takipci satin al
Tiktok jeton hilesi
Tiktok jeton hilesi
antalya saç ekimi
İNSTAGRAM TAKİPÇİ SATIN AL
Takipci satın al
Metin pvp
TAKİPÇİ SATIN AL
minecraft premium
ReplyDeleteen son çıkan perde modelleri
uc satın al
en son çıkan perde modelleri
lisans satın al
özel ambulans
nft nasıl alınır
yurtdışı kargo