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

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!

How to sum the product of matrix or array rows? - E90E50fx

How to sum the product of matrix or array rows? - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Excel formula trick to sum product of matrix elements by rows using logarithm
Kris's insight:

Great mathematical trick in Excel formula.

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

Formula challenge: create a list of sheet names based on a prefix - E90E50fx

Formula challenge: create a list of sheet names based on a prefix - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
formula to create a list of sheet names based on prefix without VBA
Kris's insight:

A really interesting formula solution to list sheet names based on a rule. Learn our tricks. :-)

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!

Arrow chart with tangle in critical step - E90E50 fx

Arrow chart with tangle in critical step - E90E50 fx | FrankensTeam's Excel Collection | Scoop.it

Do you like our funny charts?

Kris's insight:

Dynamic critical step charts - what do you think about it?

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!

E90E50

E90E50 | FrankensTeam's Excel Collection | Scoop.it

The new content page of our sites!

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

Formula challenge: SUMIF from more sheets - E90E50fx

Formula challenge: SUMIF from more sheets - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Sumif from multiple sheets using excel formula
more...
No comment yet.
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!

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.