Formulas in Excel | Excel Tutorials for Beginners

Excel is one of the most used skills in the data world. In this series we will be walking through all of the most important topics that Data Analysts need to know in order to be proficient in Excel.

Excel Formula Template:

Udemy Excel Courses:

Outline:
0:00 Intro
2:25 Max/Min
4:33 IF/IFS
8:46 Len
10:30 Left/Right
13:29 Date to Text
17:02 Trim
18:27 Concatenate
20:45 Substitute
24:42 Sum/SumIF/SumIFS
28:02 Count/CountIF/CountIFS
30:36 Days/NetworkDays

____________________________________________

SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________

RESOURCES:

Coursera Courses:

Udemy Courses:

*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________

SUPPORT MY CHANNEL - PATREON/MERCH

____________________________________________

Websites:
Instagram: @Alex_The_Analyst
____________________________________________

*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*

[colourNika]

Also for those who has #value error in Days function (it's because your system date format doesn't match the given one). Select all dates (h2:h10) -> go to Data tab -> choose Text to Columns from there -> Delimited, Next->, Next ->, step 3 of 3: column date format and chose DMY -> finish

[dhairyasheeljagtap]

Your calm composure and humility makes me a compulsive viewer of your content. Please keep up the good work. I am learning a lot from you.

[alijokhio]

Note that the IFS function is available in Excel 2019 and later versions. If you're using an older version of Excel, you can achieve a similar result using nested IF functions:

=IF(F2:F10 = "Salesman", "Sales", IF(F2:F10 = "HR", "Fire Immediately", ""))

[AbdulWahid-fivs]

Waited almost 5 minutes to comment on your video because i got very slow internet. But i must say you are a genius sir.
Plz keep doing your job i am learning from free resources and you are number 1 for me.

[fpzqlwb]

It's amazing how Alex simplifies complex concepts and makes them look super easy compared to some other YouTube videos on the same. You're doing a great job helping people out there, Alex.

[tanji_shk]

Hey Alex,
Following your bootcamp to be a data analyst .
From bcom to aspiring data analyst.
Your videos are great source .
Thank you so much .😊
Keep up the good work .
Many out there who are from non tech and want to switch there career into data analytics.
Your hardwork, videos are only source to learn for free for aspirants like me .👍😇

[fpsjohnny]

Just graduated with my B.S. in comsci. Got interviews coming up next week for data analyst positions. Thank your for your help Alex, have a good holiday!

[molekyuttv]

Hi Alex,

Thanks for creating a boot camp video. I'm a case manager in an insurance company and planning to apply for an analyst role either here in my current company or in a financial/banking institution.

You're a great trainer, making the discussion simple, focusing on actual data for visualization. Makes it easier for people like me that are not tech savvy. ❤ God bless you! 🙏

[War-Daddy]

Thanks Alex for the useful content. Also, in a non-weird way, you have a great voice for You have the kind of voice that companies would pay to use in their advertisements and products!

[UncleSpam]

YOURE A HIDDEN GEM ALEX THANK YOU FOR THESE ACTUALLY WELL THOUGHT OUT AND PUT TOGETHER VIDEOS

[arunachari]

You truly make Excel sound so simple and interesting!!

[ingilisdilidrslrirasefhese]

a couple months ago, I began to learn power bi and then my friends recommended me your excel videos as well .I am really happy to meet you here .You are explaining everything in an easy and good way .Thanks a lot, I will continue to watch your videos

[Dxgreen]

You have been a great mentor Alex. I already know a lot of Excel but I am still going to watch your videos for the support! Keep it up my guy

[vikieosas]

Thank you Alex this was quite interesting you make everything easy to assimilate as a beginner am super excited for the journey ahead as a data analyst

[amrkamil]

WOW! Over 30 is old. I'm 38 now. :) Thanks a lot Alex for the great effort. I love your videos.

[annmariedolan]

Thank you for putting out great content every week, I've learned so much from this channel!

[valentinrack]

Very good video! A compact piece of knowledge about the 80% of functions you will use during analysis in Excel.

[AkporHari]

Thank you, Alex, for this really clear explanation. Watching the whole series, and it is really amazing.

[boky]

Can you make a video on the best way to learn SQL and which SQL to learn? I am kinda new to all of this

[Mjagcayab]

I loved it! I Appreciate you Alex. This is a big help for me starting my career to become a excel expert in future jobs.