Pivot Tables Archives - Excel Campus


Category Archives for "Pivot Tables"

Pivot Table Defaults to Count Instead of Sum & How to Fix It

Bottom line: Learn how to get the pivot table to default to a Sum calculation instead of Count when the source data field contains numbers.

Skill level: Beginner

Video: How to Default the Pivot Table Calculation Type to Sum

Watch in full screen HD or on Youtube.

Continue reading

Free Webinar: 7 Steps to Getting Started with Macros & VBA


Grab My Free Cheat Sheet!

VLOOKUP Essentials Guide​

Vlookup Essentials Guide 317x407
Plus: Free Video Training Series on the Lookup Formulas!