Boot Windows XP.
Naming a cell or range of cells: select cell(s), click Name box, type name, hit Enter key. Using a name: in a cell, type = followed by a name (instead of a number, formula, string, etc.). Deleting a name: Insert > Name > Define, select name, click Delete button.
To format a cell or cell range for currency, percentage, etc.: select cell or cell range, right-click and select Format Cells, click Number tab if necessary.
Relative cell address (no leading dollar signs $ on row or column) changes (adjusts) when copied. An absolute cell address (leading $ on row and/or column) does not change when copied.
Using functions: Insert > Function
We will need to download the sample spreadsheets used in the textbook, Essentials MS Office Excel 2003 level two.
Double-click on this file and save the extracted files to your USB drive in your ComputingEnvironments folder.
In class, we will cover Essentials Projects 6 and 7 on functions and pivot tables since they are the most complicated, mathematical, and technical. The other Essentials Projects (1--5, 8) you can look at on your own. For example, check out the following.
Essentials Project 6: functions VLOOKUP, HLOOKUP, FREQUENCY, COUNT, SUM, COUNTIF, SUMIF, Charting frequency distributions.
If you want exact match counts in your frequency distribution, then you must include in your bins array (in ascending order) every possible data value that occurs in the data array. If you leave any data values out (accidently or on purpose), then Excel assumes your are doing range counts instead of exact match counts. Another difference between exact match counts and range counts is that the cell range containing the counts (the FREQUENCY function results) is one bigger for range counts than for exact match counts, as described in the Extend Your Knowledge box on page 198 of the Essentials Excel level two text.
Essentials Project 7: creating pivot tables, creating pivot charts.
home page:
http://elvis.rowan.edu/~hartley/index.html
e-mail:
hartley@elvis.rowan.edu