FrankensTeam's Ex...
58.0K views | +22 today

 Scooped by Kris onto FrankensTeam's Excel Collection

Insert hyperlinks in Excel with data validation lists and and spin buttons.
No comment yet.

# FrankensTeam's Excel Collection

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

## Area chart with levels - Excel-Croissant - E90E50fx

Excel area chart to visualize small and large values
Kris's insight:

Area-levels chart in #Excel

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

## DATEDIF Worksheet Function

Kris's insight:

Very useful, but very hidden Excel function!

No comment yet.
 Scooped by Kris

## How to copy charts based on named formulas to other workbook? - E90E50fx

Copy and use Excel charts based on named formulas from example file to your own workbook.
Kris's insight:

It will be very useful for those who would like to use our downloadable example charts in their own files!

No comment yet.
 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

## Convert numbers to words with Excel formula - language collection - E90E50fx

Convert numbers to words with Excel formula: Italian, English, Hungarian

Kris's insight:

Do you have formulas for other languages? Please share!

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

## Excel PivotTable Field List Can Float!

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

No comment yet.
 Scooped by Kris

## Trendline formatting bug in Excel 2013 and the secret of The FrankensTeam - E90E50fx

A small bug in Excel 2013.

No comment yet.
 Scooped by Kris

## Vintage charts in Excel: arrows from one point - E90E50fx

Vintage chart reproduction in Excel: arrows starting from one point.
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

## 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:

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

## Free Org Chart Add In - Beyond Excel

Kris's insight:

With professional documentation!

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

## Excel PowerPivot PivotTable Named Sets

Excel PivotTable Named Sets enable you to pick and choose which column or row labels to include in your PivotTable reports.
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

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

## Set Row Height With REPT Function « Contextures Blog

Kris's insight:

I really like this great idea! Very useful!

No comment yet.
 Scooped by Kris

## Combine Bubble and xy scatter line chart - E90E50fx

Combine bubble and xy scatter line chart in excel - the trick is to use trendline
Kris's insight:

Useful, simple and ingenious idea!!

No comment yet.
 Scooped by Kris

## Vintage charts in Excel: bar chart with highlight - E90E50fx

Nicely formatted vintage bar chart in Excel with highlighted data.
Kris's insight:

Easy vintage chart reproduction with some formatting.

No comment yet.
 Scooped by Kris

## Plot Excel Data in an Interactive Bing Map

If you don’t have Excel 2013 then this post will be a bit like window shopping with an empty wallet. You get to try stuff on and test drive it, you just don’t get to take it home. Window shopping
No comment yet.
 Scooped by Kris

## The Advanced Chart Utility Is Here - Peltier Tech Blog

The Peltier Tech Chart Utility has a new Advanced Edition, which nearly doubles the capabilities of the Standard Edition.

Kris's insight:

Great tool! It makes very easy to create lots of clear, useful business charts.

No comment yet.