Pivot Tables Archives - Page 3 of 4 - Excel Campus

Archive

Category Archives for "Pivot Tables"
8

PivotPal Bonus Videos: Learn PowerQuery, Unpivoting, VBA, & More

The add-in I have been talking about for weeks is finally available.  And I have a few bonuses to go with it.  Plus, a special limited time offer!

What’s the Word on PivotPal?

Here is a quote from David, a PivotPal user…

David W
“Using the PivotPal has been quite a ‘light bulb moment’ in that it has helped to really cement my understanding of how Pivots in MS Excel work – quite apart from making Pivot Tables much easier and faster to set up, especially for multiple tables, it’s also helped me understand much better MS Excel’s high level Pivot Table workflow.

Continue reading

83

How to Create Dependent Cascading Drop-down Lists

Bottom line: Learn how to create cascading or dependent drop-down lists (also known as cascading validation) in Excel.  This technique does NOT require named ranges.  If you don’t mind using named ranges then there are a few links at the bottom of the page with solutions that will be easier to implement.

Skill level: Intermediate

Functions used: OFFSET, MATCH, COUNTA, COUNTIF, INDIRECT Continue reading