Beginners-Specific Tasks Help
from George M

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)

Table of Contents

• Charting Guidelines
• Setting Chart Types/Options
• Changing Chart Types
• Applying Chart Options
• Formatting Charts Automatically
• Adding Text To A Chart
• Formatting Chart Axis
• Forecasting W/Regression Analysis
• Combine Contrasting Data
• Customizing 3-Dimensional Charts
• Printing Charts

Contents

• Getting Started
• Creating a New Workbook
• Naming a Worksheet
• Saving the Workbook in the 2013 Format 
• Entering Data and Formulas
• Enter Data, Using the Text Import Wizard
• Working with Formulas and Functions
• Entering a Formula, Using the Insert Function Command
• Using Excel’s AutoFill Feature
• Making a Cell Reference Absolute
• Applying Range Names to Formulas
• Creating a Simple Pie Chart
• Editing, Formatting, and Layout
• Adding Comments to Cells, Naming Cell Ranges
• Changing Column Widths and Row Height, By Dragging to Size, By Double-Clicking
• Inserting Columns, Inserting Rows
• Clearing a Range of Cells, Freezing Panes 
• Applying Cell Styles, Applying Themes
• Changing Orientation, Access the Page Setup dialog box
• To Repeat Rows on each Page, To Repeat Columns oneach Page

Contents

ü  Entering Data into Excel

ü  Displaying Experimental Data

ü  Basic Spreadsheet Operations

ü  Saving the File

ü  Setting up the Spreadsheet

ü  Tables and Graphs Formatting

ü  Evaluation Checklist

ü  Fitting Linear Models to Data: Regression

ü  Mathematical Models

ü  Estimating the Elasticity (E) and its Uncertainty

ü  Plotting the Regression Results

ü  Frequency Distributions and Importing Data

ü  Column Charts of Frequency Distributions

ü  Sorting Data

ü  Importing Data from an ASCII File

ü  Quick Excel Summary

ü  Summary of Statistical Analysis

ü  Graphical Analysis

ü  Regression Analysis

ü  Important Tips and Tricks for your Reports and Analysis

ü  Copying Figures or Tables as Pictures

ü  Table Borders in Word

ü  Calling Variables in Excel and Managing Them

ü  Selecting All Data in a Column

ü  Transposing Column Data into a Row