FrankensTeam's Excel Collection
98.4K views | +37 today
Follow
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!

Vintage charts in Excel: arrows from one point - E90E50fx

Vintage charts in Excel: arrows from one point - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Vintage chart reproduction in Excel: arrows starting from one point.
more...
No comment yet.
Scooped by Kris
Scoop.it!

Visualize Maths in Excel - E90E50fx

Visualize Maths in Excel - E90E50fx | FrankensTeam's Excel Collection | Scoop.it

 

Visualize mathematics in Excel using formulas and animated charts.
Kris's insight:

Caution! Addictive! :-)

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

3D Financial Accounts in Excel

3D Financial Accounts in Excel | FrankensTeam's Excel Collection | Scoop.it
Create multi-dimensional matrix accounts with Linked Pictures in Excel.
Kris's insight:

I really like this 3D design trick!

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

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

Merry Christmas - Buon Natale - Boldog Karácsonyt! - E90E50 fx | FrankensTeam's Excel Collection | Scoop.it
formule excel formattazione condizionale convalida formule matriciali
Kris's insight:

Merry Christmas for all Excel-fans!

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

Engineers-Excel.com: Little Man Computer

Engineers-Excel.com: Little Man Computer | FrankensTeam's Excel Collection | Scoop.it
Little Man Computer simulation in Excel...

 

A simple little game helps to understand how computers work!

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

Witch of Agnesi curve in Excel - E90E50fx

Witch of Agnesi curve in Excel - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Visualize maths in Excel: Witch of Agnesi curve animated chart
Kris's insight:

One more visualize maths chart about a funny-named curve.

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

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

Digits of Pi in Excel: fomula challenge and visualization - E90E50fx | FrankensTeam's Excel Collection | Scoop.it

 

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

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

Overachieved

Overachieved | FrankensTeam's Excel Collection | Scoop.it

Funny visualization of percentage > 100%

Kris's insight:

...and, actually, this is the logo of the collection.

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

Valentine's day - tell your love with Excel :-)

Valentine's day - tell your love with Excel :-) | FrankensTeam's Excel Collection | Scoop.it
formule excel formattazione condizionale convalida formule matriciali
Kris's insight:

Tell with a number! :-)

more...
No comment yet.
Rescooped by Kris from desktop liberation
Scoop.it!

Excel Liberation.: Plotting functions in Excel

Excel Liberation.: Plotting functions in Excel | FrankensTeam's Excel Collection | Scoop.it

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