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

Use Slicer to select value fields for Pivot table or PowerPivot! - E90E50fx

Use Slicer to select value fields for Pivot table or PowerPivot! - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Use Slicer to select value field, measure for Pivot table or PowerPivot
Kris's insight:
Do you like this trick?
more...
No comment yet.
Scooped by Kris
Scoop.it!

Export Excel Dashboards (Improved Version)

An improved version of the example workbook exporting Excel Dashboards to other applications
Kris's insight:

Very useful tool!

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

Another Technique for Interactive Excel Charts

Another Technique for Interactive Excel Charts | FrankensTeam's Excel Collection | Scoop.it
Another technique to create interactive charts in Microsoft Excel using an ActiveX Label Control on top of the chart
Kris's insight:

VERY impressive !!!!

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

Chart Events in Microsoft Excel - Peltier Tech Blog

Chart Events in Microsoft Excel - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
When using a computer, you continuously interact with objects and programs through events. Here is how to use Chart Events to enhance your workbooks.
more...
Trainedge Consulting's curator insight, November 4, 2014 1:52 AM

Chart events can make it much easier for people to use your programs, and add interactivity to your charts. 

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, 2014 2:25 AM
Interactive drill up and down geographical hierarchies on a Choropleth Map in Microsoft Excel.
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, 2014 1:33 AM

Let the game begin!

Scooped by Kris
Scoop.it!

Link Excel Chart Axis Scale to Values in Cells - Peltier Tech Blog

Link Excel Chart Axis Scale to Values in Cells - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
This tutorial shows examples of code to update an Excel chart's axis scales on demand or on worksheet changes, using scale parameters from worksheet cells.
Kris's insight:

Frequently needed!

more...
No comment yet.
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!

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!

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!

Merge Excel Worksheets with VBA

Merge Excel Worksheets with VBA | FrankensTeam's Excel Collection | Scoop.it
Merge Excel worksheets quickly and easily using a little VBA code
Kris's insight:

Solution for a frequently asked question.

more...
Laurent Kaddouch's curator insight, October 14, 2013 10:10 AM

Ofadis vous suggère cet article (suivez une formation pour être développeur excel VBA)

Scooped by Kris
Scoop.it!

Find numbers that add up to a certain number - E90E50 fx

Find numbers that add up to a certain number - E90E50 fx | FrankensTeam's Excel Collection | Scoop.it

It is possible with formulas too!

The file ProcedurabyHarlenGrove.xlsm with great VBA code could be downloaded.

Kris's insight:

It was a huge help two times in the last week, so I share it here - in the future I will always find it! :-)

more...
roberto mensa's comment, July 11, 2013 4:32 AM
good picture!
Scooped by Kris
Scoop.it!

Selecting and Highlighting Areas on Excel Charts

Selecting and Highlighting Areas on Excel Charts | FrankensTeam's Excel Collection | Scoop.it
Interactive Selecting and Highlighting Areas on an Map or an XY Scatter Chart in Microsoft Excel
Kris's insight:

Really it's magic! :-)

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

Motion Chart Excel Template - Clearly and Simply

Motion Chart Excel Template - Clearly and Simply | FrankensTeam's Excel Collection | Scoop.it
A generic template to create Motion Charts in Microsoft Excel and 2 examples to animate La Linea episodes in Excel
Kris's insight:

Nice!

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

The Advanced Chart Utility Is Here - Peltier Tech Blog

The Advanced Chart Utility Is Here - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it

The Peltier Tech Chart Utility has a new Advanced Edition, which nearly doubles the capabilities of the Standard Edition.

Kris's insight:

Great tool! It makes very easy to create lots of clear, useful business charts.

more...
Scooped by Kris
Scoop.it!

Generate QR code with google chart API using UDF in Excel - E90E50fx

Generate QR code with google chart API using UDF in Excel - E90E50fx | FrankensTeam's Excel Collection | Scoop.it

Generate QR code with google chart API using UDF in Excel

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

Pivot-like Marimekko Charts in Excel - Clearly and Simply

Pivot-like Marimekko Charts in Excel - Clearly and Simply | FrankensTeam's Excel Collection | Scoop.it
How to create an interactive “Pivot-like” Marimekko Chart in Excel allowing the user to select the visualized dimensions and measure on the fly
Kris's insight:

One more solution form Marimekko charts.

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!

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!

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!

Variable width histogram - assign values to ranges

Variable width histogram - assign values to ranges | FrankensTeam's Excel Collection | Scoop.it
Kris's insight:

Two different solutions for the same topic.

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

Dynamic Ribbon

Dynamic Ribbon | FrankensTeam's Excel Collection | Scoop.it
Dynamic RibbonX. A framework for rapid Office UI development
Kris's insight:

Seems it will be a great and really useful tool for MS Office developers.

more...
No comment yet.