FrankensTeam's Excel Collection
93.1K views | +15 today

# FrankensTeam's Excel Collection

Useful, interesting and funny Excel stuff
Curated by Kris
 Scooped by Kris

## Secondary Axis as Percentage of Target - Peltier Tech Blog

Usually, secondary axes are confusing and cognitively butrdensome. But this tutorial shows how a secondary axis with percentages can be a good thing.
No comment yet.
 Scooped by Kris

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

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.

No comment yet.
 Scooped by Kris

## 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:

No comment yet.
 Scooped by Kris

## Highlight a Specific Data Label in an Excel Chart - Peltier Tech Blog

This tutorial covers VBA and non-programmatic ways to highlight the maximum in a chart by changing the data label formatting.
No comment yet.
 Scooped by Kris

## Dot Plots in Microsoft Excel - Peltier Tech Blog

Microsoft Excel doesn't have a native Dot Plot chart type. But you can build your own following these simple instructions.
No comment yet.
 Scooped by Kris

## The Imposing INDEX - Excel Hero Blog

Kris's insight:

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

No comment yet.
 Scooped by Kris

## Excel_Factor - collection of tutorials

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

No comment yet.
 Suggested by Dude

## Chandoo.org - Learn Microsoft Excel Online

Learn Microsoft Excel Online. Every day we post fresh Excel Tips, Tricks, Charts, Formula Examples, Tutorials, Downloads, Dashboards, Templates and Visualizations for your Inspiration, Success and Productivity.
No comment yet.
 Scooped by Kris

## 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 :-)

No comment yet.
 Scooped by Kris

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

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!

No comment yet.
 Scooped by Kris

## AJP Excel Information

AJP Excel information
Kris's insight:

New design - with lot of resources, tutorials, examples.

No comment yet.
 Scooped by Kris

## The Advanced Chart Utility Is Here - Peltier Tech Blog

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.

Anurag's curator insight,

nice

 Scooped by Kris

## Calculated Field vs Calculated Item

After you create a pivot table, you can enhance the results by writing your own formulas, to create calculated fields and calculated items.

Kris's insight:

Great summary and examples.

No comment yet.
 Scooped by Kris

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

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

No comment yet.
 Scooped by Kris

## Excel Tabular Data is the Ideal Format for PivotTables and Formulas

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...

Progressive training's curator insight,

Excel Tabular Data is the Ideal Format for PivotTables and Formulas

#excel #training

 Scooped by Kris

## Excel 2007: Data Validation in Depth

I must say it is a really a quick and easy way to create hierarchycal data validation, especially when your data is not expected to change. And also you can see a useful featue how to create names! from selection.

Dilip Kulriya's curator insight,