FrankensTeam's Ex...
Follow
Find tag "formulas"
41.0K views | +156 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!

Set Row Height With REPT Function « Contextures Blog

Set Row Height With REPT Function « Contextures Blog | FrankensTeam's Excel Collection | Scoop.it
Kris's insight:

I really like this great idea! Very useful!

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!

Excel Pivot Table Tutorial -- GetPivotData

Excel Pivot Table Tutorial -- GetPivotData | FrankensTeam's Excel Collection | Scoop.it

The basics of Getpivotdata.

Kris's insight:

In my practice, Getpivotdata is very-very useful for building reports.

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

An Investigation into the Performance of Excel

An set of articles into mememory use, timing and multithreading in Excel
Kris's insight:

Very useful stuff to understand how things work in the dark depth of Excel. :-)

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!

Formula challenge: create a list of sheet names based on a prefix - E90E50fx

Formula challenge: create a list of sheet names based on a prefix - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
formula to create a list of sheet names based on prefix without VBA
Kris's insight:

A really interesting formula solution to list sheet names based on a rule. Learn our tricks. :-)

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

Our enormous ... 2013 - E90E50fx

Our enormous ... 2013 - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Summary of The FrankensTeam's unique Excel work in year 2013
more...
No comment yet.
Scooped by Kris
Scoop.it!

How defined names are calculated - chart example - E90E50fx

How defined names are calculated - chart example - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
How and when Excel calculates the defined names? Explained using a chart with random 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!

Excel data validation with on-the-fly update without VBA

Excel data validation with on-the-fly update without VBA | FrankensTeam's Excel Collection | Scoop.it

Hierarchical dynamic validation list with a plus: type the name of new element if you do not find it. It will be part of the list immediately!

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

Excel data validation with on-the-fly update without VBA

 

#microsoft #excel #training 

 

Scooped by Kris
Scoop.it!

VLOOKUP Fail (and MATCH, LOOKUP)

VLOOKUP Fail (and MATCH, LOOKUP) | FrankensTeam's Excel Collection | Scoop.it

Good to know when using calculated values in lookup-functions.

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

Excel Ignore Blanks (Data Validation List too)

Excel Ignore Blanks (Data Validation List too) | FrankensTeam's Excel Collection | Scoop.it
Kris's insight:

Frequently asked question.

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

Convert numbers to words with Excel formula - language collection - E90E50fx

Convert numbers to words with Excel formula - language collection - E90E50fx | FrankensTeam's Excel Collection | Scoop.it

Convert numbers to words with Excel formula: Italian, English, Hungarian

Kris's insight:

Do you have formulas for other languages? Please share!

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!

Digits of Pi in Excel: fomula challenge and visualization - E90E50fx

Digits of Pi in Excel: fomula challenge and visualization - E90E50fx | FrankensTeam's Excel Collection | Scoop.it

 

Formula challenge for your mind, visualization for your eyes: play with the digits of pi and find the pandigital sequence.

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

How to sum the product of matrix or array rows? - E90E50fx

How to sum the product of matrix or array rows? - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Excel formula trick to sum product of matrix elements by rows using logarithm
Kris's insight:

Great mathematical trick in Excel formula.

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!

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!

Formula challenge: SUMIF from more sheets - E90E50fx

Formula challenge: SUMIF from more sheets - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Sumif from multiple sheets using excel formula
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!

Return the First and Last Values in a Range in Excel

Finding the first or last values or cell references in a range is easy with INDEX and MATCH.
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.
Scooped by Kris
Scoop.it!

Sort the data on the Excel chart - E90E50fx

Sort the data on the Excel chart - E90E50fx | FrankensTeam's Excel Collection | Scoop.it

An easy solution with explanation.

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

Absolute structured references in tables

Absolute structured references in tables | FrankensTeam's Excel Collection | Scoop.it

...a nifty little trick on how to make structured references absolute.

Kris's insight:

That is a great trick! Makes using tables easier - must remember!

more...
No comment yet.