How-To Geek on MSN

How to use and read box and whisker charts in Microsoft Excel

Simple column charts can hide the truth of your data, but box plots tell the full story.
Hosted on MSN

How to Format a Spilled Array in Excel

Applying direct formatting to spilled arrays in Excel could cause issues if the data changes shape or size. Formula-based conditional formatting rules allow for automatic formatting adjustments when ...