Review these spreadsheet skills
Excel, Google Sheets, or Numbers are powerful tools. But you don’t know have to know everything about them to use them effectively to analyze the data you’ve collected.
Here is a series of skills you will most likely need and use to analyze your data:
- How to sort your data by the values of a column
- How to filter your data based on specific values of one or more columns
- How to “fill down” a column
- How to analyze your data in PivotTable (here is another good example)
- How to match data from different sources together using the VLOOKUP formula (here is a tool for you)
- How to add color to cells based on their values using conditional formatting
- How to perform basic calculations like SUM, AVG, COUNTIF, etc.
- How to stitch together text and values from different data columns into a new column using CONCATENATE