Excel for Data Analysis

I am on the job hunt and talked to multiple data analysis to see what they think is most used on the job. Most of them said Python, Visualization and Excel. Python is used to dive deeper into the data using Numpy and Pandas. For visualization of data a lot of people mentioned Tableu or some software that is similar. But Excel is used the most because most clients that they work with are using Excel. I have used basic Excel spread sheets but I figured I should dive into some of the more advance techniques that data analysts might use.

Vlookup() — this is used to help find a value within an Excel file. This works by you telling Excel the information you know and what information you want to know about that information.

Vlookup(column_you_know, range_of_columns:that_will_be_used_to_look_up, the_number_ofcolumn_within_range_that_has_info_looking_for)

Concatenate() — combines text cells into one new cell.

Concatenate(cell1_with_text, cell2_with_text)

If() — same statement as the if statement in python

Pivot tables — used to give summary of tables. They can give the average, sum, count and other calculations. These are easily created by clicking the insert tab and then PivotTable. From there you select what column you want the data to be sorted by and what calculations you want to be done to the data.

Sort — click on a cell in the column you want to sort. Then click on the sort tab and you can make data ascending or descending.

Filter — click on a cell in the column you want to be filtered. Then click on the filter tab and it will break down the rows and you check the boxes you want to be filtered.