Microsoft Excel Training Videos
Pivot tables in Microsoft 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 training video below to see pivot tables in action
Microsoft Excel Training Videos
