Excel for Data Analysis
Excel is not just for keeping track of bills or a place to type phone numbers in to. It is a great tool for data analytics that can do a lot. You can run calculations on it and process large amounts of data. It will take raw data and organize it
Here are a few of the tools in Excel for analysis:
VLOOKUP: this brings together two data sets
XLOOKUP: solves VOLOOKUP and Index Match Problems
Pivot Table: A good way to see data comparisons without having to apply a lot of filters
Analysis ToolPak: can do statistical testings in the notebook with this.
Besides just analysis, you can also create visualizations on Excel. Visualizations are a great way to tell a story for your data. And it is quite easy, too. With the ribbon feature, most of the things you can do is click and then click on the columns.
Excel is in demand and good tool to learn to put on your resume. It is very useful for data analytics.
