Bonus Points
https://www.youtube.com/watch?v=D9T5g9pSqUU&list=PLN2vGEJFAtTelSzQSh0mRUJP_pgWlhQRc&index=6
Posts
Activity 9: Pivot Table and Pivot Chart
Data Create Pivot Chart with Salesperson and Order Amount - Add the Salesperson to Rows and Order Amount to Values to find out the Grand Total. Create Pivot Chart with Region, Salesperson and Order Amount - Add the Salesperson to Rows, Region to Columns and Order Amount to Values. Insert Pivot Chart. Create Pivot Chart with Sales Person, Month and Order Amount - Add the Salesperson to Rows, Month to Columns, and Order Amount to Values. Change the number format of cells to Currency. Insert Slicer and Pivot Chart. Select the data you want to know.
Activity 7: Charts, Subtotal, Sorting, Filtering of Data
1. Sort by ID: Smallest to Highest 2. Sort by Name: A-Z ascending 3. Sort by Loan Amount Z-A Highest to Lowest 4. Filter by Item Type Sporting Goods 5. Create and customize a Book Sales Chart 6. Subtotal by Item Sum by Loan Amount