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

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!

3D Financial Accounts in Excel

3D Financial Accounts in Excel | FrankensTeam's Excel Collection | Scoop.it
Create multi-dimensional matrix accounts with Linked Pictures in Excel.
Kris's insight:

I really like this 3D design trick!

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

Matrix bubble chart with conditional formatting - E90E50fx

Matrix bubble chart with conditional formatting - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Excel matrix bubble chart with conditional formatting - change the rules according to your needs.
more...
No comment yet.
Scooped by Kris
Scoop.it!

Improving the Default Percent Formatting » Bacon Bits

Improving the Default Percent Formatting » Bacon Bits | FrankensTeam's Excel Collection | Scoop.it

Good idea with the triangles! Great example how to use the custom format described also in the tutorial posted above.

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!

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!

SUM by color: Calculate when color changed

SUM by color: Calculate when color changed | FrankensTeam's Excel Collection | Scoop.it
Trigger calculation when color or other formatting changed.
more...
Progressive training's curator insight, November 25, 2013 11:21 AM

SUM by color: Calculate when color changed

Scooped by Kris
Scoop.it!

Pivot Table Conditional Formatting

Pivot Table Conditional Formatting | FrankensTeam's Excel Collection | Scoop.it

"...you can adjust the formatting rules, so they refer to the pivot fields, instead of a specific range of cells."

Kris's insight:

Great and useful trick!

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.