Clearing, Selecting, Moving & Copying Pivot Tables

Refreshing, Updating Pivot Tables & Dealing with Growing Source Data

Removing & Reviving Data from the Pivot Table Cache

Separating Each Item on the Report in a New Sheet

Changing Pivot Table Number Formats

Formatting Empty Pivot Table Cells & Pivot Table Styles

Configuring Pivot Table Layouts

Using Tabular Pivot Tables & Insert Blank Line After Each Item

Using Tabular Pivot Tables to Create New Source Data

Applying Basic Conditional Formats to Pivot Tables: Part 1

Applying Basic Conditional Formats to Pivot Tables: Part 2

Adding Data Bars with Invisible Text

Applying Advanced Conditional Formats to Pivot Tables

Advanced Data Sorting to Help Decision-Makers Make their Decisions

Data Sorting In-Depth

Fixing Incorrect Alphabetical Sorting

Filtering Data with Pivot Table Selection Filters

Customizing Filtering Data with Pivot Table Label Filters

Pivot Table Label Filters with Wildcards

Filtering Data with Pivot Table Value Filters

Enabling Multiple Pivot Table Filters Per Field

Grouping & Segmenting Data with Pivot Tables

Enabling & Disabling Automatic Date Grouping

Control Your Report Using Slicer: Part 1

Control Your Report Using Slicer: Part 2

Advanced Slicer || Report Connection

Filtering Data with Pivot Table Timelines

Breaking Out Pivot Table Report Filter Pages

Aggregating & Summarizing Data with Pivot Tables

Defining Value Calculations with Pivot Tables

Calculating Pivot Table Values: Percentage of Column/Row

Calculating Pivot Table Values: Percentage of Grand Total

Calculating Pivot Table Values: Percentage of Parent Column

Calculating Pivot Table Values: Difference From & Percentage Difference From

Calculating Pivot Table Values: Running Total & Percentage Running Total

Calculating Pivot Table Values: Rank

Defining & Creating Calculated Fields with Pivot Tables

Creating ROI Calculated Fields with Pivot Tables

Introduction to Excel Pivot Charts

Pivot Chart: Column Chart

How to Make an Advanced Enhancement in Your Column Chart!

Pivot Chart: Pie & Donut Charts

Pivot Chart: Clustered Bar Chart (Two Charts in One)

Pivot Chart: Bar Chart (100% Stacked Bar)

Preventing Charts from Resizing with Cells

Pivot Chart: Line Chart (Years Trend)

Pivot Chart: Stacked Area Chart Vs. Line Chart

Applying Slicers & Timelines to Multiple Pivot Charts

Preparing an Interactive Excel Dashboard

Make an Advanced Enhancement to the Dashboard

Case Study: Analyzing Stock Market Data