FrankensTeam's Ex...
Follow
Find tag "PivotTables"
38.1K views | +51 today
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!

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.
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.