Introduction to Excel

In this course, you are asked to create charts and calculate averages and standard deviations.  If you do not know how to do so, please use the following three tutorials to learn more.  To see the slides, you need Microsoft Power Point.  To listen to narrated slides you need Flash.  Download►

1. Introduction to worksheets, cells, formulas  Slides► Listen►
2. Excel basic functions, sum, average, count  Slides► Listen►
3. How to plot a control chart   Slides►  Listen►
4. How to use an IF function Listen► You Tube► SWF►

If you wish to use Excel to conduct statistical analysis of data, you have to turn this feature on (SWF file) within Excel and then examine the following tutorials:

• Descriptive statistics (slides part 1 & 2, narrated slides part 1 & part 2)
• Analysis of mean of a sample (slides or narrated slides)
• Analysis of means of two samples (slides or narrated slides)
• Analysis of variance (slides or narrated slides)
• Correlation (slides or narrated slides)
• Single variable regression (slides or narrated slides)
• Multiple regression analysis (slides or narrated slides)

A number of other self-paced instruction on Excel are available online.  Including an Excel based tool for teaching about excel.  You may also be interested in the narrated presentations made by others on the web.  Here is a list of training material on the web on Excel.  There are also short workshops conducted by the university.