If you have multiple PivotTables created from the same data source, then you can attach the same Slicers to all of them, so that they are all Filtered together. Particularly useful for Dashboards.
A manual Sort is great for small amounts of information, but if you want to create your own Sort Order for large amounts of data, then look at carrying out a Custom List Sort instead. Another advantage of this type of Sort is that it can be re-used in other PivotTables.
By default, PivotTables have to be manually Refreshed. However, there is a way that you can set them up to automatically Refresh whenever the Workbook is opened. In this video we’re going to see how you turn on that feature.
This video shows you that if you increase your original dataset you then need to Refresh the PivotTable so that it picks up the new data. If your original dataset was turned into a Table before being made into a PivotTable we’ll see that the Refresh is very simple. However, if the dataset was not […]
This video shows you filtering and how it works differently with Grouped information. You’ll also see that Grouping stays with data, even when removed from the PivotTable, so if you want data to be Ungrouped, you have to manually carry it out.
The dates in the Date column span 2 years. This is the correct way to input dates in your dataset, if you want to create a PivotTable. However, to display the information by Year we need to know how to Group those dates. We’ll take it a step further and Group by Quarter, within Year.
Believe it or not, there is a correct way and a wrong way, to turn on the Currency style in a PivotTable. Learn the correct way, but also discover why the wrong way – is wrong.
This video shows you the steps to take to move a Macro into the Personal Workbook, so that it is available to all Excel Workooks on your computer. This will be done using the VBA Editor. You will also see how to delete a Macro – and at the end of the video, you’ll see […]
This video shows you the Security message that you should receive when you open a Workbook with a Macro in it. It will also explain why you get this message.
We’re looking at using the SMALL function on it’s own, then we’re looking at using it through the AGGREGATE function. This will show you when you would use one above the other.
We’re looking at using the LARGE function on it’s own, then we’re looking at using it through the AGGREGATE function. This will show you when you would use one above the other.