Slicers in Power Pivot

No reviews yet.

Slicers are a visual display mechanism in PowerPivots which allow you to interactively filter your PivotTable display using fields and data from your Data Model.

PowerPivot Slicers can incorporate calculated and concatenated fields and be used in conjunction with timelines and charts to filter, analyse and display PivotTable information efficiently with minimal effort.

Highlights

Add a filter field to a Power Pivot PivotTable
Insert and apply a Slicer filter
Combine a Slicer filter with a Timeline Filter

Prerequisites

A basic knowledge of Power Pivot

Duration: 5mins 35secs

$6.99 AUD

from

$9.99

Add to Cart

Includes:

Quality On-demand Video Demonstrations
Step-by-step Learner Guide
Demonstration and practice exercises to boost retention
Lifetime access
Course progress indicator

Slicers in Power Pivot

Highlights

Prerequisites

Related Courses

MATCH Function

Work with Noncontiguous Ranges

Link Between Worksheets

Add Chart Elements

Intermediate Functions in Excel (Level 2)

Data Table Design Rules

$6.99 AUD

$9.99

Includes: