FrankensTeam's Excel Collection
90.7K views | +20 today
Follow
FrankensTeam's Excel Collection
Useful, interesting and funny Excel stuff
Curated by Kris
Your new post is loading...
Your new post is loading...
Scooped by Kris
Scoop.it!

Use Slicer to select value fields for Pivot table or PowerPivot! - E90E50fx

Use Slicer to select value fields for Pivot table or PowerPivot! - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Use Slicer to select value field, measure for Pivot table or PowerPivot
Kris's insight:
Do you like this trick?
more...
No comment yet.
Scooped by Kris
Scoop.it!

Excel PowerPivot PivotTable Named Sets

Excel PowerPivot PivotTable Named Sets | FrankensTeam's Excel Collection | Scoop.it
Excel PivotTable Named Sets enable you to pick and choose which column or row labels to include in your PivotTable reports.
more...
No comment yet.
Scooped by Kris
Scoop.it!

Pivot Table Resources - Peltier Tech Blog

This is an index of Pivot-Table-related posts on the Peltier Tech blog, and a list of three good Pivot Table books.
Kris's insight:

All about Pivot tables.

more...
No comment yet.
Scooped by Kris
Scoop.it!

Calculated Field vs Calculated Item

Calculated Field vs Calculated Item | FrankensTeam's Excel Collection | Scoop.it

After you create a pivot table, you can enhance the results by writing your own formulas, to create calculated fields and calculated items.

Kris's insight:

Great summary and examples.

more...
No comment yet.
Scooped by Kris
Scoop.it!

Pivot Table Conditional Formatting

Pivot Table Conditional Formatting | FrankensTeam's Excel Collection | Scoop.it

"...you can adjust the formatting rules, so they refer to the pivot fields, instead of a specific range of cells."

Kris's insight:

Great and useful trick!

more...
No comment yet.
Scooped by Kris
Scoop.it!

Excel Pivot Cache • My Online Training Hub

Excel Pivot Cache • My Online Training Hub | FrankensTeam's Excel Collection | Scoop.it
The Excel Pivot Cache enables your PivotTable reports to be very responsive, but it comes at a cost. Learn how to manage the Pivot Cache here.
Kris's insight:

Great summary! Must-read for all pivot table users!

more...
No comment yet.
Scooped by Kris
Scoop.it!

Sort the Power Pivot measures (and fields) in the PivotTable Fields

Sort the Power Pivot measures (and fields) in the PivotTable Fields | FrankensTeam's Excel Collection | Scoop.it
When designing your pivot tables based on a Power Pivot model you typically add fields and measures continuously, and in the measure list they will by default list then be sorted by the order you h...
more...
No comment yet.
Scooped by Kris
Scoop.it!

Excel PivotTable Field List Can Float!

Excel PivotTable Field List Can Float! | FrankensTeam's Excel Collection | Scoop.it

Hover over the title bar for the PivotTable Field List.
When your mouse changes to a four-headed arrow, click and drag it to the position where you would like it to appear and resize as needed.

Kris's insight:

I like it!!

more...
No comment yet.
Scooped by Kris
Scoop.it!

Pivottable slicers Excel 2010: Synchonising Slicers

Article about using Pivottable slicers in Excel 2010; Synchonising slicers
Kris's insight:

Useful for practice!

more...
No comment yet.
Scooped by Kris
Scoop.it!

Excel Pivot Table Tutorial -- GetPivotData

Excel Pivot Table Tutorial -- GetPivotData | FrankensTeam's Excel Collection | Scoop.it

The basics of Getpivotdata.

Kris's insight:

In my practice, Getpivotdata is very-very useful for building reports.

more...
No comment yet.
Scooped by Kris
Scoop.it!

Change All Pivot Tables With One Selection | Contextures Blog

Change All Pivot Tables With One Selection | Contextures Blog | FrankensTeam's Excel Collection | Scoop.it

There is a new sample file on the Contextures website, that changes all the pivot tables, when you change a report filter in one pivot table.

Kris's insight:

What a beautiful moment when you find exactly what you need - within 2 minutes! :-)

more...
No comment yet.