@22:32 You can do find and replace. Control F... this is my basic excel knowledge. I'm inspired to take that leap and learn data analysis, thank you for this!
thank you for this, i have been having issue with installing Microsoft Excel on my PC hence, hindering my data analysis studies, i am very happy to come across this videos. the short forms of what you did by Changing from Bachelor's and Bachelor's degree is cntrl H (to find) and replace. find bachelor's and replace with Bachelor's degree. do not forget to select "specific range" before applying. i am looking forward to the day i'll share my success story, though right now still struggling with analysing data. I got confused and lost along the line.
To apply the 'Bachelor's' and 'Master's' formats to the entire column, simply double-click the fill handle of the reference cell .... Thank you for this tutorial. It was fun.
Hey Mariam thank you for the video , it really helped. I think you could have used find and replace for the master and bachelor degree issue. Thanks for your tricks ❤
Also let me add that, we can filter the blank cells under filter by condition. that was how i got to know that some of those rows were empty. i also wants to ask, how do i handle a missing data?, for instance, there were three rows with empty cells, two has empty salary while one has empty Education level, i had to deleted the three rows..... in a real practice (real world scenero) is what i did proper? or is there a better way to handle the missing data instead of deleting them?. what if i have about 15 rows with some missing cells? i will appreciate a response from you and i will also like to be mentored pls if it is not too much to ask.
You can join my community here: mailchi.mp/0e715f524c98/join-the-community Plus check out this video on how to download the raw dataset: ua-cam.com/video/kzfLNND7ZUg/v-deo.html
@22:32 You can do find and replace. Control F... this is my basic excel knowledge. I'm inspired to take that leap and learn data analysis, thank you for this!
Excel and Power Query looking at Google Sheets with Bombastic Side eye😂😂😂😂😂
Thank you Mariam!!!
By the way, please share your tech gears and contents devices you use cuz your videos are so clean.
This come in the right time!❤❤
Thank you for this content ☺️🤗
thank you for this, i have been having issue with installing Microsoft Excel on my PC hence, hindering my data analysis studies, i am very happy to come across this videos.
the short forms of what you did by Changing from Bachelor's and Bachelor's degree is cntrl H (to find) and replace. find bachelor's and replace with Bachelor's degree. do not forget to select "specific range" before applying.
i am looking forward to the day i'll share my success story, though right now still struggling with analysing data. I got confused and lost along the line.
No beef with google sheets though, but with excel and power query it’s more easier for me… but this was really hands-on. Thank you, ma!!!
There’s beef with it dear. Excel is better
@ 😂😂😂😂😂 No joy 😂
Honestly,I just love using Excel
Thank you for this content.
May Allah grant you your heart desires. Chief Data officer to be, in Sha Allah
Ameen, thank you so much!
To apply the 'Bachelor's' and 'Master's' formats to the entire column, simply double-click the fill handle of the reference cell ....
Thank you for this tutorial. It was fun.
Great!
This was really hands on
😍😍😍😍
thank you!
Thanks Mariam
Hey Mariam thank you for the video , it really helped. I think you could have used find and replace for the master and bachelor degree issue. Thanks for your tricks ❤
You're absolutely right! That would have been the quickest way to resolve the issue
ctrl+shift+ arrow down
❤❤❤
Also let me add that, we can filter the blank cells under filter by condition. that was how i got to know that some of those rows were empty.
i also wants to ask, how do i handle a missing data?, for instance, there were three rows with empty cells, two has empty salary while one has empty Education level, i had to deleted the three rows.....
in a real practice (real world scenero) is what i did proper? or is there a better way to handle the missing data instead of deleting them?. what if i have about 15 rows with some missing cells?
i will appreciate a response from you and i will also like to be mentored pls if it is not too much to ask.
I think I will find a masters degree and replace with Masters
can u upload the dataset?? Can i join ur community?
You can join my community here: mailchi.mp/0e715f524c98/join-the-community
Plus check out this video on how to download the raw dataset: ua-cam.com/video/kzfLNND7ZUg/v-deo.html