FrankensTeam's Ex...
tag "inspiring"
67.4K views | +23 today

# FrankensTeam's Excel Collection

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

## Meeting in Milano, trip to the Alps and an Excel chart - E90E50fx

FrankensTeam meeting in Milano, Alps Excel chart
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

## E90E50charts - Excel Charts Gallery

Microsoft Excel charts and data visualization tools
Kris's insight:

Excel chart gallery opened. We would be happy if write your comments in the Visitor's book.

Oz du Soleil's curator insight,

Check out these unique and interesting Excel charts. And be sure to comment in the visitor's book.

 Rescooped by Kris from desktop liberation

## Excel Liberation.: Plotting functions in Excel

Excel doesn't really know how to create a function plot. It generally needs you to create a table of data, that can then be plotted. However, thanks to the use of array functions, named ranges, the old excel evaluate function, and some tweaking (as described in an  informit article by Rob Bovey, Stephen Bullen, and John Green), I was able to create a plotter for formulas that doesn't need any data or any VBA.

Here's the first one, generated from these parameters

y= (SQRT(COS(x))*COS(200 *x)+SQRT(ABS(x))-0.7)*(4-x*x)^0.01
x from -1.57
x to 1.57
no of points 10000

You can download this from the funny charts worksheet of the cDataSet.xlsm workbook.at http://ramblings.mcpher.com/Home/excelquirks/downlable-items

Via brucemcpherson
No comment yet.
 Suggested by Dude

## Chandoo.org - Learn Microsoft Excel Online

Learn Microsoft Excel Online. Every day we post fresh Excel Tips, Tricks, Charts, Formula Examples, Tutorials, Downloads, Dashboards, Templates and Visualizations for your Inspiration, Success and Productivity.
No comment yet.
 Scooped by Kris

## A comprehensive guide to Number Formats in Excel

A great tutorial form Jon von der Heyden. You will be surprised how many formatting possibilities could be done with Custom format!

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

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

## Merry Christmas - Buon Natale - Boldog Karácsonyt! - E90E50 fx

formule excel formattazione condizionale convalida formule matriciali
Kris's insight:

Merry Christmas for all Excel-fans!

No comment yet.
 Scooped by Kris

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

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

No comment yet.
 Scooped by Kris