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

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!

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

Developing Faster Lookups - Binary Search with missing data

Developing Faster Lookups - Binary Search with missing data | FrankensTeam's Excel Collection | Scoop.it

"When profiling Excel workbook calculation time I often find that Lookups are one of the main causes of performance problems."

 

My favourite technique I teach to my colleagues too is the Binary Search with missing data solution. Very effective and not difficult to use!

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

Excel - Hyperlink to a dynamic range - E90E50 fx

Excel - Hyperlink to a dynamic range - E90E50 fx | FrankensTeam's Excel Collection | Scoop.it

How to select hyperlink from validation list? Easy!

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

How to Create a Panel Chart in Excel « Contextures Blog

How to Create a Panel Chart in Excel « Contextures Blog | FrankensTeam's Excel Collection | Scoop.it

It shows all the data in a single chart, with vertical lines separating the groups. Easy!

more...
Oz du Soleil's comment, January 17, 2013 12:47 PM
LOVE THIS! I have something in mind already.
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.
Scooped by Kris
Scoop.it!

HR Dashboard Gantt Chart / Traffic Light Report | xlcalibre.com

HR Dashboard Gantt Chart / Traffic Light Report | xlcalibre.com | FrankensTeam's Excel Collection | Scoop.it
This Excel HR dashboard tool is several things: a Gantt chart and a RAG / Traffic Light report, that can be viewed by date, week or month.

I really like the scroll bars on the sheet!

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

4 Ways To Avoid Krampus & Crap Data in 2013 - DataScopic

4 Ways To Avoid Krampus & Crap Data in 2013 - DataScopic | FrankensTeam's Excel Collection | Scoop.it

2013 is the year to handle the crap data hurt our businesses. Here are 4 steps to getting insight and peace.

Kris's insight:

I like it: "Data-scrubbing isn’t a data-entry level skill."

more...
Oz du Soleil's comment, January 15, 2013 4:45 PM
Kris and Roger, thanks for sharing. This was a fun one to write, and I'm glad you liked it. :-) Let's keep our data clean.
Scooped by Kris
Scoop.it!

«Excel formula to change the value of another cell?» ... «It - could - work!» - E90E50

How to use UDF to do "illegal" things? - for experimental use only

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

Tangled chart with Excel - E90E50 fx

Tangled chart with Excel - E90E50 fx | FrankensTeam's Excel Collection | Scoop.it

This ingenious chart is the most-liked post in the Excel Hero group!

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

Improving the Default Percent Formatting » Bacon Bits

Improving the Default Percent Formatting » Bacon Bits | FrankensTeam's Excel Collection | Scoop.it

Good idea with the triangles! Great example how to use the custom format described also in the tutorial posted above.

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!

Allow Auto-Fill-Formulas in a Protected Table

A VBA class for enabling formula autofill behaviour for a list/table in a protected sheet.

 

An essential code if you would like to use the great autofill feature of tables while you protect your sheet.

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

A comprehensive guide to Number Formats in Excel

A comprehensive guide to Number Formats in Excel | FrankensTeam's Excel Collection | Scoop.it

A great tutorial form Jon von der Heyden. You will be surprised how many formatting possibilities could be done with Custom format!

more...
No comment yet.