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

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

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

## Data Structure Explanation – Excel Table

What is a Data Structure?  Part 1 An Explanation Using Tables in Excel 2010 Whether you are just going to look at your data and draw conclusions visually, or you are going to writing a computer program to manipulate it, even a very simple structure can help. When analyzing data, it is useful to decide [...]

By |2021-02-18T17:17:53-07:00October 18th, 2015|Excel, General, Tutorials and How-Tos|0 Comments

## Excel 2010 – Replacing Blank Cells with Zeros

Using Excel 2010 we are going to look at how to replace blank cells with zeros. Selecting the cells manually is, of course one option, but if the spread sheet is large then the procedure would be rather time consuming. For this exercise we will use a couple of short-cuts. Tools used for this exercise: [...]

By |2019-08-15T19:34:10-06:00October 13th, 2015|Excel, Tutorials and How-Tos|0 Comments

## Excel 2010: Converting Numbers to Text Format – Removing the Warning Message

In this example we are going to convert Id numbers into Text format and we will look at how to removing any resulting warning messages. Tools used for this exercise: Using the “Number as text” format Removing the warning message on the Options command on the File Tab. […]

By |2015-10-13T04:08:01-06:00October 13th, 2015|Excel, Tutorials and How-Tos|0 Comments

## Excel 2010 – Names into Separate Columns – Convert to a Table – Sort

Using Excel 2010 we are going to look at how to separate full names (last name followed by first name) into separate columns. Once that is done we are going to convert the data to table format and sort on the last name. Tools used for this exercise: The “Text to Columns” command Converting to [...]

By |2015-10-12T23:10:37-06:00October 12th, 2015|Excel, Tutorials and How-Tos|0 Comments