10 Excel Tricks for Data Cleaning and Analysis

[@rajivranjan-mf6zu]

You are "Master Chef Of Excel".... Great tricks sir very useful for daily working... Main khud ko lucky manta hu ki main INNOZANT family se juda aur aapse itna kuch sikhne ko mila... Hats off sir.

[@Innozant]

Thanks Rajiv.. Really means a lot to me dear ❤️❤️ Happy Learning..God bless you.Have a wonderful career ahead

[@tejpalsain1507]

बहुत ही जबरदस्त ओर उपयोगी हमारे लिए। Thanks

[@Innozant]

Thanks Tejpal ji🙏❤️

[@AnkitKumar-io3dv]

Sir aise hi video banate rahe your video is more helpful me

[@Innozant]

👍

[@West_Side100]

It's Very useful process Love form Nepal🇳🇵

[@sandeepaswal8944]

Sir aapkai Excel Tricks hamesa nayi skill shikhtai hai aap bahut dhanywaad sir ji.

[@Innozant]

Thanks Sandeep ji🙏❤️

[@sandeepaswal8944]

@@Innozant Sir aap Google sheet par bhi videos create karna plz.

[@Innozant]

Sure Sandeep Ji

[@shrikantbadge3978]

Amazing Beautiful Practical Useful Helpful ❤❤

[@Rajeshparihar9794]

Kya gajab ka knowledge paaya hain sir aapne🙏🎯

[@Innozant]

Thanks dear

[@Jitenderkumar-yp1rn]

Really sir... you are genius ❤❤❤

[@Innozant]

Thanks Jitender Ji .Happy Learning ❤️🙏

[@dillonpereira3274]

@@Innozant I have names of companies like for example PetroChinaCanadaLtd and I want it to look like Petro China Canada Ltd . How to do it ? I have a list of 8k I can't do it manually

[@shrikantbadge3978]

One comment below says sir's smile is attractive. It is true. The reason is i think sir has fought a lot to achieve his goals, he suffered a lot. He paid the price for his achievements. Such people's smile is always beautiful.

[@prakashchordia3899]

excellent, ur way to explain and ask participants to open excel sheet and try is very useful and it immediately helping and saving a lot time. ur smile is also attractive to listen more and more from u.

[@Innozant]

Thanks dear for your valuable appreciation.Have. A wonderful career ahead

[@perfectlover9918]

Bohot kaam ki h sir ji thank you so much

[@Innozant]

Thanks dear🙏❤️

[@kishorpanara4191]

Very good tips and tricks thank you sir

[@Innozant]

Thanks Kishor..Good Night..tc

[@mayankbhatt1790]

Nyc vedio I have tried one thing Jaisa aap Bata rahe cltrl ke saath click krke copy nikal rahe the vaisa Ctrl ke saath alt and click krke second sheet pe data copy krke nikala ja skta hai or agar Ctrl Chordh denge toh vo selected text cut ho jayega This is also a amazing trick

[@devmahawar2570]

Very use full tick sir 👍👍👍👍

[@Innozant]

Thanks ❤️

[@shilendrakumar5132]

Your smile face is also get attract your style of teaching Best approach of teaching and simple way of teaching Hats off to you sir

[@Innozant]

❤️❤️😚 Thanks dear for being part of Innozant.Happy Learning

[@hsgusain2054]

Very good tricks.. thanks

[@Innozant]

Thanks Gusain sahab🙏❤️❤️

[@vinothkumarmanoharan2317]

Awesome tips

[@subramanyaindian7084]

SIR i really have a great fan of you. i have learnt many things by you

[@Innozant]

Thanks Subbu ❤️❤️

[@createyour6681]

Very great sir

[@Innozant]

Thanks dear🙏❤️

[@curious1245]

Thanks brother, you are doing great job.🙏

[@Innozant]

Thanks Amit Ji..Sukriya Dilse❤️🙏

[@subramanyaindian7084]

it helped in my office works. i am a karnataka state govt employee

[@RahulKumar-ly6ly]

Thanks sir very helpful video

[@Innozant]

Thanks Rahul Ji.God Bless You dear❤️

[@kishanmishra9611]

It's very topic for me.. so thnkyou sir give us a fantastic ...trick 🙏

[@Innozant]

Thanks Kishan 🙏❤️

[@gautamdas3848]

Super sir..Great

[@tt_badmash_9560]

Excellent

[@dsraghav2882]

Hi Sir, I watch continuously your video with fabulous/ mind blowing teaching . I have cleared so many Interview now I am working with IT Company. Thanks for added value in my file please send me VBA course link because I working as MIS Executive. Love you sir

[@Innozant]

Thanks Raghav..Have a wonderful career ahead

[@muhammadyounis2686]

Sir although your content is matchless but way of illustration is mind-blowing. love n respect from Karachi 🇵🇰🙏🙏🙏🙏🙏

[@Innozant]

Really means a lot to me 😊❤️👍

[@bishtlokesh1297]

This type video very useful for mis work

[@Innozant]

Thanks Lokesh Ji .Happy Learning

[@bishtlokesh1297]

@@Innozant yeah tricks bht helpful hoge bht jyada thank you so much for this amazing video❤️

[@sarangkulkarni5740]

Nice tips

[@Innozant]

Thanks 🙏❤️

[@swagatamkhanra4667]

Thank u sir,, text to columns series mein ctrl+j shortcut jo hai uska implementation briefly explain karenge to bohot meherbani hogi

[@Innozant]

Ok .kar denge kisi video me aage

[@swagatamkhanra4667]

@@Innozant thank u sir ,,♥️dil se..

[@manojkumarsingh3385]

Very important trick Sir 🙏🙏🙏

[@Innozant]

Thanks Manoj Ji.. Happy Learning

[@sandipsingh8377]

Great tricks

[@Innozant]

Thanks Sandip ji🙏❤️

[@jayantabhattacharyya628]

Dear Sir Many Many thanks for uploading such a very useful & much needed tutorial. Such time saving tips & tricks really helps me a lot. I'm fortunate to be a part of INNOZANT family. God bless you. Thanks & Regards Jayanta Bhattacharyya

[@pradeepnegi7523]

Jabardast sandar sir

[@Innozant]

Thanks

[@hafiztahir9760]

Thank you sir

[@ankitjindaljulana]

Thank you sir

[@Innozant]

Thanks Ankit ❤️🙏

[@pushkalupadhyay]

Thnk u so much sir u observed my requirement thnx a lot

[@Innozant]

Thanks Pushkal..🙏❤️

[@nikhilmore6129]

Dear Sir, All your videos have added value to my life. Thank you so much..! Request# Pls start VBA videos.. - Mumbai

[@Innozant]

Thanks Nikhil Ji..Happy Learning dear..God Bless You..Have a wonderful career ahead 🙏❤️

[@rohitkumar-v2q9n]

SUPER VIDEO SIR

[@mohanpal13555]

Very impressive vedio

[@Innozant]

Thanks dear

[@khalidalisubhanallah2947]

Sir g tu c great 👌 ho.

[@Innozant]

Thanks Khalid Ali Sahab🙏❤️Good Night

[@khalidalisubhanallah2947]

Gud 9it sir g

[@umairzahid3743]

Zabardast sir g

[@Innozant]

🙏❤️❤️

[@syedfaraz1903]

Sr plz guide me about index but reverse full cells in one attempt or provide me that vdo link plz

[@jagdishagarwal4173]

Hi thanks for posting video. In the shortcut method for shifting place of column, if there is any formula in that column then I am have seen that this trick does not work because the value gets changed as per formula reference. Please help how to change column content which is formula without changing the values on shifting

[@prahalladjena1634]

ms Excel 2007 is not showing pivot table multiple sheets options. Please please guide me. I shall be greatfull to you.

[@Innozant]

Using alt d p?

[@surendraclia]

SUPERB

[@Innozant]

Thanks

[@hrhelpteam]

Sir Excel main automatic Uppercase ya Lowercase kaise kiya jata hai forcefully hum kisi bhi format main entry kare, bina formula ya VBA use kiye. (=upper(text) ye nahi karna pade), data validation se possible hai kya ?

[@Innozant]

Vbs use kr lein easily ho jayega usse

[@hrhelpteam]

Ok sir thanks

[@PraveenSingh-no09ol]

Hi Sir, number me extra spaces remove karna kaise hoga koi short cut bataiye

[@Innozant]

Trim use kriye

[@sonukumarskp6933]

Pls help Pivot table banane Ka baad jab next day Refresh karte h to ye error kyu aata hai ?? Can't open PivotTable source file '[DRI Coal 12.06.2021.xlsx]SA Coal

[@durgeshrai8938]

Nyc great sir

[@Innozant]

Thanks Durgesh Ji..Happy Learning 🙏❤️

[@durgeshrai8938]

Sir plz provide kre mis job ke liye consultant ka number mai delhi c hu

[@Innozant]

Aap apna cv preparw krke...aur ydi aap confident ho gye hain adv excel me to cv bhejen.. Assessment test leke apko reference provide karane ki koshish krenge

[@durgeshrai8938]

Tnku sir

[@dillonpereira3274]

I have names of companies like for example PetroChinaCanadaLtd and I want it to look like Petro China Canada Ltd . How to do it ? I have a list of 8k I can't do it manually

[@pushkalupadhyay]

Sir how to replace pushkal उपाध्याय with pushkal upadhyay or agar koi name hindi me use English me kese replace kar convert kar sakte hai

[@Innozant]

Hindi font ki jarurt hogi na krti dev

[@pushkalupadhyay]

@@Innozant excel me convert ka koi option nhi hai kya

[@vikrambisht5321]

Nice

[@Innozant]

❤️

[@onlyexcel493]

Frist viewer

[@Innozant]

Wow.. Thanks dear🙏🙏❤️❤️

[@naeemfarooq6830]

as we found max value by using max(if(....., between two dates, can we also use vlookup between two dates, example, i have some data of three months on daily basis i found max value bw 2 months , but when i use vlookup to see when was this value occur, vlookup gets first occur date , how can we control better, plz guide

[@Innozant]

If you want to vlookup to find duolicate lookup value kindly make a helper column using countif then proceed with your formula. If unable to find your solution kindly share your sheet on @innozantofflcial telegram id

[@excellearners7976]

NYC

[@jaswinderkumar2612]

Hello Sir. I want to send a sheet to u. I need one help. Could u please oblige??

[@Innozant]

@innozantofficial telegram id

[@jaswinderkumar2612]

@@Innozant i have massaged u there. Plz respond

[@RahulRoy-po9ct]

🙏

[@funny15]

excell two cell data if same result true otherwise false Excell 2003 possible.....? Example- Name. Class Amit. 2 Amit. 3 Amit. 2 Highlight only Amit 2 How to process possible........

[@Innozant]

Done it with Exact function..You may compare string and then evaluate

[@abusiddik8265]

🙏👍👍👍

[@Innozant]

Thanks 🙏❤️

[@ghumansaab2314]

Sir aapne Whole number OR Decimal number Tricks Add nahi ki aap ne bola tha add kar denge ☹️

[@Innozant]

Oho..dhyan nhi rhta itna dear..bht saare query aate hain...❤️🙏

[@ghumansaab2314]

@@Innozant Sir me wait kar raha tha kab se ab next video kar dena please

[@ArunArun-qo9dp]

Sir please upload in English sir please sir please sir 🙏🙏🙏🙏

[@aqeelahmadengr3]

Like

[@Innozant]

🙏❤️

[@akshaywadiya5749]

sir...I have sent you mail regarding my excel query, Could you Please check your inbox & help to get it resolved if you could help me i would be very grateful to you

[@Innozant]

Kindly send your query @innozantofficial telegram id.Wil see

[@jitendrashrivastava8919]

Very much useful

[@manjit.sarania]

All excellent sir

[@tt_badmash_9560]

Nice