Excel 2016 – 3.2.4 – Apply Pivot Styles
The default PivotTables Style is based on a blue colouring – but if blue isn’t your colour, then you can easily change the Style to any of the other pre-created Styles that Microsoft provides.
Excel 2016 – 3.2.3 – Change The Pivot Layout
Maybe you’d like to remove the Grand Totals or add Subtotals to each Group. Maybe you’d like to add space between each Group to make it easier to read. Learn how to quickly and simply alter the layout of your PivotTable.
Excel 2016 – 3.2.2 – How To Rename Field Headings
This video shows you how to change the field headings to be more understandable. It will also show you how to overcome a very common problem that you will encounter when renaming those field headings.
Excel 2016 – 3.2.1 – How To Display Blank Cells
Learn how to display the blank cells that appear in a PivotTable – as zeros.
Excel 2016 – 3.1.11 – Set a PivotTable To Refresh On Open
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.
Excel 2016 – 3.1.10 – Refresh the Data
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 […]
Excel 2016 – 3.1.9 – Insert and Use Slicers
Slicers are an excellent feature for filtering a PivotTable. In this video learn how to create, modify and delete Slicers.
Excel 2016 – 3.1.8 – Create a PivotChart
This video shows you how easy it is to create a PivotChart. PivotCharts, like PivotTables, are dynamic and you’ll see that reflected in this video.
Excel 2016 – 3.1.7 – Drilldown Into Pages
This video will show you how to quickly drilldown the Location field to show a separate Worksheet and PivotTable for each of the individual Locations. A very powerful feature of PivotTables.
Excel 2016 – 3.1.6 – Drill Into Pivot Data
This video shows you how you can drill into any of your figures and get a breakdown of the sales that make up a figure. We’ll show a single drill-down, but you can drill-down on as many figures as you like.
Excel 2016 – 3.1.5 – Filter and Ungroup Pivot Data
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.
Excel 2016 – 3.1.4 – Group a PivotTable By Date
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.
Excel 2016 – 3.1.3 – Add Currency Style To Pivot Data
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.
Excel 2016 – 3.1.2 – Create a Basic PivotTable
This video shows you how easy it is to create a basic PivotTable. We’ll then build on this PivotTable over the rest of videos in this lesson.
Excel 2016 – 3.1.1 – View and Setup Data
Data to be used in a PivotTable must be structured in a way that Excel understands, or it just won’t work properly. This video will show you how to correctly set up your data, in the ‘Tabular’ way, that PivotTables understand.