Excel Pivot TablesShare
Admittedly, Murphy is a little hung up on Excel this week. This is probably the end. But if you’ve never looked at a pivot table it’s worth taking a peek.
We’re going to use the same data we used yesterday, an accounting of Murphy’s gambling activity while in Vegas last week. The raw data doesn’t tell us much, but the pivot table gives us tons of presentation options.
There are some truly nifty features in a pivot table. Like double-clicking a sum to create a table displaying its source data. The interface is great too – friendly drag and drop. Even if your table set-up isn’t right you can probably drag a few things here and there to fix it.
You can base a pivot table on an Excel list or some other data source. In the screencast we’ll use an Excel list for simplicity.Watch Now | Permalink