Activity 9 Pivot Table and Pivot Chart
2.
3.
5.
6 and 7.
8. Create Pivot Chart with Sales Person and Order Amount
9. Create Pivot Chart with Region , Sales Person and Order Amount
10. Create Pivot Chart with Sales Person, Month and Order Amount
Exercise 8 Chart, Sorting, filter, Subtotals
1. Print screen Sort the data by ID A-Z smallest-highest. 2. Print screen Sort by Name A-Z sort ascending 3. Print screen Sort by Loan Amount Z-A Sort Highest to Lowest. 4. Print screen Filter by item type– Sporting goods. 5. Print screen - Create and customize a book sales chart.
Comments
Post a Comment