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 🚀
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.
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?
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
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?
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.
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?
@@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
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,🙄🙄🙄
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.
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 🚀
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!
* The "To_hot" column can also be fixed with IFS (ISBLANK(H2),"MISSING DATA!!",H2>=76,"Too Hot",H2
I've been watching your vids mate and I am nicknaming you 'The Great Gadsby'.
Thanks for the informative tips. Honestly, I didn't expect to get a Microsoft Excel instructional video from Moriarty, but here we are.
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.
Excellent presentation!!
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?
you can use conditional formatting .
Am so so new to Data Analysis I need guidance
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
It would be great if you could share the data you have used in the video. Please make a video on pivot table
please provide the datafile on which you worked with
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?
What is difference between using "Concatenate" and "&" function. as both returns to same value right ?
If I wanted to find out how many store 1s 2s etc were in the dataset what function would I use?
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.
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?
@@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
You look like Abel Gideon from the Hannibal TV series
I find power bi easier then excel
The temp is given in Celsius, so why not just calculate the Fahrenheit with a formula? or use C?
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,🙄🙄🙄
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.
Umm... you are correct. I tried to follow-up along with the linked data and I was immediately lost.
no self-respecting data analyst would ever use excel like this. You would use PowerQuery and M language if you have to use Excel.
please provide the datafile on which you worked with
please provide the datafile on which you worked with