Microsoft Excel-Pivot Tables, Pivot Charts, Slicers, and Timelines

Enrol now to go through popular excel Excel Pivot functions.Microsoft certified trainer with a number of years of experience will guide you through the Excel Pivot functions.

Everyday work and home excel Excel Pivot functions are fundamental to complete Excel tasks with efficiency.

At completion of this course you will have mastered the most popular Excel Excel Pivot functions and come out with confidence to complete any Excel tasks with efficiency.

Below are just a few of the topics that you will master:

Building basic maths
Managing the Field List

Changing the Calculation type with Value Field Settings

Growing your Pivot Table with Multiple Fields

Formatting the Pivot Table

Sorting and Filtering the Pivot Table

Creating a Dashboard with Slicers, Timelines and Pivot Charts

Reporting by day, month, qtr, or year within the Pivot Table

Refreshing the Pivot Data with new data

Adding your own calculations into the Pivot Table

The power of the Filter Section in the Pivot Table

PowerQuery

PowerPivot