Why do we use a pivot table?

Why do we use a Pivot Tables? This quick video will explain why we should use Pivot Tables when using Excel. Pivot Tables are one of the most important features in Excel of analyzing data. They provide a powerful and quick way of drilling down into vast amounts of...

Create a pivot table from a list

Create a Pivot Table from a List This quick video explains how you can Create a Pivot Table from a List. We need a list of data or a data source to create a pivot table. Learn how to insert a pivot table into Excel here. [et_social_follow icon_style="slide"...

Formatting the Pivot table

Formatting the Pivot Table FollowFollowFollowFollowFollow This quick video explains how to Format a Pivot Table in Excel. Once we have a pivot table created – we can format it and make changes to its appearance using the Design Tab. [et_social_follow...

Create a pivot chart from a list

Create a Pivot Chart from a List FollowFollowFollowFollowFollow This quick video shows how to create a Pivot Chart from a List in Excel. Pivot Charts provide a graphically rich way of viewing data from long lists of data. Pivot Charts are created along with Pivot...

Formatting the Pivot Chart

Formatting the Pivot Chart This quick video explains how to Format your Pivot Chart in Excel. Once you have selected a pivot chart – you can start to modify its appearance. Changing the design of your pivot chart is useful to help emphasize particular data points and...

Refreshing a Pivot Table and Pivot Chart

Refreshing a Pivot Table and Pivot Chart This quick video explains how you Refresh the Data in your Pivot Table and Pivot Chart. Pivot Tables do not refresh automatically if the underlying data is changed. Producing a new Pivot Table is a memory and time consuming...