Final Projects
Handouts
|
Tutorial: How to use pivot tables.
Instructions: 1. Download Excel file (above) 2. Open the Excel file 3. Let's Sort the data: Data > Sort (pick how you want to sort the data) 4. Let's set up Filters Select Row 1 Data > Filter Can you find the students who like purple? What % of students like purple? Hint: See document bar below 5. Let's add an Age column Type "Age" in Column G We will set up a formula: In Cell G2, type =DATEDIF(D2,TODAY(),"Y") Use the "Fill Handle" (cross bar) to copy the formula down |
ePortfolio Assignments
|
|
|
|