FrankensTeam's Ex...
Follow
Find
33.6K views | +41 today
Scooped by Kris
onto FrankensTeam's Excel Collection
Scoop.it!

Collecting Application.International settings - E90E50

Collecting Application.International settings - E90E50 | FrankensTeam's Excel Collection | Scoop.it

The aim of our project is to collect and publish the list of regional settings used in different language Excel versions.

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!

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!

Vintage charts in Excel: bar chart with highlight - E90E50fx

Vintage charts in Excel: bar chart with highlight - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Nicely formatted vintage bar chart in Excel with highlighted data.
Kris's insight:

Easy vintage chart reproduction with some formatting.

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

Plot Excel Data in an Interactive Bing Map

Plot Excel Data in an Interactive Bing Map | FrankensTeam's Excel Collection | Scoop.it
If you don’t have Excel 2013 then this post will be a bit like window shopping with an empty wallet. You get to try stuff on and test drive it, you just don’t get to take it home. Window shopping
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...
No comment yet.
Scooped by Kris
Scoop.it!

Knowledge Base.: Error : Print titles must be contiguous and complete rows or columns

Knowledge Base.: Error : Print titles must be contiguous and complete rows or columns | FrankensTeam's Excel Collection | Scoop.it
Knowledge Base
Kris's insight:

To remember.

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

Broken line panel charts aka. bifocal charts in Excel - E90E50fx

Broken line panel charts aka. bifocal charts in Excel - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Two version of line chart in Excel to visualize small and large number on one chart.
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!

Spotlights chart in Excel - E90E50fx

Spotlights chart in Excel - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Spotlights chart in Excel using xy scatter chart to visualize film scores and profits.
Kris's insight:

Freddy: Aren't there any lights in this place?

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!

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!

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!

Vintage charts in Excel: arrows from one point - E90E50fx

Vintage charts in Excel: arrows from one point - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Vintage chart reproduction in Excel: arrows starting from one point.
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!

Pivot Table Resources - Peltier Tech Blog

This is an index of Pivot-Table-related posts on the Peltier Tech blog, and a list of three good Pivot Table books.
Kris's insight:

All about Pivot tables.

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!

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!

Microsoft Excel VLOOKUP and CHOOSE formula to lookup columns to the left

Microsoft Excel VLOOKUP and CHOOSE formula to lookup columns to the left | FrankensTeam's Excel Collection | Scoop.it
In this quick Excel tutorial we look at how to use the VLOOKUP formula with the CHOOSE function to look up columns to the left as an alternative to the INDEX and MATCH functions.
Kris's insight:

Easy! It will be a good material for my beginners.

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!

Witch of Agnesi curve in Excel - E90E50fx

Witch of Agnesi curve in Excel - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Visualize maths in Excel: Witch of Agnesi curve animated chart
Kris's insight:

One more visualize maths chart about a funny-named curve.

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

Visualize Maths in Excel - E90E50fx

Visualize Maths in Excel - E90E50fx | FrankensTeam's Excel Collection | Scoop.it

 

Visualize mathematics in Excel using formulas and animated charts.
Kris's insight:

Caution! Addictive! :-)

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

Axis Labels That Don't Block Plotted Data - Peltier Tech Blog

Axis Labels That Don't Block Plotted Data - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
Axis labels in a bar chart can obstruct negative bars. This tutorial shows a way to place labels across the axis from the data.
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.