Formulas in Excel | Excel Tutorials for Beginners

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

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

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

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

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

[@UncleSpam1]

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

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

[@amrkamil85]

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

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

[@Ayushtrivedi-c3v]

I am a python developer and working on excel is new to me, I was worried about learning everything on excel but after watching this playlist it really helps me to learn quickly and easily, thank you so much, Alex.

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

[@njabumabu5224]

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

[@AlexTheAnalyst]

Just a little :D

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

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

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

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

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

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

[@kidus_diaries]

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

[@F1shy1937]

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

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

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

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

[@himanshubari8723]

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

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

[@OyewoleAdedayo-r1u]

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

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

[@abdullah-khan10]

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

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

[@sumedhbarua8363]

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

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

[@EmilianDobre]

love the references to THE OFfice

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

[@Thuvu5]

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

[@AlexTheAnalyst]

So glad to hear it! Thanks for watching!

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

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

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

[@valentinrack6028]

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

[@kelechiemeanuru9994]

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

[@1689JeffChavez]

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

[@sanandadev4168]

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

[@sj1795]

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

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

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

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

[@juanjosegaviriaromero1698]

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

[@nathanchamberlain5356]

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

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

[@chrisomoha636]

Thank you Alex. You have done so well.

[@1440MAP]

Nailed another one! So many uses! Thanks again.

[@toothsieroll6390]

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

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

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

[@justinkings635]

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

[@farazahmed1668]

Thank you for your precious time.

[@Hildreim]

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

[@AlexTheAnalyst]

:D

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

[@violetacorlatan3288]

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

[@jasxteo]

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

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

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

[@brendapino4238]

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

[@lynnogoi6225]

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

[@jorgdav]

You're an awesome teacher!!

[@naivedyaparamartha5710]

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

[@ceciliabarbon2828]

super useful, great teacher! Thanks!😄

[@abdulloshohraufiy7392]

WE LOVE YOU ALEX UNCLE FROM UZBEKISTAN

[@anupamavaradarajan657]

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

[@BeingMau]

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

[@fatimakamali8699]

Jalapeño person here 😁 thanks Alex

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

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

[@nauikun]

Thank you sir , you're a legend.

[@lorladea]

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

[@IhorSoroka]

Thank you for this channel!

[@dbmib_]

for anyone wondering, to change the #N/A @8:10 add an IFERROR formula to change that to blank or whatever you choose. i'm practicing on my first set of data and was stressing on that for an hour. Luckily, i googled it and it took me less that 5 minutes to fix. LOL!

[@atem583]

In addition, you can also use IFNA to catch only #N/A errors. My function for that section is: =IFNA(IFS(F2:F10="Salesman","Sales",F2:F10="HR","Fire Immediately",F2:F10="Regional Manager","Give Christmas Bonus"),"")

[@cephtheobserver]

Or just add TRUE, "Misc" at the end of that formula.

[@glendareeves2317]

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

[@Editvila]

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

[@AhmedRagab-o6c]

U R the best Alex THX

[@polokomonama6526]

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

[@Dahamey]

I'm starting to believe my man really hates HR lmao, between that 0.0001% raise in the SQL exercice and this 7:44 🤣

[@ahmadjawedomid8592]

Thanks for all the efforts 🤙🤙

[@Elthapa]

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

[@abdelrahmansayed4564]

This video is incredible!! Thank you so much!

[@muhammadabdihakim3472]

For people getting #value! with DAYS and NETWORKDAYS, change the "StartDate" and "EndDate" into date format. Here is how you can do: 1. Highlight the "StartDate" and "EndDate" columns. (One column at a time) 2. Go to Data > Text to Columns > Delimited > Next > Select "Date" format matching your data (e.g MDY) > Finish. Then, you are good to go!

[@kuburatozavize8400]

I have tried this but whenever I try doing the right function it kept giving values that aren't related to the year as expected. I need help please

[@brand1974]

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

[@polly15751]

Thank you! This has been helpful.

[@philwest2319]

Great video and very helpful. Thank you Alex

[@phaceacid]

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

[@marp760]

I really like the way you teach Excel . really fruitful

[@rosaliahmuhoho7469]

Thank You Alex. Great teacher

[@baba7415963]

halfway through the video and i feel like im ready to be a pro data analyst! hahaha

[@goon5031]

Another great video by Alex.

[@Zehfidence]

Thank you once again 🙂

[@SyedMuhammadShaheryar-f4v]

its really nice bootcamp every video amazing wow !!