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

Поделиться
HTML-код
  • Опубликовано: 25 ноя 2024

Комментарии • 28

  • @careerfoundry
    @careerfoundry  2 года назад +1

    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 🚀

  • @astronautas
    @astronautas Год назад +10

    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!

  • @stri06
    @stri06 2 года назад +14

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

  • @michaelliu7729
    @michaelliu7729 Год назад +2

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

  • @markslima1557
    @markslima1557 2 года назад

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

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

  • @jamesbaldone6946
    @jamesbaldone6946 Год назад +1

    Excellent presentation!!

  • @extraincomesuz
    @extraincomesuz 2 года назад +2

    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?

  • @priscaoitomen8329
    @priscaoitomen8329 4 месяца назад

    Am so so new to Data Analysis I need guidance

  • @kmarialovesnature
    @kmarialovesnature 2 года назад +1

    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

  • @afreenanita2007
    @afreenanita2007 2 года назад

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

  • @iftakharulislamrefat5681
    @iftakharulislamrefat5681 Год назад +1

    please provide the datafile on which you worked with

  • @abigailgarner1791
    @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?

  • @darshanmajithia6491
    @darshanmajithia6491 Год назад +1

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

  • @saiir04
    @saiir04 Год назад

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

  • @puduhari1
    @puduhari1 2 года назад +1

    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
      @careerfoundry  2 года назад +3

      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
      @Ashallmusica 2 года назад +1

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

  • @urm786
    @urm786 2 года назад

    You look like Abel Gideon from the Hannibal TV series

  • @AlishaBhullar_
    @AlishaBhullar_ 8 месяцев назад +2

    I find power bi easier then excel

  • @charleyh.553
    @charleyh.553 Год назад

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

  • @volodiamalachovskiy7822
    @volodiamalachovskiy7822 Год назад +1

    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,🙄🙄🙄

  • @Idrizly
    @Idrizly 2 года назад +1

    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
      @markslima1557 2 года назад

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

  • @iiiiii-w8h
    @iiiiii-w8h Год назад +2

    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
    @iftakharulislamrefat5681 Год назад

    please provide the datafile on which you worked with

  • @iftakharulislamrefat5681
    @iftakharulislamrefat5681 Год назад

    please provide the datafile on which you worked with