Everything Analytics

Everything Analytics

This channel is dedicated to providing insightful content focused on the field of data analytics. Our goal is to offer comprehensive coverage of topics related to data analysis, including techniques, tools, best practices, case studies, and industry trends. We aim to educate and inform our audience about the latest developments in data analytics, empowering individuals and organizations to harness the power of data for strategic decision-making, problem-solving, and business growth.

Data Cleaning in Excel

Data Cleaning in Excel

Пікірлер

  • @sundayatulukwu2511
    @sundayatulukwu25118 күн бұрын

    From 10 weeks analytics! Thank you for sharing this

  • @adeodu2009
    @adeodu2009Ай бұрын

    Amazing

  • @Oldpegasus
    @OldpegasusАй бұрын

    Good Evening. Thank you for this video. Okay, so i have 2 questions. 1. is there an alternative formula for the text after fxn, I'm using an older Excel version. 2. how can i select just a single column in an excel sheet. anytime i try, i end up selecting the whole sheet. Thank you

  • @Oldpegasus
    @OldpegasusАй бұрын

    Okay. I'm back. So I've gotten an alternative formula for the text after fxn

  • @Oldpegasus
    @OldpegasusАй бұрын

    Once again. Quality Video. I couldn't get my assignment do in time to submit unfortunately. Thank you for this review. much appreciated. To the lady that kept getting an error message, my guess would be that she didn't put a comma when writing her formula for the Lookup fxn.

  • @Ovey4004
    @Ovey4004Ай бұрын

    Great teaching

  • @EverythingAnalytics
    @EverythingAnalyticsАй бұрын

    Thank you

  • @korea280
    @korea280Ай бұрын

    Thank you so much for this class. So insightful, and broken down so simply.

  • @Oldpegasus
    @OldpegasusАй бұрын

    Quality video. Very insightful for beginners such as myself. I have a question, during the course of video, you kept saying down the row and across the column. I had always thought that in Excel, columns were vertical while rows were horizontal, in line with your statements at the start of the video that (columns are represented alphabetically while rows, numerically). Correct me if I'm wrong. I always tend to mix them up. Once again, thank you for the Video.

  • @EverythingAnalytics
    @EverythingAnalyticsАй бұрын

    Yes, you are very correct. However when you move vertically down you are moving from one row to the other and also if you are moving horizontally you are moving from one column to the other

  • @osifogoodness2611
    @osifogoodness2611Ай бұрын

    This is impressive

  • @EverythingAnalytics
    @EverythingAnalyticsАй бұрын

    Thank you

  • @user-cf9od1qi2c
    @user-cf9od1qi2cАй бұрын

    Thanks for this sir.

  • @V.e.e.k.y
    @V.e.e.k.y2 ай бұрын

    Please I have a question on mixed referencing. Mixed referencing is the combination of relative and absolute referencing. Then you gave an example of adding numbers using their roll and columns and then locking it with the $ sign like D$13+E$but then in another spreadsheets of you talking about drivers, we were trying to multiply it, you used only locked the first roll which was D$2*D5 that is using 7% in D2 to multiply the roll So my question is why didn’t you lock both like d$2*D$5 because if we locked both and multiply, won’t we get the same answers?

  • @user-mv4pz6rg5e
    @user-mv4pz6rg5e2 ай бұрын

    Mixed referencing in formulas refers to fixing either the row or column of a certain cell or all of the cells involved in the formula while allowing the other part to change as the formula is copied to different cells.

  • @V.e.e.k.y
    @V.e.e.k.y2 ай бұрын

    My question still hasn’t been answered Could you share more light on it

  • @osifogoodness2611
    @osifogoodness26112 ай бұрын

    Powerful ✨ teaching

  • @osifogoodness2611
    @osifogoodness26112 ай бұрын

    Sharp Explanation

  • @osifogoodness2611
    @osifogoodness26112 ай бұрын

    Very clear teaching. Keep it up

  • @tosispace881
    @tosispace8812 ай бұрын

    Hello

  • @adeodu2009
    @adeodu20092 ай бұрын

    Nice

  • @thenosafavourondata
    @thenosafavourondata2 ай бұрын

    Please can we get the file used for this tutorial?? it wasnt shared in the milestone folder