denise

About Denise

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

Introduction to Excel’s SUMPRODUCT Function

In this article we will focus on introducing Excel's SUMPRODUCT function. It is also, in part, a continuation of a previous article Excel and Some linear Algebra using Matrix Multiply to Solve Problems. We will use the same data file as the previous article (after going through a simple example first) and illustrate how to [...]

Excel Basics: Absolute Referencing with Formulas

In this article we are going to look at a basic foundational concept of Excel, namely: using absolute referencing with formulas. To illustrate this, we’ll use an example, see figure 1. (Note that the example is a pared down version of the one used in the article on the scenario manager Excels Scenario Manager Part [...]

By |2022-02-11T17:58:56-07:00February 11th, 2022|Data Analysis, Excel, Excel Basics, Tutorials and How-Tos|0 Comments

Excel and Some Linear Algebra – Using Matrix Multiply to Solve Problems

In this article we will look at using Excel and the matrix multiply function MMULT, along with the TRANSPOSE function. We will go through an example using a formula and then go through the same example with a linear algebra perspective.  This article assumes the reader has a basic knowledge of linear algebra, specifically dot [...]

Excel’s Scenario Manager – Part of “What-if Analysis”

In this article we are going to look at Excel’s Scenario Manager. It is one of the three sub-commands in the What-if-Analysis group on the Data Tab: Fig. 1: The What-If-Analysis command and its three sub-commands The Scenario manager, like Goal Seek and Data Table, allows us to see what would happen if [...]

By |2022-01-11T17:53:49-07:00January 11th, 2022|Data Analysis, Excel, Tutorials and How-Tos, What-if-Analysis|0 Comments

Ranges in Excel

Functions in Excel can work with multiple cells by providing ranges as input parameters. The Excel documentation will refer to these ranges as either "vector" or "array" ranges. A range is specified by a beginning cell address, a colon, followed by the final cell address. A valid range in Excel looks like: D4:D10, which includes [...]

By |2021-04-14T17:39:44-06:00April 14th, 2021|Excel|0 Comments

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
Go to Top