10 Excel Tricks for Data Cleaning and Analysis
Вставка
- Опубліковано 15 вер 2024
- 10 Excel Tricks for Data Cleaning and Analysis
Excel Tips & Tricks Playlist Link- • Excel Tips & Tricks
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Music: www.bensound.com
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.c...
✅ Mastering Power BI Video Course
www.innozant.c...
✅ Mastering VBA Video Course
www.innozant.c...
✅ Mastering SQL Video Course
www.innozant.c...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozanti...
#exceltipsandtricksd #dataanalysis#innozant #exceltipsandtricks
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.
Thanks Rajiv.. Really means a lot to me dear ❤️❤️ Happy Learning..God bless you.Have a wonderful career ahead
It's Very useful process Love form Nepal🇳🇵
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
Sir aapkai Excel Tricks hamesa nayi skill shikhtai hai aap bahut dhanywaad sir ji.
Thanks Sandeep ji🙏❤️
@@Innozant Sir aap Google sheet par bhi videos create karna plz.
Sure Sandeep Ji
Kya gajab ka knowledge paaya hain sir aapne🙏🎯
Thanks dear
Sir aise hi video banate rahe your video is more helpful me
👍
Very use full tick sir 👍👍👍👍
Thanks ❤️
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
Thanks Raghav..Have a wonderful career ahead
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
❤️❤️😚 Thanks dear for being part of Innozant.Happy Learning
Awesome tips
Very good tricks.. thanks
Thanks Gusain sahab🙏❤️❤️
Very much useful
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.
Thanks dear for your valuable appreciation.Have. A wonderful career ahead
All excellent sir
बहुत ही जबरदस्त ओर उपयोगी हमारे लिए।
Thanks
Thanks Tejpal ji🙏❤️
Really sir... you are genius ❤❤❤
Thanks Jitender Ji .Happy Learning ❤️🙏
@@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
Bohot kaam ki h sir ji thank you so much
Thanks dear🙏❤️
Super sir..Great
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
SIR i really have a great fan of you. i have learnt many things by you
Thanks Subbu ❤️❤️
Sir although your content is matchless but way of illustration is mind-blowing. love n respect from Karachi 🇵🇰🙏🙏🙏🙏🙏
Really means a lot to me 😊❤️👍
Excellent
Thanks brother, you are doing great job.🙏
Thanks Amit Ji..Sukriya Dilse❤️🙏
Great tricks
Thanks Sandip ji🙏❤️
It's very topic for me.. so thnkyou sir give us a fantastic ...trick 🙏
Thanks Kishan 🙏❤️
it helped in my office works. i am a karnataka state govt employee
Thank you sir
Dear Sir,
All your videos have added value to my life. Thank you so much..!
Request# Pls start VBA videos..
- Mumbai
Thanks Nikhil Ji..Happy Learning dear..God Bless You..Have a wonderful career ahead 🙏❤️
Nice tips
Thanks 🙏❤️
Very good tips and tricks thank you sir
Thanks Kishor..Good Night..tc
SUPER VIDEO SIR
This type video very useful for mis work
Thanks Lokesh Ji .Happy Learning
@@Innozant yeah tricks bht helpful hoge bht jyada thank you so much for this amazing video❤️
Thank you sir
Thanks Ankit ❤️🙏
Thank u sir,, text to columns series mein ctrl+j shortcut jo hai uska implementation briefly explain karenge to bohot meherbani hogi
Ok .kar denge kisi video me aage
@@Innozant thank u sir ,,♥️dil se..
Jabardast sandar sir
Thanks
Very important trick Sir 🙏🙏🙏
Thanks Manoj Ji.. Happy Learning
Very impressive vedio
Thanks dear
Thnk u so much sir u observed my requirement thnx a lot
Thanks Pushkal..🙏❤️
Nice
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
Sr plz guide me about index but reverse full cells in one attempt or provide me that vdo link plz
Sir g tu c great 👌 ho.
Thanks Khalid Ali Sahab🙏❤️Good Night
Gud 9it sir g
Zabardast sir g
🙏❤️❤️
SUPERB
Thanks
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
ms Excel 2007 is not showing pivot table multiple sheets options. Please please guide me. I shall be greatfull to you.
Using alt d p?
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
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 ?
Vbs use kr lein easily ho jayega usse
Ok sir thanks
Nyc great sir
Thanks Durgesh Ji..Happy Learning 🙏❤️
Sir plz provide kre mis job ke liye consultant ka number mai delhi c hu
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
Tnku sir
Hi Sir, number me extra spaces remove karna kaise hoga koi short cut bataiye
Trim use kriye
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
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
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........
Done it with Exact function..You may compare string and then evaluate
🙏
Sir how to replace pushkal
उपाध्याय with pushkal upadhyay or agar koi name hindi me use English me kese replace kar convert kar sakte hai
Hindi font ki jarurt hogi na krti dev
@@Innozant excel me convert ka koi option nhi hai kya
Hello Sir. I want to send a sheet to u. I need one help. Could u please oblige??
@innozantofficial telegram id
@@Innozant i have massaged u there. Plz respond
Frist viewer
Wow.. Thanks dear🙏🙏❤️❤️
Sir please upload in English sir please sir please sir 🙏🙏🙏🙏
Sir aapne Whole number OR Decimal number Tricks Add nahi ki aap ne bola tha add kar denge ☹️
Oho..dhyan nhi rhta itna dear..bht saare query aate hain...❤️🙏
@@Innozant Sir me wait kar raha tha kab se ab next video kar dena please
Like
🙏❤️
🙏👍👍👍
Thanks 🙏❤️
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
Kindly send your query @innozantofficial telegram id.Wil see
Thanks sir very helpful video
Thanks Rahul Ji.God Bless You dear❤️
Very great sir
Thanks dear🙏❤️
Nice
❤️