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

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-09-21T18:15:16-06:00January 6th, 2021|Conditional Formatting, 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

“Standard Error” Error Bars in Excel

In previous articles we discussed adding fixed error bars and Standard Deviation error bars to Excel charts. The last option available on the Format Error Bars dialog is the standard error,  short for "standard error of the mean". Using the same data set that we used for the post Standard Deviation Error Bars in Excel, [...]

By |2020-12-14T17:36:39-07:00December 16th, 2020|Error bars, 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

Standard Deviation Error Bars in Excel

We discussed inserting error bars into an Excel chart in the post Error Bars in Excel. We showed how to add constant errors, constant fractional errors and error bars that vary with every data point. We didn't discuss the source of these errors just how to add them to the chart. Excel has other options [...]

By |2020-11-17T17:52:45-07:00November 4th, 2020|Error bars, Excel, Tutorials and How-Tos|0 Comments

Error Bars in Excel

Error bars on a chart/graph provide a visual representation of our uncertainty of knowledge about the values of the data points. These are helpful in understanding the accuracy of our data and have the benefit of being relatively easy to interpret. We are going to discuss how to add error bars to charts in Excel [...]

By |2020-11-16T18:09:20-07:00October 22nd, 2020|Error bars, Excel, Tutorials and How-Tos|0 Comments