Exercise 9 Pivot Table and Pivot Chart

 Creating Pivot Table and Pivot Chart

A. Create Pivot Chart with Sales Person and Order Amount 

B. Create Pivot Chart with Region , Sales Person and Order Amount

C. Create Pivot Chart with Sales Person, Month and Order Amount

Bonus Points

 

https://www.youtube.com/watch?v=D9T5g9pSqUU&list=PLN2vGEJFAtTelSzQSh0mRUJP_pgWlhQRc&index=6

Creating Graphic Design

Illustration

Exercise 8: Functions - Sum, Average, IF, V-Lookup

 PAYROLL

Figure 1. Payroll original

Figure 2. Part 1 show formula

Figure 3. Part 2 show formula

Exercise 7: Charts, Subtotal, Filter and Sorting

 Chart, Sorting, Filter, Subtotals

Figure 1. Original Content

Figure 2. ID lowest to highest

Figure 3. Customer Name ascending

Figure 4. Amount Loan highest to lowest

Figure 5. Filter by Item Type

Figure 6. Sales Chart