Excel Tip #10: Pivot Tables and Pivot Charts
Pivot Tables and Pivot Charts are great for analyzing data, and the tools in Excel make them easy to create. When making a Pivot Table consider adding slicers to make it easy to select and view the data you want to see.
Add a slicer: select the Pivot Table (or the Pivot Chart) and from the Pivot Table Tools > Options tab, select Insert Slicer. For a Pivot Chart, select Pivot Chart Tools > Analyze tab and select Insert Slicer.
Choose one or more slicers for the data that you want to analyze. You can then select the data to view in the Pivot Table or the Pivot Chart by clicking the appropriate entry in the Slicer. When selecting options in a slicer, hold the Ctrl key to select multiple data categories for viewing. This is great for your own use, and it also helps inexperienced Excel users to quickly analyze large data sets and to extract only the information they need.
If you have a favorite Excel tip to share, post it in the comments below.
Helen Bradley is a respected international journalist writing regularly for small business and computer publications in the USA, Canada, South Africa, UK and Australia. You can learn more about her at her website, HelenBradley.com
|Do you have a comment or question about
this article or other small business topics in general? Speak out in the
SmallBusinessComputing.com Forums. Join the discussion today! |