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

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!

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!

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!

Anatomy of an Excel chart - Cosmograph dynamic version - E90E50fx

Anatomy of an Excel chart - Cosmograph dynamic version - E90E50fx | FrankensTeam's Excel Collection | Scoop.it

Here is the improved, dynamic version of cosmograph with new features - illustrated with an anatomy picture.

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 Formula Challenge - Find the pattern - E90E50 fx

Excel Formula Challenge - Find the pattern - E90E50 fx | FrankensTeam's Excel Collection | Scoop.it

It was a very interesting challenge!

You can learn about how to use matrixes and some other tricks about Excel formulas... My personal favourite is the beautiful and easy way to cut the decimal part of a number with the help of MOD!

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!

SUM by color: Calculate when color changed

SUM by color: Calculate when color changed | FrankensTeam's Excel Collection | Scoop.it
Trigger calculation when color or other formatting changed.
more...
Progressive training's curator insight, November 25, 2013 11:21 AM

SUM by color: Calculate when color changed

Scooped by Kris
Scoop.it!

Edward Tufte's Slopegraphs in Excel - E90E50fx

Edward Tufte's Slopegraphs in Excel - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
One of the strengths of Tufte's graph (perhaps the most important) is that we can immediately read the ranking of both the data.
Kris's insight:

Easy-to-use dynamic solution.

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!

MMULT again - useful! - E90E50 fx

MMULT again - useful! - E90E50 fx | FrankensTeam's Excel Collection | Scoop.it

Summarize monthly data into quarters.

 

more...
brucemcpherson's curator insight, June 27, 2013 6:31 PM

Mmult in excel is one of a little used but very powerful set of functions. People have trouble grasping array based functions. On  their  site, krisztina and roberto continue to come up with practical and easy to understand applications for these useful functions. Highly recommended.

Scooped by Kris
Scoop.it!

Array of ranges using OFFSET formula - with examples - E90E50 fx

Array of ranges using OFFSET formula - with examples - E90E50 fx | FrankensTeam's Excel Collection | Scoop.it

Interesting solutions with OFFSET formula.

more...
No comment yet.