FrankensTeam's Ex...
Follow
Find tag "beginner"
44.2K views | +46 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!

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!

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!

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!

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!

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!

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!

Multiple lines across categories - simple step by step guide - E90E50fx

Multiple lines across categories - simple step by step guide - E90E50fx | FrankensTeam's Excel Collection | Scoop.it

Use different data structures to create this chart: step-by-step tutorial.

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

Visualize small change in large number - split the data - E90E50fx

Visualize small change in large number - split the data - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Dynamic Excel chart to visualize small change in large values
more...
No comment yet.
Scooped by Kris
Scoop.it!

Perfect square plot area, perfect square gridlines - E90E50fx

Perfect square plot area, perfect square gridlines - E90E50fx | FrankensTeam's Excel Collection | Scoop.it

Easy way to create perfect square plot area and gridlines in Excel chart

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

Excel Tabular Data is the Ideal Format for PivotTables and Formulas

Excel Tabular Data is the Ideal Format for PivotTables and Formulas | FrankensTeam's Excel Collection | Scoop.it
Having your Excel data in a tabular format will make it easy to analyse with Pivot Tables and save you hours of frustration.
Kris's insight:

"You might think you’re saving time by skipping this step but it will eventually come back to haunt you".... so true...

more...
Progressive training's curator insight, November 19, 2013 12:45 PM

Excel Tabular Data is the Ideal Format for PivotTables and Formulas

 

#excel #training 

 

Scooped by Kris
Scoop.it!

Stacked column chart with more "trend"lines

Stacked column chart with more "trend"lines | FrankensTeam's Excel Collection | Scoop.it
Excel stacked column chart with lines lying on the top of the columns.
Kris's insight:

You can easily choose where do you want to see lines to highlight the movement of the data.

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

How to use rectangular range as chart data - E90E50fx

How to use rectangular range as chart data - E90E50fx | FrankensTeam's Excel Collection | Scoop.it

Rectangular range, two dimension range, matrix as chart data for line and column charts.

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

Gene technology data visualization in Excel (dPCR) - E90E50fx

Gene technology data visualization in Excel (dPCR) - E90E50fx | FrankensTeam's Excel Collection | Scoop.it

Visualize science: gene expression patterns.

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!

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!

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!

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!

E90E50

E90E50 | FrankensTeam's Excel Collection | Scoop.it

The new content page of our sites!

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

Quickly combine text in multiple cells using this trick! [Formulas] | Chandoo.org - Learn Microsoft Excel Online

Quickly combine text in multiple cells using this trick! [Formulas] | Chandoo.org - Learn Microsoft Excel Online | FrankensTeam's Excel Collection | Scoop.it
Ever wondered how to go from a bunch of cells with text to one big combined text? Like shown above. Well, there is a simple trick. One of our readers, Grant shared this with us. Read on to learn this.
more...
No comment yet.
Scooped by Kris
Scoop.it!

Multiple Width Overlapping Column Chart - Peltier Tech Blog

Multiple Width Overlapping Column Chart - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
I read a post entitled Calling All Graph Wizards – Overlapping/Stacking Graphs w/o secondary axis on the Mr Excel forum today, and decided the question was broad enough and the answer quick and elegant enough that it was worth sharing.
more...
No comment yet.
Scooped by Kris
Scoop.it!

The Imposing INDEX - Excel Hero Blog

The Imposing INDEX - Excel Hero Blog | FrankensTeam's Excel Collection | Scoop.it
Kris's insight:

Today's conclusion: I will teach INDEX to all my colleagues.

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

Matrix bubble chart with Excel - E90E50fx

Matrix bubble chart with Excel - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
The purpose was to give an overview, a total picture without focusing on anything in particular.
more...
No comment yet.
Scooped by Kris
Scoop.it!

Stacked bar chart with optional trendline - E90E50fx

Stacked bar chart with optional trendline - E90E50fx | FrankensTeam's Excel Collection | Scoop.it

An easy but useful feature for stacked bar charts.

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

Edward Tufte's Slopegraphs in Excel - E90E50fx

Edward Tufte's Slopegraphs in Excel - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
One of the strengths of Tufte's graph (perhaps the most important) is that we can immediately read the ranking of both the data.
Kris's insight:

Easy-to-use dynamic solution.

more...
No comment yet.