Facilitating Technology Literacy || Call Us Today! 780-240-6806|contact@WindSongTraining.ca

# 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 [...]

By |2022-03-01T17:41:31-07:00March 1st, 2022|Data Analysis, Excel, Excel Functions, Tutorials and How-Tos|0 Comments

## 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 [...]

By |2022-01-31T17:38:03-07:00January 31st, 2022|Data Analysis, Excel, Linear Algebra, Matrix Multiply, Tutorials and How-Tos|0 Comments

## 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

## Excel Basics: How to Name a Cell or a Range of Cells

In this article we are going to look at one of the basic elements of Excel, specifically how to name a cell, and alternately how to name a range of cells. This is useful for general readability and efficiency when it comes to using functions and formulas. Naming cells is also very useful, with readability, [...]

By |2022-01-11T17:14:51-07:00January 11th, 2022|Excel, Tutorials and How-Tos|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 [...]

## Excel’s Goal Seek – Part of “What-if Analysis”

In this article we are going to look at Excel’s Goal Seek command. This command is actually quite easy to use, and it is very popular because of its ability to look backwards from a given result. A common example used to illustrate this command is finding the amount a person can borrow, at a [...]

By |2021-03-30T17:48:31-06:00February 18th, 2021|Excel, What-if-Analysis|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

## Windows 10 – L3 – Finding the Command Prompt Using Two Methods:

We posted instructions on finding the Command Prompt in Windows 7 in a past Post, and because we still find it useful, the following is an update on finding it in Windows 10. The reason that it is useful, is that, in many cases, while instructing people, the phrase “just open a Windows Command Prompt [...]

By |2021-02-16T17:38:55-07:00October 1st, 2019|Operating Systems, Windows:|0 Comments
Go to Top