Beginner's Excel Tutorial - Data Science/Analysis and Beyond

[@ShashankData]

Use my link bit.ly/ShashankKalanithi2DCFeb22 and check out the first chapter of any DataCamp course for FREE to unlock new career opportunities and become data fluent today!

[@NamPham15019]

Please never stop doing tutorial videos like this man. Thank yo so much for bringing the knowledge to the world

[@mohitseventeen]

This is one of the best course on Excel. You are teaching what is needed the most based on your experience which is in my opinion the best thing about the course. I usually don't complete such long videos in one sitting but was able to do it for this course. Thanks for such an amazing content. Looking forward for new courses, till then will complete your previous courses.

[@ShashankData]

Thank you so much Mohit! Yes that's exactly the purpose of these videos, they're not supposed to be comprehensive but a guide on what you need to get started

[@hhbbhvvbjhbbyjj]

your awsome for providing this !!!! one of the best data analyst content youtuber!

[@FokezGamez]

Starting learning Excel and some VBA gives a very good understanding of what is going on, when you try to learn and use Python for data analysis.

[@raedokal]

Yes, we can use Excel in the opposite direction in the Arabic language in the Middle East, but we usually use it in the English language in the natural direction, even in the smallest companies in the Middle East

[@ohmsix]

I was *just* going through your content today, specifically the data analytics roadmap and was surprised to see this upload! you're gonna have to update the roadmap seeing as you do have a resource for excel now :) can't wait to dive into this and all your other videos, keep it up they've been very insightful!

[@pallaviiii847]

I was too going through road map and found this now.🙌

[@ShashankData]

Good callout! I just linked this in the roadmap video and will update the actual roadmap shortly!

[@abenezertecha3550]

The differences between currency(CF) and accounting format(AF) are: the place where the currency symbol appears[CF-next to the first digit in the cell.] the way negative number appears[AF-Negative numbers appear in parentheses]

[@sincerelysilvia]

no one does it like you. gonna power this through thank you!!!

[@ShashankData]

Thank you so much Silvia! Best of luck to you!

[@marvellouseyube6376]

Finally!!!😁 Thanks Sir Shashank for everything thus far...🤗

[@welcometomathy]

Been an Analyst fpr the part 5 years and Excel was my main focus and till today still is Excel. Work a lot with automation and developing VBA Appplications linked to Access file databases on a local server with few offline versions saw advancements on Salary 2 times from 9K to 11K and then 13K, you don't make much money in ... Portugal. Today I see that my tasks are slowing changing into the Power BI platform as it get implemented on companies from automation to lowcode with Power Apps and Power Automate. Something I see is that the companies I tend to apply evolve very slowly in tech and take years to progress, unless you are on a start up with bunch of money its seen like luxury having a pro/service account in Power Platform or just Power BI)

[@vinirodzzz]

hey, do you live in Portugal? Can we connect? I'm studying to be a Data Analyst.

[@pankajsen2741]

1:08:13 .Bro I am watching this video on 08-22-2022 you are on 100k. That calculation was perfect.

[@KonradTamas]

Congrats for the 100k !! You defo earned it. Thanks for your videos.

[@Pelchulisadinosaur]

Thank you so much. Prior to this I was self-taught in Excel. Now, I better understand how things worked. I'm a science major trying to shift more towards data science and this definitely helped me kickstart towards this path. I'll be checking your other vids in the future. I like how you made things concise.

[@Loki_Dokie]

Thanks so much for this free information, I was self teaching web development but realized my love is data/information. Starting on python and SQL currently

[@sahebsinghh]

Thank you Shashnak . Just what I needed!

[@ShashankData]

I’m happy that this came at the right time for u

[@Mohammad-tw7cq]

Awesome. I was waiting for this video ever since you announced it.

[@ShashankData]

Thank you so much for the excitement!!

[@faazylicious8403]

Thanks for this vid man. I learned so much more from watching this video than from what i learned from the whole 2nd module of my data analytics course. Keep up the great work!!!

[@AMAN12345-x]

Google data analytics course?

[@splendidninja1378]

Approximate match for VLOOKUP can be very effective when converting numbers into two groups or some categories. An example of this would be if your lookup value was a numerical grade, you could create an associated lookup table that assigns the appropriate letter grade. The caveat with this is that the values must be in numerically-ascending order on the lookup table.

[@allanlazar9094]

Thankyou Shashank for this!!!

[@ShashankData]

Thank you so much for the excitement!!!

[@MrPushupp]

congrats on the 100k! you def earned it, seems like you nailed the growth expectancy

[@romalmahana6676]

Very Insightful Shashank. Thanks for the insights!!

[@jspetrolina]

Thank you very much! *-*

[@IlyaKhr]

Hey, Shashank, thanks a lot for the video! I do believe, it's a good idea to add this tutorial to "Data Analyst Tutorials" playlist -- would be easier for new viewers to find it.

[@kldn170]

Hey, please do an advanced SQL playlist ? thanks really appreciate your channel.

[@KulturanCov]

Uhhhh very nice! Compact Excel tutorial for Data Analysts and Scientist. Just what I was looking for!

[@nauikun]

Thanks a lot sir, you deserve an award for creating this one, really helpful, I've learned a lot. the currency format shows zero "0" while accounting shows dash "-" when the value of the cell is zero

[@AkashPal-oc9cb]

Thanks a lot u don’t even know how much ur helping others by providing this resources 👏👏

[@ShashankData]

Thak you so much for the kind words Akash!!

[@chasehowards5472]

Thanks a lot I like how you explain what’s actually needed. A lot of vids I watch they take months to learn everything that doesn’t seem necessary in the real world or every job. I had to slow down speed you talk fast, but other KZbinrs I have to speed up because its either boring or they talk way too much 😆. I’m trying to get out of medical like some of my friends did!!!

[@KC-hk2ub]

This has been really great. Thanks for your efforts. it's particularly watchable because it's concise and you've covered some things that will be really useful for me in my next role.

[@fokyewtoob8835]

Best data analyst on KZbin 🔥

[@ElroyDesmond]

Awesome content as always, Shashank. Goal Seek is a new feature I've discovered thanks to this video and I'm curious as to how I can apply it to my work.

[@josephblah]

Great video! Found quite a few tips I could use to simplify my logbook file. Did everything with if / else which was a royal pain. Very much appreciated!

[@markslima1557]

Fantastic video clearing up these concepts for me thank you, and subscribed.

[@naoufalanbari201]

Great materials!

[@anawerena5396]

I appreciate your talking speed

[@alvarochinchayan6035]

Thank you so much Shashank. Really awesome work!

[@francisokoye5088]

Great Video Shashank! I couldn't stop watching till the end of the video😃😃..... Another great stuff you could have added is "Flash Fill" it is like performing magic in excel.. Why i always advocate for people to start with Excel is that it is easier to learn and people can easily see what is happening ...unlike a programming language... When they are moving to SQL or Python or R... They can learn it from an excel perspective... At least they can remember in Excel they have seen what it was doing and then can easily relate it in in SQL/Python/R....

[@ShashankData]

Francis great to see you in the comment section! Thank you so much for your help during the livestreams! Yes! Flash Fill is amazing!. I like the methodology you outlined as well

[@xXHelsingGamingXx]

Now thats an amazing accent! I am going to watch all your vidoes!!

[@brunopires6517]

Thank you for providing so much value!

[@christianjoybertillo3624]

This is actually very helpful! Thank you for your tutorial, you made it look so easy!

[@xXHelsingGamingXx]

I love your accent! Will be strictly following your updates yaar!

[@rainbowsunshinekitty3953]

Thank you 😊

[@knw-seeker6836]

Thanks for the high quality content

[@shubhamekbote1628]

Very interesting and informative... thank you very much for doing this.. Very practical work

[@barthpa]

Thanks for the course, really enjoyed every single minute.

[@ShashankData]

Thank you so much Bartho! Sometimes I feel like I might be boring people so it's great to know people like you enjoyed the course

[@blowcooknotcoke]

🔥 🔥🔥 can’t wait to dig in

[@emmanueldanso8482]

Hello Shashank, please I need an insight about index and index+match+match When you you I call index and when do I call index+match+match Thank you 😊😊

[@vorfreu]

What about LibreOffice Calc? Does it do well compare to Microsoft Excel

[@markleak8292]

You made the 100k subs!

[@datascientist6233]

Thanks Bro.,

[@ShashankData]

Thank YOU!

[@postbarone]

When you removed duplicates in column 1 and 2 at 1:00:34, only row 21 was removed, but in row 12 there is another duplicate? How does this function work? Does it look at duplicates in column 1 compared to column 2, or does it just evaluate the whole range? Thanks for this video, its really helpful!!

[@leskarty]

yeah noticed that too

[@Gate_Tricks]

Hi thank you I was waiting for this again lots of thank

[@jakehickman_]

This was awesome, thank you so much. You'll smash your sub goal mate

[@ShashankData]

Thanks so much Jake! Yes we got this

[@hysni]

Hey Shashank did you check video when uploaded ? Its Damn words to small !!!! zoom a bit

[@halowaffles]

49:24 Just a thought I had on this specific piece using the TRIM function. Is there any perceivable downside to selecting the *entire* datasheet and using TRIM? Or will there perhaps be complications for doing such on a large data set

[@christiancoronado]

For all accountants and financial analyst out there learn excel and you'll be good

[@ShashankData]

Make sure you can use it without touching the mouse to be a real boss 😎

[@christiancoronado]

@@ShashankData you funny 😁 I don't use the mouse or the macro recorder. Good video

[@AG-hm1sp]

If I don’t have “data” in the menu and option to download cvs file 😢?..

[@pinklilyblossom]

Re section: VLOOKUPS - Fixing the array table with the F4 key did nothing on my laptop. I was not able to do that.

[@simonsacquah4563]

Really insightful and educational but could you please slow down a bit to make following easier

[@prashantrawat6738]

I am looking some project or exercise to improve my excel skill. Where can I find them?

[@etchay]

I'm from Pakistan, one of the places where we write from right to left. We just use the English numbers when doing stuff like this. I have lived a good number of years in Saudia as well, and although I do not have professional experience there, I do believe it is in English there as well.

[@etchay]

I saw this comment on your recent Livestream, and realized that I might have said this confusingly and you misinterpreted it. Here in Pakistan, and most probably Saudia too, we just use Excel like you guys do, with normal English numbers going left to right. And yes, Urdu is written right to left.

[@audiosmarts675]

42:00 IF, AND, OR 55:00 Data Validators

[@OtaPlayers]

very good

[@MartijnMols]

whats the difference between a data analyst and a data scientist?

[@TheForresterOD]

Hi Shashank, how do I get into your All About The Data discord server?

[@obialex3448]

Can SQL replace excel in data analysis? Like can one be a data analyst without knowledge of excel

[@IlyaKhr]

Well, it depends a lot on a specific company. For instance, where I worked as a data analyst, I did not need excel nearly at all. The only purpose I used it for - was sharing resulting data in the form of excel tables. Talking about replacement of excel by SQL -- I do believe that solely SQL cannot replace it, since you cannot visualize data in SQL, you can perform analysis mostly only in the form of strict tabular data (unlike in excel). However, you can quite easily replace excel with SQL + Python (or some other programming language). But once again, depends heavily on a specific company "data culture".

[@karthikpm9669]

50:08

[@TrendzTokx]

from Bahrain, next to Saudi Arabia. And No, Excel isn't mirrored here lol. its the default way, plus everyone that uses excel here is usually fluent in multiple languages and can enter all the data in English.

[@BakrAli10]

That’s because most people install the default English Office Suite. But if you install the Arabic version (which I have seen few people do), then everything, including excel sheets, will be from right to left. Edit: Oh, and you don’t actually need to install the Arabic version; under Page Layout tab, there’s a “Sheet Right-to-Left” option. Plus, you can change the default to rtl in settings.

[@operator8194]

A+

[@arun.kumar.s]

Your expressions after each successful chapter was like meme kid "hell yeah"

[@brianmwiinga8166]

Add a beat this presentation will be a hip hop song. Dudes is literally rapping

[@kei4289]

Good info, however your pace is a little too fast for me.

[@eduduazzolin]

1:06:09 I couldn't find your tiktok

[@peanut6633]

great fukin video son

[@walusimbirichard5993]

Good tutorial but you talk too fast

[@jayo3074]

This isn't data science

[@ShashankData]

Science data isn’t this

[@mrCetus]

Thanks a lot u don’t even know how much ur helping others by providing this resources 👏👏