FrankensTeam's Ex...
Follow
Find
67.5K views | +123 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!

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!

Excel Named Range Shortcut • My Online Training Hub

Excel Named Range Shortcut • My Online Training Hub | FrankensTeam's Excel Collection | Scoop.it
This Excel Named Range shortcut using the exclamation mark will enable you to create a global name with local scope.
more...
No comment yet.
Scooped by Kris
Scoop.it!

Apply Custom Data Labels to Charted Points - Peltier Tech Blog

Apply Custom Data Labels to Charted Points - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
This tutorial describes a number of ways (manual, built-in, and programmatic) to add custom data labels to an Excel chart.
Kris's insight:

Great summary about the labeling possibilities.

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!

Excel PowerPivot PivotTable Named Sets

Excel PowerPivot PivotTable Named Sets | FrankensTeam's Excel Collection | Scoop.it
Excel PivotTable Named Sets enable you to pick and choose which column or row labels to include in your PivotTable reports.
more...
No comment yet.
Scooped by Kris
Scoop.it!

Data Tables & Monte Carlo Simulations in Excel - A Comprehensive Guide

Data Tables & Monte Carlo Simulations in Excel - A Comprehensive Guide | FrankensTeam's Excel Collection | Scoop.it
If anybody asks me what is the best function in excel I am drawn between Sumproduct and Data Tables, Both make handling large amounts of data a breeze, the only thing missing is the Spandex Pants a...
Kris's insight:

I have to learn it.

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

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!

Set Row Height With REPT Function « Contextures Blog

Set Row Height With REPT Function « Contextures Blog | FrankensTeam's Excel Collection | Scoop.it
Kris's insight:

I really like this great idea! Very useful!

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

Combine Bubble and xy scatter line chart - E90E50fx

Combine Bubble and xy scatter line chart - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Combine bubble and xy scatter line chart in excel - the trick is to use trendline
Kris's insight:

Useful, simple and ingenious idea!!

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

Reciprocal Chart Axis Scale - Peltier Tech Blog

Reciprocal Chart Axis Scale - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
This tutorial uses an Arrhenius plot to demonstrate construction of an axis with arbitrary scale and gridlines, ordinarily not available in Excel.
more...
No comment yet.
Scooped by Kris
Scoop.it!

Meeting in Milano, trip to the Alps and an Excel chart - E90E50fx

Meeting in Milano, trip to the Alps and an Excel chart - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
FrankensTeam meeting in Milano, Alps Excel chart
more...
No comment yet.
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!

Area chart with levels - Excel-Croissant - E90E50fx

Area chart with levels - Excel-Croissant - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Excel area chart to visualize small and large values
Kris's insight:

Area-levels chart in #Excel

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

Secondary Axis as Percentage of Target - Peltier Tech Blog

Secondary Axis as Percentage of Target - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
Usually, secondary axes are confusing and cognitively butrdensome. But this tutorial shows how a secondary axis with percentages can be a good thing.
more...
No comment yet.
Scooped by Kris
Scoop.it!

How to copy charts based on named formulas to other workbook? - E90E50fx

How to copy charts based on named formulas to other workbook? - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Copy and use Excel charts based on named formulas from example file to your own workbook.
Kris's insight:

It will be very useful for those who would like to use our downloadable example charts in their own files!

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!

Convert numbers to words with Excel formula - language collection - E90E50fx

Convert numbers to words with Excel formula - language collection - E90E50fx | FrankensTeam's Excel Collection | Scoop.it

Convert numbers to words with Excel formula: Italian, English, Hungarian

Kris's insight:

Do you have formulas for other languages? Please share!

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!

Excel PivotTable Field List Can Float!

Excel PivotTable Field List Can Float! | FrankensTeam's Excel Collection | Scoop.it

Hover over the title bar for the PivotTable Field List.
When your mouse changes to a four-headed arrow, click and drag it to the position where you would like it to appear and resize as needed.

Kris's insight:

I like it!!

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

Trendline formatting bug in Excel 2013 and the secret of The FrankensTeam - E90E50fx

Trendline formatting bug in Excel 2013 and the secret of The FrankensTeam - E90E50fx | FrankensTeam's Excel Collection | Scoop.it

A small bug in Excel 2013.

more...
No comment yet.