About Denise

This author has not yet filled in any details.
So far Denise has created 13 blog entries.

Excel: Conditional Formatting – Color Scales

This is another in a series of Excel’s Conditional Formatting How-To's. The pervious post looked at the Highlight Cell Rules option. (For Details See: Excel Conditional Formatting Highlight Cell Rules). In this article we are going to look at another option namely: Color Scales. Using Color Scales is a popular formatting technique that lends itself [...]

By |2021-09-21T18:15:16-06:00January 6th, 2021|Conditional Formatting, Excel, Tutorials and How-Tos|0 Comments

Excel: Conditional Formatting – Highlight Cell Rules

Excel’s Conditional Formatting command allows for a simple and quick method to format a range or a table of cells based on the value of the data contained in those cells. This allows us to actually see certain features of the data. Over the next few Posts we are going to look at examples to [...]

By |2021-09-22T17:29:39-06:00December 10th, 2020|Conditional Formatting, Excel, Tutorials and How-Tos|0 Comments

Excel 2016 How-to: Using the Correlation Tool

Excel's AnalysisToolPak offer a variety of routines for analyzing statistical, scientific and engineering data. In this articular we are going to look at how to use the correlation tool in the Analysis ToolPak. Enable the Analysis ToolPak: Although already installed with Excel, the Analysis ToolPak will need to be enabled through the Options menus. For [...]

By |2019-08-15T19:06:19-06:00July 20th, 2017|Excel, Tutorials and How-Tos|0 Comments
Go to Top