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