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

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!

storytelling with data: a little math on non-zero baselines

storytelling with data: a little math on non-zero baselines | FrankensTeam's Excel Collection | Scoop.it

Considerations about chart scaling and baseline.

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

Different color for up and down line segments in an Excel chart - E90E50fx

Different color for up and down line segments in an Excel chart - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Different color for up and down line segments in Excel charts.
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!

Stacking Cubes Charts with Excel - E90E50fx

Stacking Cubes Charts with Excel - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
stacking cubes columns bar and matrix charts with Microsoft excel
Kris's insight:

Toys and charts :-)

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

Facts about subtotal formula - visible and hidden cells - E90E50 fx

Facts about subtotal formula - visible and hidden cells - E90E50 fx | FrankensTeam's Excel Collection | Scoop.it
formule excel formattazione condizionale convalida formule matriciali
Kris's insight:

Some things to remember when using SUBTOTAL formula.

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

Excel_Factor - collection of tutorials

Excel_Factor - collection of tutorials | FrankensTeam's Excel Collection | Scoop.it

Collection of great tutorials sent by the readers of Mynda Treacy's site - I found some really good tricks there!

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

excelisfun -- 1900 Excel How To Videos - YouTube

1900 Videos, 90 Playlists. Excel Efficiency Tricks so you can work faster, have more fun & help others with Excel.

 

Impressive collection. The only challenge is: find what you need :-)

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!

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!

Robust Dynamic (Cascading) Dropdowns Without VBA | Chandoo.org - Learn Microsoft Excel Online

Robust Dynamic (Cascading) Dropdowns Without VBA | Chandoo.org - Learn Microsoft Excel Online | FrankensTeam's Excel Collection | Scoop.it
Find out how to set up cascading dynamic dropdowns using Excel's Data Validation that users must manually clear if they later make changes - without VBA
Kris's insight:

Solution with only one named formula.

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

Error bar begin and end style setting differences - E90E50fx

Error bar begin and end style setting differences - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Error bar differences in Excel 2010 and 2013: begin and end points changed
more...
No comment yet.
Scooped by Kris
Scoop.it!

Using Colors in Excel - Peltier Tech Blog

Using Colors in Excel - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
This article describes practicalities of colors in Office 2007, including color themes, the color picker, custom colors, and applying colors to charts.
Kris's insight:

Very useful!

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

Shaded Quadrant Background for Excel XY Scatter Chart - Peltier Tech Blog

Shaded Quadrant Background for Excel XY Scatter Chart - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
Shaded Background Quadrants People often ask how to shade the background of an XY Scatter chart. This may help to define certain regions of performance or cost-benefit.
more...
No comment yet.
Scooped by Kris
Scoop.it!

Simple calendar-based heatmap in Excel

Simple calendar-based heatmap in Excel | FrankensTeam's Excel Collection | Scoop.it

Visualize 10 years metro usage.

Kris's insight:

Could also be useful for sales data.

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

Dashboard Course Offer

Dashboard Course Offer | FrankensTeam's Excel Collection | Scoop.it
Knowing How to Make Amazing Excel Dashboards Will Take Your Career to the Next Level Excel Dashboards are the new buzzword employers are looking for.
more...
No comment yet.
Scooped by Kris
Scoop.it!

The Spreadsheet Page - By John Walkenbach

The Spreadsheet Page - By John Walkenbach | FrankensTeam's Excel Collection | Scoop.it
John Walkenbach's Excel site....

 

This site is one of my personal favourite - not only because it is great to remember that this is the site from where I navigated to Daniel Ferry's Excel Hero blog. You can find a variety of useful (and mostly non-trivial) tips, add-ins, books here.

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.