-
Tops are LOTUS, EXCEL, QUATTRO PRO
-
Visicalc was first--created by Dan Bricklin for the Apple IIE
-
Rapid and automatic recalculation--corrections, what-ifs.
-
Mitch Kapor--LOTUS 1,2,3 drove the IBM PC to dominance in the early 80's
-
Window=worksheet, grid-->cells;
-
HELP and tutorials
-
3D worksheets all in one file gave data references more than 2 coordinates
-
Labels, label formats: right, left, center, fill . Cell width and truncation.
format, edit/clear
-
Values: numbers, formulas, functions. Number formats
-
FUNCTIONS
-
Filling cells by example
-
Building formulas by pointing. Operators + - * / ^ ( )
-
Copy vs. cut/paste and formula adjustments. absolute vs. relative references
-
Adding, deleting rows and columns
-
Save AS and the frustrating floppy switch glitch
-
Importing ASCII data
-
Cells, Ranges, named ranges. multidimensional.
-
Smartmasters, Smarticon sets
-
setting column widths, formatting shades and lines.
-
Sort, analyze/distribution
-
Graphs: Bar, Pie, line. Charts, Graphs and beautification
-
Setting print range and setting fit-to-page
last modified, September 27, 1997. comments to webmaster rbanis@jinx.umsl.edu
return to BA103 syllabus
goto EXCEL exercise 1, jobrate