2020 - MS Excel: Advanced Pivot Tables for Superior Data Analytics

Structuring Your Source Data
Rapidly Inserting Your First PivotTable
Navigating the Field List
Manipulating PivotTable Views
PivotTable Options Using Analyze and Design
Quickly Moving or Copying Pivot Tables
Automatically Managing Dynamic, Growing Source Data
Refreshing and Updating Data (Critical)
Number Formatting Including Custom Number Formats
Rapidly and Automatically Formatting Empty Cells To Avoid Problems
Close
Table Layouts and Styles Including the Advantage of Tabular Designs
Customizing Headers and Labels – and How This Impacts Your Charts
Integrating Conditional Formatting Into Your Pivot Tables
Creating Data Bars with Invisible Text – 3 Methods
Sorting, Filtering and Grouping Options
Label Filters and Manual Selections
Using Label Filters with Wildcards
Incorporating Multiple Value Filters
Grouping Data Including a Super-Flexible Method
Automatic Date/Time Grouping – From Seconds to Decades
Using Slicers and Timelines to Filter Simultaneously in Many Tables and Charts
Creating Separate Worksheets from Report Filters
Calculate Values, Fields and Items in a Variety of Useful Formats
Summarize Values Using a Variety of Built-In Options
Show Values As: % of Column and/or Row
Show Values As: % of Parent
Show Values As: Difference From
Show Values As: Running Total – Numbers and Percent
Show Values As: Rank
Inserting Calculated Fields for Flexibility
Avoiding Subtle Problems – Calculated Fields vs. Raw Data Computations
Introductions to PivotCharts: Column, Line, Pie, Donut, More
Inserting Values and Percent Into Charts for Visual Analytics
Trendlines for Rapid Visual Analytics, Regression Analysis and Forecasts
Prevent Annoying Chart Resizing with Cell Changes
Instantly Changing Rows and Columns and Chart Types
Pivot Chart Layouts, Styles and Advanced Formatting
Connecting Slicers and Timelines to Multiple Charts
Introduction to Building a Dynamic Dashboard; Simultaneously Sizing Charts
Introduction to ‘Big-Data’ Analytics with the Pivot Table Data Model