This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: 4. Use Conditional Formatting to change to red all the products in the ProductsName that start with an "R" as below-5. Use Filter to Filter only show every ProductName that is not red (as above). 6. Use a Pivot Table to create a summary table that shows each ProductName and the total sold (of each) by SalesRep as below-...
View Full Document
- Fall '08
- Sales, Advanced Excel Exercise, Custom List Creation