, Microsoft Most Valuable Professional Curt Frye helps dispel the common fear of the Pivot Table feature, by demonstrating how to use this powerful tool to discover valuable business intelligence.
Curt shows how to create Pivot Table reports from internal Excel data and outside data sources, use filters to focus on the most important data in the sheet, and make visual presentations of data using Pivot Chart reports. Start your free month on Linked In Learning, which now features 100% of courses.
Develop in-demand skills with access to thousands of expert-led courses on business, tech and creative topics.
As much as I love Excel pivot tables, there are a few annoying problems that you’ll run into, while working with them.
This is a very useful function, but you might prefer to have a simple link most of the time.
To fix this, you can change an Excel setting, so the Get Pivot Data formula doesn’t appear automatically.
When you add fields to a pivot table’s Values area, they’re usually calculated as a Sum.
Sometimes though, the fields are calculated as a Count, which might not be what you want.
To fix this, you manually change the field to Sum, after it’s in the pivot table.
Or, fix your data, so it doesn’t contain blanks or text data in that field.