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

## Excel’s Lookup Functions and Approximate Matching

Excel has 4 functions that allow us to find a value in a column or row, and return a value from a corresponding column or row. The lookup functions can be very useful and are easy to understand when they provide an exact match for a search item. In addition to exact matches, the functions [...]

By |2021-04-20T17:45:07-06:00April 20th, 2021|Approximate match, Excel, Lookup|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 [...]

## A Few Words About the Pearson’s Correlation Coefficient.

“Politicians use statistics in the same way that a drunk uses lamp-posts for support rather than illumination” -A. Lang Statistics is a very complex subject and because of its complexity statistics and its terms are frequently misunderstood and misused. I came across an excellent article on The datapine Blog about how statistics can be misleading.  [...]

By |2021-03-26T17:45:50-06:00March 26th, 2021|Correlations, Excel, Statistics|0 Comments

## Excel: An Interface Design That Works

I was reading about one of the new functions that Microsoft has added to Excel, XLOOKUP(), and I started wondering where the different LOOKUP() functions came from. This little rabbit hole turned out to be quite revealing in terms of the way that Excel looks and works - the search took me to some history [...]

By |2021-03-11T17:18:37-07:00March 10th, 2021|Excel, General, Remarks on Technology|0 Comments

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

## A Simple Model of Covid-19 Data With Excel

We currently (as of Jan, 2021) have large amounts of data concerning the Covid-19 pandemic available. We have daily updates through various news outlets and we can download data from different country's public data websites. Aggregated data is available for viewing at Worldometers coronavirus page, and for download at Our World in Data's Covid-19 data [...]

By |2021-02-11T17:12:54-07:00February 8th, 2021|Excel, Exponential trendline, Trendline|0 Comments

## Moving Averages

We have a steady supply of Covid-19 statistics and graphs on sites like Worldometers with their corona virus page, and Our World in Data, and their corona virus page. Some of the available graphs have an option to show "Moving Averages" with averages of 3 days or 7 days. These averages smooth the data to [...]

By |2021-02-16T17:34:11-07:00January 18th, 2021|Convolution, Excel, Moving Average, Smoothing Filter, Trendline|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-02-16T17:23:37-07:00January 6th, 2021|Excel, Tutorials and How-Tos|0 Comments

## How to use the Correlation Command

Once the Data Analysis toolbox has been enabled, the correlation function is ready to use. For this example, we are going to use data from two stock market indexes: NASDAQ Composite Index and the Dow Jones Industrial Average (https://ca.finance.yahoo.com/quote/ONEQ/history?p=ONEQ and https://ca.finance.yahoo.com/quote/DIA/history?p=DIA) . The data is the daily closing price for the last 6 months of [...]

By |2021-02-17T00:05:15-07:00December 30th, 2020|Correlations, Excel, Tutorials and How-Tos|0 Comments

## How to Enable Analysis ToolPack in Excel

First: What is the Analysis ToolPak: Excel’s Analysis ToolPak provides a variety of tools and functions which enable sophisticated data analysis to be preformed. It produces output tables, and, in addition, some tools also generate charts. The add in takes the basic Excel functions and combines them into workflows where only the input values and [...]

By |2021-02-18T17:15:05-07:00December 23rd, 2020|Excel, Tutorials and How-Tos|0 Comments