#Excel #DataAnalyst #DataAnalysis

Key Takeaways

let's talk about why data analysts need to learn Excel there's this line of thinking for some people out there that because data analysts are more technical they don't need to know or use Excel I have personally never found that to be the case and in fact I think Excel is more relevant now than ever Excel is just a staple in business everybody uses it whether you're on the sales team or the customer team or the data analytics team A lot of times I think of excel as the way that we interact with the rest of the company no one else is going to be going into SQL or reading your python code or you know going and looking in Azure or AWS for whatever you're doing in there they're going to want a really simplified version of that that can be easily readable and understood and nine times out of ten you're going to put that in Excel for them so if you can show your work or even do all of your work in Excel sometimes it's just a lot easier when you're working with all these other teams in Excel in and of itself can do a lot you can do Advanced calculations you can do visualizations you can pivot data you can clean data you can explore data there are a lot of things that you can just do within Excel