Dear Data Analyst, do these 3 things before working on your dataset Watch this video❗❗ Follow me for more great tips Microsoft Excel

@msexcel I have a question. For a dataset that has 100k+ blank cells, DJ you think should still delete them? Especially when they are in different columns?

@msexcel If the columns are irrelevant to your business questions, you can remove them. Numerical columns can be replaced with the median value of that column

@msexcel Thanks

@msexcel This is a great tip. Thanks for sharing!

@msexcel I'm trying to link 2 spreadsheets together ,🥺 Is it only an online excel you can do it?

@msexcel This is really helpful. Thanks❤️