FrankensTeam's Ex...
Follow
Find tag "advanced"
37.6K views | +19 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!

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!

Mapping relationships between people using interactive network chart

Mapping relationships between people using interactive network chart | FrankensTeam's Excel Collection | Scoop.it
Today, lets learn how to create an interesting chart. This, called as network chart helps us visualize relationships between various people. Demo of interactive
more...
No comment yet.
Scooped by Kris
Scoop.it!

Drill Up and Down on Choropleth Maps in Excel - Clearly and Simply

Drill Up and Down on Choropleth Maps in Excel - Clearly and Simply | FrankensTeam's Excel Collection | Scoop.it
Interactive drill up and down geographical hierarchies on a Choropleth Map in Microsoft Excel
Kris's insight:

Really awesome #Excel magic by Robert Mundigl.

more...
Trainedge Consulting's curator insight, June 26, 2:25 AM
Interactive drill up and down geographical hierarchies on a Choropleth Map in Microsoft Excel.
Scooped by Kris
Scoop.it!

Marimekko Charts in Microsoft Excel - Clearly and Simply

Marimekko Charts in Microsoft Excel - Clearly and Simply | FrankensTeam's Excel Collection | Scoop.it
A VBA based Microsoft Excel Template to create a Marimekko Chart aka Matrix Chart aka Mosaic Chart for free download
Kris's insight:

Really good solution for a simple chart which could not be done easily in Excel.

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

Use slicers to create interactive, dynamic Excel charts and dashboards - E90E50fx

Use slicers to create interactive, dynamic Excel charts and dashboards - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Simple, innovative technique to create interactive and dynamic charts and dashboards with slicers in Excel.
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!

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!

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!

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!

Matrix bubble chart with conditional formatting - E90E50fx

Matrix bubble chart with conditional formatting - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Excel matrix bubble chart with conditional formatting - change the rules according to your needs.
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!

AJP Excel Information

AJP Excel Information | FrankensTeam's Excel Collection | Scoop.it
AJP Excel information
Kris's insight:

New design - with lot of resources, tutorials, examples.

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

Excel Waterfall Charts (Bridge Charts) - Peltier Tech Blog

Excel Waterfall Charts (Bridge Charts) - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
Waterfall charts (bridge charts) are not native to Microsoft Excel; this tutorial shows several ways to manually make waterfall charts of varying complexity.
Kris's insight:

All about waterfall charts. Approach Using Up-Down Bars is the best one.

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, 1:33 AM

Let the game begin!

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!

Warning For Grouped Sheets | Contextures Blog

Warning For Grouped Sheets | Contextures Blog | FrankensTeam's Excel Collection | Scoop.it
Kris's insight:

Many times it causes problems - here is solution.

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!

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!

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!

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!

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!

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.