If you work with Pivot Tables and also use slicers, you may sometimes wonder whether a slicer can be used to control multiple Pivot Tables. The answer is, of course, YES (otherwise I won’t be writing about it). This is useful when you have multiple Pivot Tables and you want all of them to update ... Read more| Trump Excel
When working with Pivot Tables in Excel, I always ensure that my Pivot Tables are displayed in the tabular form. I don’t know why, but Microsoft has decided that any default Pivot Table would be shown in the Compact form. While powerful, the standard Compact Form in Pivot Tables can sometimes feel a bit… well, ... Read more| Trump Excel