Database Reference
In-Depth Information
F I g u R e 5 -17
Creating a pivot table
wHAT DoeS eXCel Do FoR Me?
If you're still asking this question, you haven't been paying attention! Kidding,
but only a little. Excel is very powerful. Even without PowerPivot, Excel gives
us some great functionality for analyzing our data. In fact, without Excel's
pivoting, charting, and analysis tools, PowerPivot would not be as functional
either because we often explore our models right in Excel.
PIVoT CHArTS AND TABLES
Using pivot charts and tables is an incredibly powerful and easy way to begin
simple visualizations that provide some great self-service capabilities for
end users. They allow for dynamic work on charts and tables by using drag-
and-drop functionality and easy-to-learn formulas and techniques for more
advanced users.
