FrankensTeam's Ex...
Follow
Find tag "ingenious"
49.9K views | +2 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!

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!

The Advanced Chart Utility Is Here - Peltier Tech Blog

The Advanced Chart Utility Is Here - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it

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.

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

Another approach to plotting gaps in Excel charts - Peltier Tech Blog

Another approach to plotting gaps in Excel charts - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
Roberto Mensa and his team have proposed a UDF alternative to Jon's recent VBA approaches to plot gaps in Excel charts.
Kris's insight:

Our guest post!

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

Anatomy of an Excel chart - Cosmograph dynamic version - E90E50fx

Anatomy of an Excel chart - Cosmograph dynamic version - E90E50fx | FrankensTeam's Excel Collection | Scoop.it

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

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

Stacking Cubes Charts with Excel - E90E50fx

Stacking Cubes Charts with Excel - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
stacking cubes columns bar and matrix charts with Microsoft excel
Kris's insight:

Toys and charts :-)

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

Excel Formula Challenge - Find the pattern - E90E50 fx

Excel Formula Challenge - Find the pattern - E90E50 fx | FrankensTeam's Excel Collection | Scoop.it

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!

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

Interactive United States 2012 Presidential Scoreboard in Excel | OPTION EXPLICIT VBA

Interactive United States 2012 Presidential Scoreboard in Excel | OPTION EXPLICIT VBA | FrankensTeam's Excel Collection | Scoop.it

Take a look at this fantastic tool and play with the results of the US Presidential Election!

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

OPTION EXPLICIT VBA

OPTION EXPLICIT VBA | FrankensTeam's Excel Collection | Scoop.it
A blog about Excel, spreadsheets, dashboards, data, and other fun stuff.

On this great site I found a fantastic Interactive Map using mouse rollover technique! Really worth to see!

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

HR Dashboard Gantt Chart / Traffic Light Report | xlcalibre.com

HR Dashboard Gantt Chart / Traffic Light Report | xlcalibre.com | FrankensTeam's Excel Collection | Scoop.it
This Excel HR dashboard tool is several things: a Gantt chart and a RAG / Traffic Light report, that can be viewed by date, week or month.

I really like the scroll bars on the sheet!

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

Combine Bubble and xy scatter line chart - E90E50fx

Combine Bubble and xy scatter line chart - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Combine bubble and xy scatter line chart in excel - the trick is to use trendline
Kris's insight:

Useful, simple and ingenious idea!!

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

Talent traffic chart with chord diagram in Excel - E90E50fx

Talent traffic chart with chord diagram in Excel - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
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.

more...
Scooped by Kris
Scoop.it!

Cosmograph in Excel - World migration with bilateral flow chart - E90E50fx

Cosmograph in Excel - World migration with bilateral flow chart - E90E50fx | FrankensTeam's Excel Collection | Scoop.it

Take a look at this fantastic visual result!

Kris's insight:

Unbelievable that this chart could be done in Excel!

more...
Oz du Soleil's comment, September 23, 2013 2:48 PM
I've seen this before but I think it had been built in R. It's great to know that this is yet one more thing that Excel can handle.
Scooped by Kris
Scoop.it!

Stacked and separated dynamic Excel charts - E90E50fx

Stacked and separated dynamic Excel charts - E90E50fx | FrankensTeam's Excel Collection | Scoop.it

This dynamic solution serves both visualization needs: compare the total and compare the categories too.

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

Excel Birthday Candles - Chart :-)

Excel Birthday Candles - Chart :-) | FrankensTeam's Excel Collection | Scoop.it

by The FrankensTeam

http://goo.gl/OvWz2

Kris's insight:

Something funny to play with.

more...
brucemcpherson's curator insight, June 5, 2013 7:38 AM

If you are interested in Extreme excel, just for fun stuff, I recommend the material on this site -  really inventive application of excel capabilities.

Scooped by Kris
Scoop.it!

Combinatorics using Excel formulas - E90E50 fx

Combinatorics using Excel formulas - E90E50 fx | FrankensTeam's Excel Collection | Scoop.it

How to use Excel formulas in the field of Enumerative Combinatorics. Deteiled explanation with illustrative examples.

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

Excel Dynamic Data Validation Lists

Excel Dynamic Data Validation Lists | FrankensTeam's Excel Collection | Scoop.it
Create a data validation list that is dependent on another list using formulas that dynamically update when the source data changes.

 

Easy-to-use data validation. The formula is complex, but you can easily use the file! :-)

And there is a great trick with ! for advanced users :-)

more...
Oz du Soleil's curator insight, March 7, 2013 11:29 AM

Dependent and dynamic dropdown lists in Excel are so valuable in controlling inputs and keeping your source data clean.

Scooped by Kris
Scoop.it!

E90E50 fx - Solo formule Excel

E90E50 fx - Solo formule Excel | FrankensTeam's Excel Collection | Scoop.it

The greatest formula-savant Roberto Mensa's site where you can see great examples how to do the impossible in Excel!

 

In queste pagine troverai le migliori formule di Excel, cercate nel web, lette, discusse o inventate.

more...
No comment yet.