Formulas in Excel | Excel Tutorials for Beginners
HTML-код
- Опубликовано: 1 июл 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!
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😢
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.
It's amazing how Alex simplifies complex concepts and makes them look super easy compared to some other RUclips videos on the same. You're doing a great job helping people out there, Alex.
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 :)
YOURE A HIDDEN GEM ALEX THANK YOU FOR THESE ACTUALLY WELL THOUGHT OUT AND PUT TOGETHER VIDEOS
Thank you, Alex, for this really clear explanation. Watching the whole series, and it is really amazing.
You truly make Excel sound so simple and interesting!!
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! 🙏
Thank you, Alex! for providing data and video tutorials. It is making the learning process quick and easy.
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 explaning it clearly and simply. Cheers to you and your awesomeness!
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! 💛
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
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 Alex! Very concise and clear as always. I'm learning a lot from your videos. Again, thank you!!!!
Really helpful Excel tips! Love this series you're putting out.
So glad to hear it! Thanks for watching!
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!
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!! Every video is packed FULL of great info! You are the BEST!
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
Fantastic and insightful tutorial, perfect pace and I love the way explain each step and relate it to real life situations.
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.
I have taken other courses in person and online and you are so clear and concise in your explanations!
Thank you so much!! I really enjoy it! I recently discovered you and really appreciate what you are doing. You are great!
Very good video! A compact piece of knowledge about the 80% of functions you will use during analysis in Excel.
Really useful and well explained. Keep the good work Alex!
Thank you Alex. The formulas were well explained. I enjoy the learning
Alex, Thank you for the explanations and the worksheet! you are making excel entertaining :D
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?
So clear and concise! Thank you for all this amazing content
Thank you Alex. I love your videos and I'm a fan.
Great video and very helpful. Thank you Alex
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.
Thank you so much Sir!! I'm really enjoying this bootcamp so far 🌟
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 .
It's great to be refreshed with excel and realize how important these functions are.
I am getting loved with data by seeing your tutorial. The way you explain is just amazing!
Thank you so much for this wonderful video, these will certainly come in handy!
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.
I am in for this series. Thank you for your hard work, sir
Great video. Thanks! Looking forward to the other ones.
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
Thank You Alex. Great teacher
You're an awesome teacher!!
Thank you! This has been helpful.
WOW! Over 30 is old. I'm 38 now. :) Thanks a lot Alex for the great effort. I love your videos.
Another great video by Alex.
super useful, great teacher! Thanks!😄
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.
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
Thank you for your precious time.
This video is incredible!! Thank you so much!
I really like the way you teach Excel . really fruitful
This awesome, happy to learn this so easily , thank Alex
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
Nice, thanks for the explanations!
Finding implicit the office puns is so entertaining! Good Job!
Hi Alex. This is really helpful to say the least. Thank you.
Thank you for this channel!
Thank you sooo much!! This is so helpful!
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.
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
Your videos are very good and easy to follow. Thank you so much as I have a non-science background.
so thankful for this , thank you so much
learnt a couple of new things. Thanks for sharing
Thank you so much, Alex.
Thank you sir , you're a legend.
Thank You for this wonderful video
Thank you Mr. 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 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
I am from Bangladesh. The way you have explained, it is really easy to understand.
U R the best Alex THX
Thank you for this!
Good work Alex. Thank you for providing the link to the data sets. Some do not provide us with Data sets.
Thank You Alex!
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!!
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! :)
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.
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
Thanks Alex!
Sir thanks a lot for your videos it's help us a lot
THANK YOU ALEX
WE LOVE YOU ALEX UNCLE FROM UZBEKISTAN
Thanks Alex 👏❤️😇
Thank you A LOT!
Thanks Alex
Thank you once again 🙂
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.
Thank You Alex
Thank you very much!
You are the best 🤝
@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
Great work sir 🫡🫡
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