Posts

Showing posts from November, 2021

Activity 9 Pivot Table and Pivot Chart

Image
 2. 3.  4. 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

Image
 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.

Exercise 6: Budget and Supplies & Customer Invoices

Image
 Budget and Supplies Budget and Supplies with Formula Customer and Invoices Customer Invoices with formula