FrankensTeam's Ex...
Follow
Find tag "inspiring"
51.9K views | +14 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!

Motion Chart Excel Template - Clearly and Simply

Motion Chart Excel Template - Clearly and Simply | FrankensTeam's Excel Collection | Scoop.it
A generic template to create Motion Charts in Microsoft Excel and 2 examples to animate La Linea episodes in Excel
Kris's insight:

Nice!

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!

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!

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!

Excel Hero | LinkedIn

Excel Hero | LinkedIn | FrankensTeam's Excel Collection | Scoop.it

"Associate with people who are likely to improve you."
— Seneca

 

Come and read our discussions on LinkedIn or join our group and post your questions! The best Excel minds will be honoured to answer you!

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

E90E50charts - Excel Charts Gallery

E90E50charts - Excel Charts Gallery | FrankensTeam's Excel Collection | Scoop.it
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.

 

more...
Oz du Soleil's curator insight, July 31, 2013 10:14 AM

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

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.
Suggested by Dude
Scoop.it!

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.
more...
No comment yet.
Scooped by Kris
Scoop.it!

A comprehensive guide to Number Formats in Excel

A comprehensive guide to Number Formats in Excel | FrankensTeam's Excel Collection | Scoop.it

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

more...
No comment yet.