Arrangement of information or data, typically in rows and columns In table format.
Extract relevant data from a larger sheet or workbook into a smaller table- Pivot table.
Find everything within a certain category by using advance filter.
Combine data from various sheets and workbooks into one using advance function.
Use of VLOOKUP, H-lookup, index match formulas.
Able to convert data into relevant charts and graphs.
Highlight specific values by changing the appearance of a cell range based on specific criteria by using conditional formatting.
Sort the data in your spreadsheets into order.
Data Validation used to control what can be entered into a cell.