Formulas in Excel | Excel Tutorials for Beginners

[@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

[@colourNika]

sorry it's MDY

[@NightWalker911]

​@@colourNikaThank you so much!

[@luisnavarro4777]

great thanks

[@abdulraheemsanni9940]

Thank you

[@MadeForD]

tysm!

[@dhairyasheeljagtap9728]

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.

[@AlexTheAnalyst]

Thank you so much for the kind words!

[@AkporHari]

I really agree.

[@tisanabun823]

@@AkporHari honestly sometimes i tell myself that if alex can admit to his mistakes then why can i do the same

[@SanjuSanju-e9m4v]

Sir Can you Leave that courses For Free😢

[@Muyiwa-p3e]

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

[@AbdulWahid-fi7vs]

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.

[@AlexTheAnalyst]

Thank you so much! Much love my friend :)

[@alijokhio2995]

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", ""))

[@esieberhemamoke3817]

Pls is it same for the Len?

[@ayanyemiayannike5063]

Thank you so much, this was so useful

[@munachiemmanuella3695]

I could have been lost without this comment, thank you!

[@onitolu9698]

Thank you so much

[@Super_mic]

Thank you for this.

[@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 .👍😇

[@GM__user]

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.

[@prithikabatra9595]

@@GM__user Need to learn SQL definitely and you can choose between Python/R .

[@UncleSpam1]

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

[@molekyuttv5121]

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! 🙏

[@fpsjohnny3896]

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!

[@Zain-ng1oq]

did you land the job?

[@arunachari2689]

You truly make Excel sound so simple and interesting!!

[@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

[@War-Daddy]

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!

[@AlexTheAnalyst]

Haha thanks! I don't think it's too bad :D

[@hammadalamsiddique3730]

@@AlexTheAnalyst are you a smoker? Cause your voice is damn good 😃

[@ingilisdilidrslrirasefhese7519]

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

[@AlexTheAnalyst]

Super glad to hear it! :D

[@hendmohamed851]

@@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

[@annmariedolan3651]

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

[@AlexTheAnalyst]

So glad to hear it! Thanks for watching!

[@amrkamil85]

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

[@AkporHari]

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

[@umersohail1951]

Thank you, Alex! for providing data and video tutorials. It is making the learning process quick and easy.

[@Thuvu5]

Really helpful Excel tips! Love this series you're putting out.

[@AlexTheAnalyst]

So glad to hear it! Thanks for watching!

[@njabumabu5224]

I see someone is a fan of The Office😂😂. Easy to follow tutorial, love it.

[@AlexTheAnalyst]

Just a little :D

[@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.

[@valentinrack6028]

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

[@arvinjancelis3656]

Alex is teaching me excel and uses the characters of my favorite TV show in his sample data, oh my! Thank you so much!

[@shokoofehheidari5345]

How lucky i am that I found your chanel! Thanks a lot

[@abdullah-khan10]

Thank you Alex, you explain all the formula in a precise way which is easy for newbies to learn.

[@kidus_diaries]

Finding implicit the office puns is so entertaining! Good Job!

[@MLEfan81]

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.

[@OyewoleAdedayo-r1u]

This training really worth paying alot for. Thanks for giving it for free. you are a STAR

[@sumedhbarua8363]

I am getting loved with data by seeing your tutorial. The way you explain is just amazing!

[@yagyarajbasnet3720]

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.❤

[@haerunnissa9978]

Same here, Alex help me so much

[@sj1795]

THANK YOU Alex!! Every video is packed FULL of great info! You are the BEST!

[@temidayooluwatunmibi951]

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.

[@kelechiemeanuru9994]

I always come back to your videos @Alex The Analyst, this is my reference tutorial. very smooth

[@AlisaHof]

Bok choy and I love you. Have been watching your videos for the past year. So helpful. Thank you!

[@AlexTheAnalyst]

I love you more! So glad to hear it :D

[@Oyomikon]

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

[@toothsieroll6390]

Thank you so much for this! Excel has become less intimidating for me thanks to you and your videos! 💛

[@juanjosegaviriaromero1698]

I really love all the references to The Office. Thank you very much for the course.

[@ciscokid4266]

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

[@nathanchamberlain5356]

Fantastic and insightful tutorial, perfect pace and I love the way explain each step and relate it to real life situations.

[@nidaqasem4107]

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

[@naivedyaparamartha5710]

Thank you Alex for explaning it clearly and simply. Cheers to you and your awesomeness!

[@saheel7]

Its a great opportunity to improve my career as a data analyst its amazing.Thank you so much for your wonderful tutorial ❤ I love it.

[@1689JeffChavez]

It's great to be refreshed with excel and realize how important these functions are.

[@violetacorlatan3288]

Thank you so much!! I really enjoy it! I recently discovered you and really appreciate what you are doing. You are great!

[@ElahehEftekharian]

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! :)

[@chrisomoha636]

Thank you Alex. You have done so well.

[@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

[@brendapino4238]

Alex, Thank you for the explanations and the worksheet! you are making excel entertaining :D

[@youkichiba]

@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.

[@sassy_bitch6142]

thanks, its helpful

[@ikemsinachidavid7015]

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

[@1440MAP]

Nailed another one! So many uses! Thanks again.

[@BeingMau]

Thank you Alex! Very concise and clear as always. I'm learning a lot from your videos. Again, thank you!!!!

[@zouhairaldalil2856]

Alex you are the man! Thank you so much for the all the content, learned alot from you and love your videos

[@AlexTheAnalyst]

You're most welcome! Super glad to hear that! :D

[@boky7731]

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

[@AljIsHere128]

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.

[@sanandadev4168]

I am from Bangladesh. The way you have explained, it is really easy to understand.

[@vfmosman16]

i'm so lucky that i got this videos when i was so down and thinking maybe Excel is not for me ,Really thank you so much

[@AlexTheAnalyst]

You're more than welcome! Glad to hear it helped! :D

[@vfmosman16]

@@AlexTheAnalyst yes, sure did by the way i'm from Egypt

[@lorladea]

Thank you Alex. The formulas were well explained. I enjoy the learning

[@deimanterepsaite9014]

It is so great to watch these vidoes and not fall asleet, it is so refreshing to hear normal human language used.. Thank you a lot for these videos

[@lynnogoi6225]

Thank you so much Sir!! I'm really enjoying this bootcamp so far 🌟

[@swathisreekumar2258]

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

[@jasxteo]

Your videos are very good and easy to follow. Thank you so much as I have a non-science background.

[@farazahmed1668]

Thank you for your precious time.

[@abdulloshohraufiy7392]

WE LOVE YOU ALEX UNCLE FROM UZBEKISTAN

[@MR.JAM_687]

I'm literally so happy and every formula you have taught in this video is very clear to understand . Thank you so much sir . Please respond me 😊

[@Elthapa]

Thank you Alex. I love your videos and I'm a fan.

[@miltonfermine1542]

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.

[@jorgdav]

You're an awesome teacher!!

[@polokomonama6526]

Thank you so much for this wonderful video, these will certainly come in handy!

[@himanshubari8723]

Alex woke up and decided to Fire the HR immediately.....🤣, BDW Thankyou so much to make the complex things super simple.

[@BijoyPantu]

Sir, at 30:58 you said that if it is in date format it's not gonna work but i tried and it actually worked both in text and date format. Thanks for these Awesome videos.

[@brand1974]

Great video. Thanks! Looking forward to the other ones.

[@shalinivijayravikumar9713]

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.

[@phaceacid]

Really useful and well explained. Keep the good work Alex!

[@glendareeves2317]

I have taken other courses in person and online and you are so clear and concise in your explanations!

[@philwest2319]

Great video and very helpful. Thank you Alex

[@ceciliabarbon2828]

super useful, great teacher! Thanks!😄

[@Editvila]

This awesome, happy to learn this so easily , thank Alex

[@ericfiumano4694]

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!

[@IhorSoroka]

Thank you for this channel!

[@nauikun]

Thank you sir , you're a legend.

[@polly15751]

Thank you! This has been helpful.

[@justinkings635]

was feeling lazy up until saw familiar names as examples, i love the office!

[@goon5031]

Another great video by Alex.

[@fatimakamali8699]

Jalapeño person here 😁 thanks Alex

[@abdelrahmansayed4564]

This video is incredible!! Thank you so much!

[@luxfoodies2701]

Hi Alex. This is really helpful to say the least. Thank you.

[@marp760]

I really like the way you teach Excel . really fruitful

[@johnnyscars]

So clear and concise! Thank you for all this amazing content

[@oluwatobiadeoje1763]

Thank you Alex for this great explanation

[@Lakshmepw]

Thank u so much Alex, just thanku so much, i learnt a lot and infact i applied the formula (SUMIFS) to my "Expenses tracking" excel sheet for different categories, right away and felt overjoyed at the ease and simplicity !!!!!!!!

[@syaoransakura8839]

I am in for this series. Thank you for your hard work, sir

[@rosaliahmuhoho7469]

Thank You Alex. Great teacher

[@DustInTheAir]

Hi Alex thanks for your videos! I like when you writing the IFS expression: if they are HRs, fire immediately 🤣🤣🤣🤣

[@youvegotmail9385]

The tables have turned!

[@julienmonso-lq1qr]

I like yours videos so much ... Always a bucket of knowledge (hopefully this Can be understood means they are great) , but : you criticized excel as a non agile software just after which might be but only depending on how it's team used... (And to me, criticize excel might be with a lot of suffer pain issue reason 😂). I'm fond of it... Please continue xlsx tutorials... Anyway,, on 1 word or in 1000... You're great and Always interesting. Keep posting videos to help other than you learn (please be kind with excel...)

[@AhmedRagab-o6c]

U R the best Alex THX

[@Hildreim]

*Like before even to watch because Alex is the best*

[@AlexTheAnalyst]

:D

[@pavanreddy9543]

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!!

[@anupamavaradarajan657]

The office fans would be more interested to work and learn from this tutorial :D

[@marialaura9493]

Thank you for this!

[@yayati2321]

oh my god I just noticed that the names used in the video are all the characters from THE OFFICE lol kudos for it so awesome...

[@ky5758]

This is sooooo useful, I wished I watched it earlier

[@chalotheekhai8481]

Thank You for this wonderful video