FrankensTeam's Excel Collection
96.5K views | +132 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!

Export Excel Dashboards (Improved Version)

An improved version of the example workbook exporting Excel Dashboards to other applications
Kris's insight:

Very useful tool!

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

Selecting and Highlighting Areas on Excel Charts

Selecting and Highlighting Areas on Excel Charts | FrankensTeam's Excel Collection | Scoop.it
Interactive Selecting and Highlighting Areas on an Map or an XY Scatter Chart in Microsoft Excel
Kris's insight:

Really it's magic! :-)

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

Secondary Axis as Percentage of Target - Peltier Tech Blog

Secondary Axis as Percentage of Target - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
Usually, secondary axes are confusing and cognitively butrdensome. But this tutorial shows how a secondary axis with percentages can be a good thing.
more...
No comment yet.
Scooped by Kris
Scoop.it!

Data Tables & Monte Carlo Simulations in Excel - A Comprehensive Guide

Data Tables & Monte Carlo Simulations in Excel - A Comprehensive Guide | FrankensTeam's Excel Collection | Scoop.it
If anybody asks me what is the best function in excel I am drawn between Sumproduct and Data Tables, Both make handling large amounts of data a breeze, the only thing missing is the Spandex Pants a...
Kris's insight:

I have to learn it.

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

League Manager • Excel Soccer

League Manager • Excel Soccer | FrankensTeam's Excel Collection | Scoop.it

The general variant for the Excel-Soccer Basic is a blank version and does not include any teams and matches. The other variants listed per country include the teams and matches for the specified league and season.

Kris's insight:

The ultimate Excel tool for soccer-fans!

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

Mapping relationships between people using interactive network chart

Mapping relationships between people using interactive network chart | FrankensTeam's Excel Collection | Scoop.it
Today, lets learn how to create an interesting chart. This, called as network chart helps us visualize relationships between various people. Demo of interactive
more...
No comment yet.
Scooped by Kris
Scoop.it!

Drill Up and Down on Choropleth Maps in Excel - Clearly and Simply

Drill Up and Down on Choropleth Maps in Excel - Clearly and Simply | FrankensTeam's Excel Collection | Scoop.it
Interactive drill up and down geographical hierarchies on a Choropleth Map in Microsoft Excel
Kris's insight:

Really awesome #Excel magic by Robert Mundigl.

more...
Trainedge Consulting's curator insight, June 26, 2014 2:25 AM
Interactive drill up and down geographical hierarchies on a Choropleth Map in Microsoft Excel.
Scooped by Kris
Scoop.it!

Marimekko Charts in Microsoft Excel - Clearly and Simply

Marimekko Charts in Microsoft Excel - Clearly and Simply | FrankensTeam's Excel Collection | Scoop.it
A VBA based Microsoft Excel Template to create a Marimekko Chart aka Matrix Chart aka Mosaic Chart for free download
Kris's insight:

Really good solution for a simple chart which could not be done easily in Excel.

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

Use slicers to create interactive, dynamic Excel charts and dashboards - E90E50fx

Use slicers to create interactive, dynamic Excel charts and dashboards - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Simple, innovative technique to create interactive and dynamic charts and dashboards with slicers in Excel.
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!

Highlight a Specific Data Label in an Excel Chart - Peltier Tech Blog

Highlight a Specific Data Label in an Excel Chart - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
This tutorial covers VBA and non-programmatic ways to highlight the maximum in a chart by changing the data label formatting.
more...
No comment yet.
Scooped by Kris
Scoop.it!

Digits of Pi in Excel: fomula challenge and visualization - E90E50fx

Digits of Pi in Excel: fomula challenge and visualization - E90E50fx | FrankensTeam's Excel Collection | Scoop.it

 

Formula challenge for your mind, visualization for your eyes: play with the digits of pi and find the pandigital sequence.

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

Reciprocal Chart Axis Scale - Peltier Tech Blog

Reciprocal Chart Axis Scale - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
This tutorial uses an Arrhenius plot to demonstrate construction of an axis with arbitrary scale and gridlines, ordinarily not available in Excel.
more...
No comment yet.
Scooped by Kris
Scoop.it!

Another Technique for Interactive Excel Charts

Another Technique for Interactive Excel Charts | FrankensTeam's Excel Collection | Scoop.it
Another technique to create interactive charts in Microsoft Excel using an ActiveX Label Control on top of the chart
Kris's insight:

VERY impressive !!!!

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

Chart Events in Microsoft Excel - Peltier Tech Blog

Chart Events in Microsoft Excel - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
When using a computer, you continuously interact with objects and programs through events. Here is how to use Chart Events to enhance your workbooks.
more...
Trainedge Consulting's curator insight, November 4, 2014 1:52 AM

Chart events can make it much easier for people to use your programs, and add interactivity to your charts. 

Scooped by Kris
Scoop.it!

Motion Chart Excel Template - Clearly and Simply

Motion Chart Excel Template - Clearly and Simply | FrankensTeam's Excel Collection | Scoop.it
A generic template to create Motion Charts in Microsoft Excel and 2 examples to animate La Linea episodes in Excel
Kris's insight:

Nice!

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

AJP Excel Information

AJP Excel Information | FrankensTeam's Excel Collection | Scoop.it
AJP Excel information
Kris's insight:

New design - with lot of resources, tutorials, examples.

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

Excel Waterfall Charts (Bridge Charts) - Peltier Tech Blog

Excel Waterfall Charts (Bridge Charts) - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
Waterfall charts (bridge charts) are not native to Microsoft Excel; this tutorial shows several ways to manually make waterfall charts of varying complexity.
Kris's insight:

All about waterfall charts. Approach Using Up-Down Bars is the best one.

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

World cup 2014 free Excel prediction template

World cup 2014 free Excel prediction template | FrankensTeam's Excel Collection | Scoop.it
Download English version Deutsche Version herunterladen
Kris's insight:

Well, I am not interested in football, but this tool looks really eye-catching for a lady too. I really like the ribbon tool - that is amazing!

more...
Liang_Zheng_Lin's curator insight, June 13, 2014 1:33 AM

Let the game begin!

Scooped by Kris
Scoop.it!

Stacked column flow chart with Excel - E90E50fx

Stacked column flow chart with Excel - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
New chart type in Excel: stacked column flow chart to visualize change of percentages by time.
more...
No comment yet.
Scooped by Kris
Scoop.it!

Warning For Grouped Sheets | Contextures Blog

Warning For Grouped Sheets | Contextures Blog | FrankensTeam's Excel Collection | Scoop.it
Kris's insight:

Many times it causes problems - here is solution.

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.