Pivot Tables In Excel, Tables

• This information is from the second part of Chapter 15.
• This data is my work from last time.
  • This is the data we worked on last time. You can use mine or yours.
• Our goal is to explore this data to see if we can spot any information that might be useful.
• Build a pivot table.
• Build a tool to investigate prices
  • Drag extended cost into the Values box
    • Change this from sum of to average
    • Format this as a number.
  • Drag Product line into the rows.
  • Drag Territory into the columns
  • Drag Years into the columns
  • Switch years and territory
• Remove all values
• Build a chart to investigate items sold
  • Sum of quantity in values
  • Product code in rows.