by Fiona Hannon | Aug 14, 2014 | Excel Reporting and Dashboards |
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...
by Fiona Hannon | Aug 14, 2014 | Excel Reporting and Dashboards |
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"...
by Fiona Hannon | Aug 14, 2014 | Excel Reporting and Dashboards |
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...
by Fiona Hannon | Aug 14, 2014 | Excel Reporting and Dashboards |
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...
by Fiona Hannon | Aug 14, 2014 | Excel Reporting and Dashboards |
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...
by Fiona Hannon | Aug 14, 2014 | Excel Reporting and Dashboards |
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...
