Spreadsheet Skills

See Russell’s posts on spreadsheets and pivot tables for a complete walk through of our in-class exercises.

We looked at formulas to find the =AVERAGE() and =MEDIAN() of a range of cells (working with MLB salary data)

We downloaded Google’s data on flu related searches. We used data > text to columns ... to break the text block into columns, and then used some Excel formulas to find =MAX() values.

We didn’t use the auto filter button to set up filters that let us sort the data by a single column, but we could have. We also didn’t use paste special > transpose to shift rows into columns, but we could have, if we wanted to.

We used data Matt got from iCasualties.org to play with pivot tables, in Google Spreadsheets and Excel.

Leave a Reply

Your email address will not be published. Required fields are marked *