Friday, August 7, 2015

Pivot Tables, Pivot Charts, Slicers, and Dashboards - Complete! 1 Hour Course


This is a complete 1 hour course on how to get to most out of Pivot Tables , Pivot Charts, Slicers, and Dashboards. Now 100% free! This really can show you how to take huge amounts of data and get many reports and charts from that data. Pivot Tables are really the buzz word in Excel these days. Topics Include: Topic Getting Started with the pivot table Creating a Drill Down Report Hiding / Displaying Field List Changing Calculation type with value field settings Showing more than 1 calculation Showing % of total and other calculations Removing fields from the pivot table How to add column headings How to switch row and column headings Sorting the pivot table Sorting across Filtering the pivot table Adding layers of information by adding more fields Some formatting options Adding a pivot chart Slicers Timelines How to add your own calculations to the pivot table How to change your own calculations How to change your column headings
https://youtu.be/Yzk0-u0fCCE

No comments:

Post a Comment