Blog - Page 4 of 16 - Excel Campus
10

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

22

Preview of The Filter Mate Add-in for Excel

In the last webinar I mentioned a new add-in that I have been working on with Randy, a student of The VBA Pro Course.  The add-in is called Filter Mate.

The goal of Filter Mate is to help make it easier to work with filtered ranges and Tables in Excel.  I just recorded a quick video that gives a preview of how Filter Mate works.

Video: Preview of the Filter Mate Add-in


Continue reading