This preview shows page 1. Sign up to view the full content.
Unformatted text preview: Filtering table data o Click on the field name and you can select whichever ones you want from the drop down o You can filter multiple fields at the same time Click on data tab and go to clear to unfilter everything Custom filter o Go to drop down, text filter, custom filter (Harry Potter*) This will show all movies containing the words Harry Potter Sorting by Budget: o Click on budget, sort largest to smallest If you click on any cell in the total row they all have drop downs o There are tons of options: sum, count, etc Say you want total Budget for all universal films o =sumif(Movies[Distributor], Universal, Movies[Budget]) To add new column click on top right cell outside of table and enter an equation o If you change the formula for one cell it changes it for all in the column Convert to range changes it back from a table to normal data...
View Full Document
- Fall '08