Formulas in Excel | Excel Tutorials for Beginners 

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

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.

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

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

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!

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

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 this really clear explanation. Watching the whole series, and it is really amazing.

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

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

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

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

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.

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

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

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

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

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

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

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

WE LOVE YOU ALEX UNCLE FROM UZBEKISTAN

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

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

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

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

🤣 This guy really hates HR . I wonder why

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.

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

Jalapeño person here 😁 thanks 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!

And how smart you are regarding choosing the subjects and materials

Smooth explanation great work dear Alex 1- What are the most important formula I need to master to land my 1st job as data analysis. 2- Are there any chat websites where data analyst can chat and exchange knowledges

does no ne else find it really cool that he's using 'the office' as reference😂😂

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

SIR, using days and networkdays im not getting some values bcz i think some of those like "8/30/2017" in wrong format!, how to fix this? can someone help?

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

Very nice video. Until we got to concatenate I hadn't realised we were using characters in the Office series 😅😅😅

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

so at 20:30 to apply the same formula for all the cells, press and pull the small dark box for the applied formula cell till the extent where you want to apply the same function

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

Great video and very helpful. Thank you Alex

Thank you sir , you're a legend.

Thanks, Alex. Simple and clear explanation. Are there any exercises available online to practice actual tasks in excel?

I don't know when it started but as of 'today' the CONCATENATE function is already deprecated, and MS suggest using CONCAT (visual representation uses an orange triangle with the exclamation mark inside soon after when you start writing the function name.

What about xlook up and vlook up and hlook up please make next video upon these formulas .

Thank you for this channel!

Why is it we are getting a value error in few cells of days - network days columns? How to solve it?

Thanks and great video Alex. I'm still new to the Excel and I tried to follow exactly like in the video but when I type in the formula 'IF', the result only appear on 1 cell and not like how Alex did at 5:44 where they magically appear for the rest of the column. What I did to get the same result was by dragging down the only cell with the formula. Can anyone tell me how he did it ? and thank you so much :)

Thank you very much for the tutorial, it was very helpful, I must say. But I want to pls say that under the IFS column, =IFS, does not exist in mine. How do I work without that?

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

The "days" formula worked for me although mine was in date format and the values i got were different for his

Is this tutorial's playlist enough to become a data analysis?

U R the best Alex THX

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

Hi Alex! thank you so much for these video tutorials. I have learned a lot and the way you explained it so much clear and superb that anyone can simply understand it. Also, may I know what version of Microsoft Excel your using in this turorial? Thanks a lot .

Thanks you Alex for making this lesson as easy as possible. my Excel fails to run the "Days, NetworkDays and Day formular. i keep get #Value what could be the problem here?

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!

Nice, thanks for the explanations!

Thank you sooo much!! This is so helpful!

Hi Alex. Thanks for making this video. Can you kindly tell me how did you apply the formula for the entire column? In the video I didn't see you using the fill handle to copy the formula to the entire column.

Thank you so much, Alex.

I have a quick question.😊 How much is the minimum salary for freshers in a data analyst role?

Thank you Mr. Alex

I couldn't use RIGHT function to extract year from the date from another dataset. Could you please explain to me what can be the problem?

Thank you Alex for sharing. please how do you separate surnames from first names that are joined together eg Alex Smith and you want to separate them into separate rows?

lol enjoyed the last remarks, The Excel Guy

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

Hello Alex what will be the alternative for IFS function in excel 2016. Because I do not have an IFS function on my excel 2016. Thanks

Please add AWS as well

Thank you A LOT!

if role ="HR" fire immedeatly was personal 😆

So good, thanks a million. One question for the community though: When I convert date to text via TEXT(...), I still get the error "#VALUE!". -Any ideas? :/

Conditional Formatting highlights using and condition and percentile 0.25

Hello Alex, Thank you for how you teach. please can you help me to understand INDEXMATCH? I am struggling with it.

Thaks Alex! I am curios about the holidays, Is it possible to specify a holidays from different countries?

Thanks Alex 👏❤️😇

Can you explain Vlookup and Hlookup

Excellent tutorials! But I faced a formula error in "DAYS" sheet for a few rows. I checked the format and dates, they look fine. Changed the dates and it worked. Anyone faced similar issue?

THANK YOU ALEX

but for same start and end date for me days and network days are different as shown in the video?? how ?

hello, Alex thanks for the great work you are doing, we really appreciate you and this has been a great blessing to me. some of the work sheets i download from the tuturials, are difficult to work with sometimes, sometimes some of the excel function doesnt work fully, how can I have this rectified. some of the functions you use does not really work with my excel. i use a 2020 MAc book pro and then microsoft 365, is there any help i can get?

alex you are using the american or European style for the dates in this dataset?

You are the best 🤝

Thanks Alex!

In All the videos , I can observe an absolute contempt for HR :-)

very useful

Done 🙂

on a newer version of excel better use textjoin function

What is the GitHub and where do I find this data? Thanks for all your help with putting together

min/max function is not working on my excel and i use the latest version

Moving forward.

For some reason my date>text function does not work!?

Greatful.

I'm working on the first IF formula. I'm entering the formula precisely as Alex, but it only calculates for the first row (Jim). Can anyone explain why this is, and how I can make it calculate for all rows?

Thank you so much

when i try min and max on dates i get a 0? what could be wrong

The link to the dataset used for this tutorial is not included.

Hi Alex, when trying to find the number of days between dates using "DAYS" function, for some of the values I am getting this error "#VALUE!". But for other dates it works fine. Any clue what could be the reason?

can you expaln what s excel nd how to use