FrankensTeam's Excel Collection
122.0K views | +57 today

# FrankensTeam's Excel Collection

Useful, interesting and funny Excel stuff
Curated by Kris
 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

## Formula challenge: SUMIF from more sheets - E90E50fx

Sumif from multiple sheets using excel formula
No comment yet.
 Scooped by Kris

## Talent traffic chart with chord diagram in Excel - E90E50fx

Talent traffic chart with chord diagram in Excel
Kris's insight:

It was a great team-work to develop and improve this brand-new Excel chart.

brucemcpherson's curator insight,

wow..

 Scooped by Kris

## Anatomy of an Excel chart - Cosmograph dynamic version - E90E50fx

Here is the improved, dynamic version of cosmograph with new features - illustrated with an anatomy picture.

No comment yet.
 Scooped by Kris

## Stacking Cubes Charts with Excel - E90E50fx

stacking cubes columns bar and matrix charts with Microsoft excel
Kris's insight:

Toys and charts :-)

No comment yet.
 Scooped by Kris

## Magic carpet in Excel

Kris's insight:

Here you can find a video: http://youtu.be/nqF3-IyXk6s

No comment yet.
 Scooped by Kris

## Square chart and Treemap in Excel

No comment yet.
 Scooped by Kris

## Excel Formula Challenge - Find the pattern - E90E50 fx

It was a very interesting challenge!

You can learn about how to use matrixes and some other tricks about Excel formulas... My personal favourite is the beautiful and easy way to cut the decimal part of a number with the help of MOD!

No comment yet.
 Scooped by Kris

## Formula challenge: create a list of sheet names based on a prefix - E90E50fx

formula to create a list of sheet names based on prefix without VBA
Kris's insight:

A really interesting formula solution to list sheet names based on a rule. Learn our tricks. :-)

No comment yet.
 Scooped by Kris

## Our enormous ... 2013 - E90E50fx

Summary of The FrankensTeam's unique Excel work in year 2013
No comment yet.
 Scooped by Kris

## SUM by color: Calculate when color changed

Trigger calculation when color or other formatting changed.
Progressive training's curator insight,

SUM by color: Calculate when color changed

 Scooped by Kris

## Edward Tufte's Slopegraphs in Excel - E90E50fx

One of the strengths of Tufte's graph (perhaps the most important) is that we can immediately read the ranking of both the data.
Kris's insight:

Easy-to-use dynamic solution.

No comment yet.
 Scooped by Kris

## Excel data validation with on-the-fly update without VBA

Hierarchical dynamic validation list with a plus: type the name of new element if you do not find it. It will be part of the list immediately!

Progressive training's curator insight,

Excel data validation with on-the-fly update without VBA

#microsoft #excel #training

 Scooped by Kris

## MMULT again - useful! - E90E50 fx

Summarize monthly data into quarters.

brucemcpherson's curator insight,

Mmult in excel is one of a little used but very powerful set of functions. People have trouble grasping array based functions. On  their  site, krisztina and roberto continue to come up with practical and easy to understand applications for these useful functions. Highly recommended.

 Scooped by Kris

## Array of ranges using OFFSET formula - with examples - E90E50 fx

Interesting solutions with OFFSET formula.

No comment yet.