Formulas in Excel | Excel Tutorials for Beginners
ฝัง
- เผยแพร่เมื่อ 9 มิ.ย. 2024
- Take my Full Excel for Data Analytics Course! www.analystbuilder.com/course...
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:
github.com/AlexTheAnalyst/Exc...
Udemy Excel Courses:
Pivot Tables in Excel: bit.ly/3peELgG
Visualizations and Charts in Excel: bit.ly/30MU9HT
All Excel Essentials: bit.ly/3Fdk6iG
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:
Google Data Analyst Certification: coursera.pxf.io/5bBd62
Data Analysis with Python - coursera.pxf.io/BXY3Wy
IBM Data Analysis Specialization - coursera.pxf.io/AoYOdR
Tableau Data Visualization - coursera.pxf.io/MXYqaN
Udemy Courses:
Python for Data Analysis and Visualization- bit.ly/3hhX4LX
Statistics for Data Science - bit.ly/37jqDbq
SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
Tableau A-Z - bit.ly/385lYvN
Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!
____________________________________________
SUPPORT MY CHANNEL - PATREON/MERCH
Patreon Page - / alextheanalyst
Alex The Analyst Shop - teespring.com/stores/alex-the...
____________________________________________
Websites:
GitHub: github.com/AlexTheAnalyst
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
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
sorry it's MDY
@@colourNikaThank you so much!
great thanks
Thank you
tysm!
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", ""))
Pls is it same for the Len?
Thank you so much, this was so useful
I could have been lost without this comment, thank you!
Thank you so much
Thank you for this.
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.
Thank you so much for the kind words!
I really agree.
@@AkporHari honestly sometimes i tell myself that if alex can admit to his mistakes then why can i do the same
Sir Can you Leave that courses For Free😢
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.
Thank you so much! Much love my friend :)
It's amazing how Alex simplifies complex concepts and makes them look super easy compared to some other TH-cam videos on the same. You're doing a great job helping people out there, Alex.
Thank you, Alex, for this really clear explanation. Watching the whole series, and it is really amazing.
YOURE A HIDDEN GEM ALEX THANK YOU FOR THESE ACTUALLY WELL THOUGHT OUT AND PUT TOGETHER VIDEOS
You truly make Excel sound so simple and interesting!!
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
Thank you, Alex! for providing data and video tutorials. It is making the learning process quick and easy.
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! 🙏
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 .👍😇
Hello! I definitely agree, Alex's videos have been super helpful and make everything seem simple & not as intimidating! Can I ask what the structure you have been following in the bootcamp? I've began with Excel but am not sure what to go with next (Sql vs. R). Any additional tips would be welcomed as well! Thanks.
@@GM__user Need to learn SQL definitely and you can choose between Python/R .
Thank you Alex for explaning it clearly and simply. Cheers to you and your awesomeness!
Lots of useful content with great solid examples is especially why I love following this channel. I get to practice this and learn it. Thank you for this and please keep making more excel videos thanks
Thanks Alex for the useful content. Also, in a non-weird way, you have a great voice for narrating/hosting/moderating/teaching. You have the kind of voice that companies would pay to use in their advertisements and products!
Haha thanks! I don't think it's too bad :D
@@AlexTheAnalyst are you a smoker? Cause your voice is damn good 😃
Thank you Alex! Very concise and clear as always. I'm learning a lot from your videos. Again, thank you!!!!
Thank you Alex, you explain all the formula in a precise way which is easy for newbies to learn.
Thank you so much for this! Excel has become less intimidating for me thanks to you and your videos! 💛
I’m happy to start this journey of data analyst, your explanation here is very simple and easy to understand, I hope to learn from you more Alex.
Thank you for putting out great content every week, I've learned so much from this channel!
So glad to hear it! Thanks for watching!
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!
did you land the job?
THANK YOU Alex!! Every video is packed FULL of great info! You are the BEST!
Really helpful Excel tips! Love this series you're putting out.
So glad to hear it! Thanks for watching!
Fantastic and insightful tutorial, perfect pace and I love the way explain each step and relate it to real life situations.
Thank you so much!! I really enjoy it! I recently discovered you and really appreciate what you are doing. You are great!
I have taken other courses in person and online and you are so clear and concise in your explanations!
Really useful and well explained. Keep the good work Alex!
So clear and concise! Thank you for all this amazing content
Thank you Alex. The formulas were well explained. I enjoy the learning
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.
WE LOVE YOU ALEX UNCLE FROM UZBEKISTAN
I learned some of these randomly and need to know basis. But this literally would have saved me so much time if learned in this order and format from the beginning. Thanks so much for your content
WOW! Over 30 is old. I'm 38 now. :) Thanks a lot Alex for the great effort. I love your videos.
Alex, Thank you for the explanations and the worksheet! you are making excel entertaining :D
Thank you Alex. I love your videos and I'm a fan.
I always come back to your videos @Alex The Analyst, this is my reference tutorial. very smooth
Thank you Alex. You have done so well.
Your videos are very good and easy to follow. Thank you so much as I have a non-science background.
Great video and very helpful. Thank you Alex
Thank you Alex for this great explanation
How lucky i am that I found your chanel! Thanks a lot
Nailed another one! So many uses! Thanks again.
It's great to be refreshed with excel and realize how important these functions are.
I am in for this series. Thank you for your hard work, sir
Thank you so much for this wonderful video, these will certainly come in handy!
Alex you are the man! Thank you so much for the all the content, learned alot from you and love your videos
You're most welcome! Super glad to hear that! :D
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
Super glad to hear it! :D
@@AlexTheAnalyst Thank you !Really Appreciate your content! I really want you to Add a Practicing Projects in the description box with every tutorial please i want projects based on every tutorial of you not just any projects
Very good video! A compact piece of knowledge about the 80% of functions you will use during analysis in Excel.
I really like the way you teach Excel . really fruitful
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
So far I am doing a simple basic book called SQL In Easy Steps for overall general SQL understanding. Before tailoring SQL specifically for Data Analysis. I really like the book and it's simplistic manner.
Great video. Thanks! Looking forward to the other ones.
You're an awesome teacher!!
This awesome, happy to learn this so easily , thank Alex
Thank you! This has been helpful.
Hi Alex. This is really helpful to say the least. Thank you.
This video is incredible!! Thank you so much!
Finding implicit the office puns is so entertaining! Good Job!
Thank you for your precious time.
Another great video by Alex.
super useful, great teacher! Thanks!😄
learnt a couple of new things. Thanks for sharing
Hi Alex,
Thanks for this piece. I and my wife enjoy your teaching on this subject.
I'd like to add that TRIM removes excess spaces between words.
thanks
Good work Alex. Thank you for providing the link to the data sets. Some do not provide us with Data sets.
Thank you sooo much!! This is so helpful!
so thankful for this , thank you so much
Nice, thanks for the explanations!
I did this in Finnish Excel and had to figure out the Function names in Finnish and our date format is different so also countin the days did not work right until I corrected them to our format. Still did great and now I know both ways to do them. So Thank you so much from Finland, I really enjoy your way of teaching.
Hey, I wanted to give you a shoutout for being a tremendous help!
I loved how you added the names of The Office characters - that was really cool of you! :)
Thank you Mr. Alex
I am from Bangladesh. The way you have explained, it is really easy to understand.
Thank you so much, Alex.
Thank you for this channel!
Bok choy and I love you. Have been watching your videos for the past year. So helpful. Thank you!
I love you more! So glad to hear it :D
Thanks for this tutorial. I don't know how many times I've tried, but I could never master excel functions. I've been learning since the late 90s. Great video bro.
Thank You for this wonderful video
Thank you sir , you're a legend.
Sir thanks a lot for your videos it's help us a lot
I was just starting to learn my data analysis and i found your channel. Your channel is a Gold mine for the biggners.
Thank you for creating such quality and informative videos.❤
Same here, Alex help me so much
Hi Alex, using the function concatenate we created email IDs. But, before that, we may need to make all the letters small as email IDs can not have capital letters. We can also include another function here for the same, ig. Thank You!!
Thank You Alex!
U R the best Alex THX
Thank you for this!
THANK YOU ALEX
So much value, Alex. Thanks a lot.
I've worked with Excel for some analysis and I confirm that the mentioned functions are pretty well required during the cleaning and analysis processes.
Thanks!
I see someone is a fan of The Office😂😂. Easy to follow tutorial, love it.
Just a little :D
Thanks Alex!
Thanks Alex
Dear Alex All of your video clips are fantastic. I'm searching for a job as a data analyst and a change in my career. Could you please share a list of steps for creating a portfolio project? As a beginner, if you upload it, it will be really beneficial to me. I appreciate it.
Thanks Alex 👏❤️😇
Thank you very much!
I couldn't help but smile when I noticed all the names of the characters in 'The Office' being used in the worksheet, Toby was fired and Michael was given a bonus. Good one :D
Thank you A LOT!
Thank you once again 🙂
Thank You Alex
i dont why IF formula in my version is different , but this is how it worked with me
=IF($D$2:$D$10 > 30; "old";"young")
by adding $ signs between the selected cells
Thanks for this tutorial @Alex.When i tried using the "right " excel formula for date.It gave me a total different figure.Help on this
Thank you for video! How to use data model feature video would be great!!
Jalapeño person here 😁 thanks Alex
@16:44 For extracting the year from Date Format Dates, I believe you can just use the =YEAR() function to extract the year. This function only works if the dates are already in the date format though.
thanks, its helpful
Yea cause I tried the way Alex did his and it’s giving me different values. I use Excel 2016, I don’t know if that’s the problem
Thanks, Alex. Simple and clear explanation. Are there any exercises available online to practice actual tasks in excel?
I followed along with the video. There is a downloadable file he uses. Did U do that?