Microsoft Excel Basics 

(c) 2005 Harland E. Hodges, Ph.D., all rights reserved

 

The Basics

01 The Excel Worksheet
02
Excel Help Facilities
03
Menu Toolbar Options
04
Customizing Toolbars
05
Creating & Saving a Simple Formula
06
Creating a Backup Disk
07
Using a Previously Saved Spreadsheet
08
Setting Decimal Point Accuracy (Format Cells)
09
Mathematical Operators (Complicated Formula)
10
Adding Information to Worksheets (Format Cells)
11
Protecting Worksheets
12
Working With Tables
13
Working With Built-in Functions

Utilities

98 Printing
99
Data Analysis Tools - Add Ins

Step By Step Data Analysis Procedures

14 Creating Charts (Bar, Line, Pie)
15
Creating a Histogram
16
17
18
19
20
Analysis of Variance (ANOVA)
21
22
XY Scattergram
23
Simple Linear Regression
24
Multiple Regression