FrankensTeam's Excel Collection
96.5K views | +132 today

# FrankensTeam's Excel Collection

Useful, interesting and funny Excel stuff
Curated by Kris
 Scooped by Kris

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

Use Slicer to select value field, measure for Pivot table or PowerPivot
Kris's insight:
Do you like this trick?
No comment yet.
 Scooped by Kris

## Export Excel Dashboards (Improved Version)

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

Very useful tool!

No comment yet.
 Scooped by Kris

## Selecting and Highlighting Areas on Excel Charts

Interactive Selecting and Highlighting Areas on an Map or an XY Scatter Chart in Microsoft Excel
Kris's insight:

Really it's magic! :-)

No comment yet.
 Scooped by Kris

## Secondary Axis as Percentage of Target - Peltier Tech Blog

Usually, secondary axes are confusing and cognitively butrdensome. But this tutorial shows how a secondary axis with percentages can be a good thing.
No comment yet.
 Scooped by Kris

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

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.

No comment yet.
 Scooped by Kris

## League Manager • Excel Soccer

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!

No comment yet.
 Scooped by Kris

## Mapping relationships between people using interactive network chart

Today, lets learn how to create an interesting chart. This, called as network chart helps us visualize relationships between various people. Demo of interactive
No comment yet.
 Scooped by Kris

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

Interactive drill up and down geographical hierarchies on a Choropleth Map in Microsoft Excel
Kris's insight:

Really awesome #Excel magic by Robert Mundigl.

Trainedge Consulting's curator insight,
Interactive drill up and down geographical hierarchies on a Choropleth Map in Microsoft Excel.
 Scooped by Kris

## Marimekko Charts in Microsoft Excel - Clearly and Simply

Kris's insight:

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

No comment yet.
 Scooped by Kris

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

Simple, innovative technique to create interactive and dynamic charts and dashboards with slicers in Excel.
No comment yet.
 Scooped by Kris

## Pivottable slicers Excel 2010: Synchonising Slicers

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

Useful for practice!

No comment yet.
 Scooped by Kris

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

This tutorial covers VBA and non-programmatic ways to highlight the maximum in a chart by changing the data label formatting.
No comment yet.
 Scooped by Kris

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

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

No comment yet.
 Scooped by Kris

## Zooming in and out of Excel Charts

Interactive zooming in and out on Charts in Microsoft Excel
No comment yet.
 Scooped by Kris

## Reciprocal Chart Axis Scale - Peltier Tech Blog

This tutorial uses an Arrhenius plot to demonstrate construction of an axis with arbitrary scale and gridlines, ordinarily not available in Excel.
No comment yet.
 Scooped by Kris

## Another Technique for Interactive Excel Charts

Another technique to create interactive charts in Microsoft Excel using an ActiveX Label Control on top of the chart
Kris's insight:

VERY impressive !!!!

No comment yet.
 Scooped by Kris

## Chart Events in Microsoft Excel - Peltier Tech Blog

When using a computer, you continuously interact with objects and programs through events. Here is how to use Chart Events to enhance your workbooks.
Trainedge Consulting's curator insight,

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

 Scooped by Kris

## Motion Chart Excel Template - Clearly and Simply

A generic template to create Motion Charts in Microsoft Excel and 2 examples to animate La Linea episodes in Excel
Kris's insight:

Nice!

No comment yet.
 Scooped by Kris

## AJP Excel Information

AJP Excel information
Kris's insight:

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

No comment yet.
 Scooped by Kris

## Excel Waterfall Charts (Bridge Charts) - Peltier Tech Blog

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.

No comment yet.
 Scooped by Kris

## World cup 2014 free Excel prediction template

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!

Liang_Zheng_Lin's curator insight,

Let the game begin!

 Scooped by Kris

## Stacked column flow chart with Excel - E90E50fx

New chart type in Excel: stacked column flow chart to visualize change of percentages by time.
No comment yet.
 Scooped by Kris

## Warning For Grouped Sheets | Contextures Blog

Kris's insight:

Many times it causes problems - here is solution.

No comment yet.
 Scooped by Kris

## The Venerable SUMPRODUCT - Excel Hero Blog

Kris's insight:

One of the most useful formulas of Excel.

No comment yet.
 Scooped by Kris

## Calculated Field vs Calculated Item

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.

No comment yet.