How to sum the product of matrix or array rows? - E90E50fx
Excel formula trick to sum product of matrix elements by rows using logarithm
Multiple lines across categories - simple step by step guide - E90E50fx
formule excel formattazione condizionale convalida formule matriciali
Customer segmentation - dynamic template chart - E90E50fx
customer segmentation dynamic Excel chart
Matrix bubble chart with conditional formatting - E90E50fx
Excel matrix bubble chart with conditional formatting - change the rules according to your needs.
Formula challenge: create a list of sheet names based on a prefix - E90E...
formula to create a list of sheet names based on prefix without VBA
Formula challenge: SUMIF from more sheets - E90E50fx
Sumif from multiple sheets using excel formula
Excel Expert Interviews - Excel MVPs, Trainers, Bloggers, & Gurus
I have been working on a special project the last month or so. Its been all hush-hush. Under the cover of darkness, I have been interviewing
Different color for up and down line segments in an Excel chart - E90E50fx
Different color for up and down line segments in Excel charts.
Error bar begin and end style setting differences - E90E50fx
Error bar differences in Excel 2010 and 2013: begin and end points changed
Visualize small change in large number - split the data - E90E50fx
Dynamic Excel chart to visualize small change in large values
Perfect square plot area, perfect square gridlines - E90E50fx
Easy way to create perfect square plot area and gridlines in Excel chart
Talent traffic chart with chord diagram in Excel - E90E50fx
Talent traffic chart with chord diagram in Excel
SUM by color: Calculate when color changed - E90E50fx
Trigger calculation when color or other formatting changed.
How defined names are calculated - chart example - E90E50fx
How and when Excel calculates the defined names? Explained using a chart with random data.
Stacked column chart with more trendlines - E90E50fx
Excel stacked column chart with lines lying on the top of the columns.