FrankensTeam's Excel Collection
113.1K views | +1 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!

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

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

Excel data validation with on-the-fly update without VBA | FrankensTeam's Excel Collection | Scoop.it

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!

more...
Progressive training's curator insight, November 19, 2013 12:50 PM

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

 

#microsoft #excel #training 

 

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!

Filter Excel Tables by Double Clicking - Clearly and Simply

Filter Excel Tables by Double Clicking - Clearly and Simply | FrankensTeam's Excel Collection | Scoop.it
How to set the active cell’s value as the filter criteria in Microsoft Excel Tables by double clicking...

Very useful technic developed in a really user-friendly way! I add it to my Excel and will use in my daily work!

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!

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.
Scooped by Kris
Scoop.it!

World cup 2014 free Excel prediction template

World cup 2014 free Excel prediction template | FrankensTeam's Excel Collection | Scoop.it
Download English version Deutsche Version herunterladen
Kris's insight:

Well, I am not interested in football, but this tool looks really eye-catching for a lady too. I really like the ribbon tool - that is amazing!

more...
Liang_Zheng_Lin's curator insight, June 13, 2014 1:33 AM

Let the game begin!

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!

Excel VLOOKUP Multiple Sheets

Excel VLOOKUP Multiple Sheets | FrankensTeam's Excel Collection | Scoop.it
Use an array formula to VLOOKUP multiple worksheets.

Very good and useful idea!

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!

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!

Introducing… the Calendar Chart! « PowerPivotPro

Introducing… the Calendar Chart! « PowerPivotPro | FrankensTeam's Excel Collection | Scoop.it

Brilliant Calendar Chart solution, must see and must try! Really amazing!

more...
No comment yet.