Free Microsoft Excel Training Videos

Pivot tables in Excel

What can you do with Pivot Tables?
  1. Pivot tables are interactive tables
  2. Pivot tables help to organize and compare data
  3. They can help to view trends and relationships quickly
  4. They make it easy to change the view quickly so that you can see another interesting aspect of your data just like in a kaleidoscope
  5. Best of all, it just takes seconds to make the reorganization of the Excel data

How to create pivot tables in Excel:
  • Ask yourself: What do I need to display in my pivot reports?
  • In our example, we wanted to display the names of the sales people, how much they sold and what commission they earned
  • Also we should be able to view sales in different locations - individually and totally
  • We placed the names in the 'Drop Row Fields Here'
  • We placed the 'Order Amount' in 'Drop Data Items Here' because this where the calculation takes place
  • We dropped the 'Location' items in 'Drop Page Fields here' because we could view each location in a different page
  • Finally we added a 'calculated filed' to calculate the 'commission' using a customized 'if' function
  • We then applied formatting to the pivot table to make it look appealing!
  • And if you think this is not what you wanted, just pull out the item headings and start over again
  • Refer to the Excel training video to see pivot tables in action

More reading on Pivot tables in Excel and spreadsheets
Pivot Tables in Excel 2007
More about Pivot tables in Microsoft Excel

Pivot Tables in Excel