The 10 Most Important Excel Formulas and functions - Made Easy! (2024)

[@careerfoundry]

Which functions of this list have you used already? Have we missed any essential ones? Let us know! ⌨ If you’d like to try out these functions on real data and start your journey in data analytics, we have got a free data analytics short course, here’s the link to sign up: bit.ly/DAShortCourse7 🚀

[@stri06]

* The "To_hot" column can also be fixed with IFS (ISBLANK(H2),"MISSING DATA!!",H2>=76,"Too Hot",H2

[@astronautas]

I watched so many different tutorial videos, however this one amongst the best. You are explaining in a clear and simple way, so huge thank you!

[@michaelliu7729]

I've been watching your vids mate and I am nicknaming you 'The Great Gadsby'.

[@jamesbaldone6946]

Excellent presentation!!

[@violetheise4717]

For some reason there are just some formulas I have a hard time conceptualizing. I had to listen to the nested ISBLANK a few times to get it. Thanks for being clear about what chunk of info serves which purpose in the overall function/formula.

[@markslima1557]

Thanks for the informative tips. Honestly, I didn't expect to get a Microsoft Excel instructional video from Moriarty, but here we are.

[@extraincomesuz]

I use Google Sheets but it's good to see how you do it in Excel ...thanks for a great short tutorial! Is there a conditional function in Excel that could color the cell's background red for too hot?

[@mahadevsakolkar9980]

you can use conditional formatting .

[@darshanmajithia6491]

What is difference between using "Concatenate" and "&" function. as both returns to same value right ?

[@iftakharulislamrefat5681]

please provide the datafile on which you worked with

[@kmarialovesnature]

Hi this was a useful video. Is there a way to find the last digits in a string like the zip code but it varies in number. It could be 3, 5 or 6 digits for example and comes after symbol _ ? Thanks

[@saiir04]

If I wanted to find out how many store 1s 2s etc were in the dataset what function would I use?

[@priscaoitomen8329]

Am so so new to Data Analysis I need guidance

[@afreenanita2007]

It would be great if you could share the data you have used in the video. Please make a video on pivot table

[@puduhari1]

If someone is still in high school is it good to study computer science degree or a data science degree. This is for someone in the USA. If high pay and the longevity of the profession are the critical factors to consider, what’s your recommendation and why.

[@careerfoundry]

Hey! You don't need a degree to get started in either, and with Data Science / Analytics there are a wide range of learning avenues that are much lower cost than studying a degree at college. We have a really nice blog article on this topic too: careerfoundry.com/en/events/how-to-become-a-data-analyst/ Hope this helps?

[@Ashallmusica]

@@careerfoundry i don't have a degree of anything, and i found this field promising to me and saving some money to start a course, it it worth for me too

[@abigailgarner1791]

Very informative video, thanks! I am starting out as a data analyst and it has been hugely helpful to get familiar with these function early on. I would like to get some advice, in South Africa our identity numbers start with our data of birth in year, month and date in short format. If I use the left function to extract those 6 digits from the identity numbers, is there a function I can use to convert the data back into a date format?

[@charleyh.553]

The temp is given in Celsius, so why not just calculate the Fahrenheit with a formula? or use C?

[@volodiamalachovskiy7822]

Hello. The dataset you use in the video and the one you give a link to are different and that makes it difficult to replicate everything you are doing,🙄🙄🙄

[@urm786]

You look like Abel Gideon from the Hannibal TV series

[@AlishaBhullar_]

I find power bi easier then excel

[@Idrizly]

why didn't you give us the same data you are using in the video, it is hard to follow along with the original data downloaded from kaggle. Thanks though.

[@markslima1557]

Umm... you are correct. I tried to follow-up along with the linked data and I was immediately lost.

[@iiiiii-w8h]

no self-respecting data analyst would ever use excel like this. You would use PowerQuery and M language if you have to use Excel.

[@iftakharulislamrefat5681]

please provide the datafile on which you worked with

[@iftakharulislamrefat5681]

please provide the datafile on which you worked with