FrankensTeam's Ex...
Follow
Find
24.0K views | +99 today
Scooped by Kris
onto FrankensTeam's Excel Collection
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.
FrankensTeam's Excel Collection
Useful, interesting and funny Excel stuff
Curated by Kris
Your new post is loading...
Scooped by Kris
Scoop.it!

Excel Chart Templates

Excel Chart Templates | FrankensTeam's Excel Collection | Scoop.it
Setting up a custom Excel chart templates can save you loads of time. If there’s a chart you use often you can also set it up as the default chart.
Kris's insight:

How to use Excel chart templates.

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

The Venerable SUMPRODUCT - Excel Hero Blog

The Venerable SUMPRODUCT - Excel Hero Blog | FrankensTeam's Excel Collection | Scoop.it
Kris's insight:

One of the most useful formulas of Excel.

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!

Do you like what you find here?

Do you like what you find here? | FrankensTeam's Excel Collection | Scoop.it

 

Do you know there is a thumb-up button bellow each posts? You can sign if you like/find useful what you found here.

Thank you! :-)

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!

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 7:14 AM

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

Scooped by Kris
Scoop.it!

Excel Pivot Table Tutorial -- GetPivotData

Excel Pivot Table Tutorial -- GetPivotData | FrankensTeam's Excel Collection | Scoop.it

The basics of Getpivotdata.

Kris's insight:

In my practice, Getpivotdata is very-very useful for building reports.

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

Another approach to plotting gaps in Excel charts - Peltier Tech Blog

Another approach to plotting gaps in Excel charts - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
Roberto Mensa and his team have proposed a UDF alternative to Jon's recent VBA approaches to plot gaps in Excel charts.
Kris's insight:

Our guest post!

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

storytelling with data: a little math on non-zero baselines

storytelling with data: a little math on non-zero baselines | FrankensTeam's Excel Collection | Scoop.it

Considerations about chart scaling and baseline.

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

Multiple lines across categories - simple step by step guide - E90E50fx

Multiple lines across categories - simple step by step guide - E90E50fx | FrankensTeam's Excel Collection | Scoop.it

Use different data structures to create this chart: step-by-step tutorial.

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

Rotate chart label VBA - E90E50

Rotate chart label VBA - E90E50 | FrankensTeam's Excel Collection | Scoop.it
Excel pie, doughnut or radar chart: rotate all labels to radial or tangential direction with VBA
more...
No comment yet.
Scooped by Kris
Scoop.it!

Calendar Control for All Office versions - including Office 2010 64 bit - E90E50

Calendar Control for All Office versions - including Office 2010 64 bit - E90E50 | FrankensTeam's Excel Collection | Scoop.it

The universal Calendar Control can not miss from this collection. Check the Updates section for more features and usage examples.

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

Quickly combine text in multiple cells using this trick! [Formulas] | Chandoo.org - Learn Microsoft Excel Online

Quickly combine text in multiple cells using this trick! [Formulas] | Chandoo.org - Learn Microsoft Excel Online | FrankensTeam's Excel Collection | Scoop.it
Ever wondered how to go from a bunch of cells with text to one big combined text? Like shown above. Well, there is a simple trick. One of our readers, Grant shared this with us. Read on to learn this.
more...
No comment yet.
Scooped by Kris
Scoop.it!

Pivottable slicers Excel 2010: Synchonising Slicers

Article about using Pivottable slicers in Excel 2010; Synchonising slicers
Kris's insight:

Useful for practice!

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

Highlight a Specific Data Label in an Excel Chart - Peltier Tech Blog

Highlight a Specific Data Label in an Excel Chart - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
This tutorial covers VBA and non-programmatic ways to highlight the maximum in a chart by changing the data label formatting.
more...
No comment yet.
Scooped by Kris
Scoop.it!

Calculated Field vs Calculated Item

Calculated Field vs Calculated Item | FrankensTeam's Excel Collection | Scoop.it

After you create a pivot table, you can enhance the results by writing your own formulas, to create calculated fields and calculated items.

Kris's insight:

Great summary and examples.

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

FrankensTeam was mentioned in Excel TV! - E90E50fx

FrankensTeam was mentioned in Excel TV! - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Excel TV - a series about Excel tips, news and brain teasers with special guests. In episode 3 our FrankensTeam was mentioned.
more...
No comment yet.
Scooped by Kris
Scoop.it!

Dot Plots in Microsoft Excel - Peltier Tech Blog

Dot Plots in Microsoft Excel - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
Microsoft Excel doesn't have a native Dot Plot chart type. But you can build your own following these simple instructions.
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!

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!

An Investigation into the Performance of Excel

An set of articles into mememory use, timing and multithreading in Excel
Kris's insight:

Very useful stuff to understand how things work in the dark depth of Excel. :-)

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

Robust Dynamic (Cascading) Dropdowns Without VBA | Chandoo.org - Learn Microsoft Excel Online

Robust Dynamic (Cascading) Dropdowns Without VBA | Chandoo.org - Learn Microsoft Excel Online | FrankensTeam's Excel Collection | Scoop.it
Find out how to set up cascading dynamic dropdowns using Excel's Data Validation that users must manually clear if they later make changes - without VBA
Kris's insight:

Solution with only one named formula.

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

Customer segmentation - dynamic template chart - E90E50fx

Customer segmentation - dynamic template chart - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
customer segmentation dynamic Excel chart
more...
No comment yet.
Scooped by Kris
Scoop.it!

Combine pie and xy scatter charts - Advanced Excel Charting Example | Chandoo.org - Learn Microsoft Excel Online

Combine pie and xy scatter charts - Advanced Excel Charting Example | Chandoo.org - Learn Microsoft Excel Online | FrankensTeam's Excel Collection | Scoop.it
Few days ago, we learned how to create a pie+donut combination chart to visualize polls around the world in 2014. It generated quite a bit of interesting discussion (47 comments so far). One of the comments was from Roberto, who along with Kris & Gábor runs The FrankensTeam an online library of advanced Excel tricks, charts and other mind-boggling spreadsheet wizardry. I really liked Roberto's comments on the original post and a charting solution he presented. So I asked him if he can do a guest post explaining the technique to our audience. He obliged and here we go. Over to FrankensTeam.
more...
No comment yet.
Scooped by Kris
Scoop.it!

WorldWide Telescope 5.0 und Excel Add-In - Excel Ticker

WorldWide Telescope 5.0 und Excel Add-In - Excel Ticker | FrankensTeam's Excel Collection | Scoop.it
Kris's insight:

Sounds interesting!!

more...
No comment yet.