FrankensTeam's Ex...
Follow
Find tag "tutorials"
41.4K views | +79 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!

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!

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!

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!

Dot Plots in Microsoft Excel - Peltier Tech Blog

Dot Plots in Microsoft Excel - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
Microsoft Excel doesn't have a native Dot Plot chart type. But you can build your own following these simple instructions.
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!

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.
Suggested by Dude
Scoop.it!

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

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!

Calculated Field vs Calculated Item

Calculated Field vs Calculated Item | FrankensTeam's Excel Collection | Scoop.it

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.

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!

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!

Excel 2007: Data Validation in Depth

Excel 2007: Data Validation in Depth | FrankensTeam's Excel Collection | Scoop.it

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.

 

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