Homer
Frank Lloyd Wright
George W. Bush
Class 2 Excel
November 8th, 2005 (Last modified: 11/17/2005 @ 7:45 pm UTC)
Items to cover:
-
1. hiding columns/rows
- error checking
- speech
- tracking changes
- goal seeking
- formula auditing
2. information messages (green)
3. adding comments (red)
4. fill
5. various tools –
6. Sorting
7. Filtering
8. More functions and formulas
9. A credit card expenses example
10. Creating charts
11. using charts in Word and PowerPoint
Class 1 Excel
November 3rd, 2005 (Last modified: 11/8/2005 @ 5:50 pm UTC)
We talked about:
-
1. What would you use Excel for?
- editing
- inserting rows and columns
- copying and pasting (including formulas)
- inserting functions
- use the AVERAGE and MEAN functions to calculate average test scores
- use the LEN, FIND, LEFT and RIGHT funtions to help separate a first and last name from a cell which contain the complete name
2. How to navigate?
3. Used a specific example (04calcgrades) to discuss:
4. How to print a sheet.
5. How to get the rows and columns to fit nicely on a page for printing.
6. How to use functions to split a full name entered in a cell into a first and last name.
-Excel Curriculum
October 2nd, 2005 (Last modified: 10/27/2005 @ 6:44 am UTC)
1. Excel Basics
- a. The Excel screen
- b. Workbooks, worksheets, cells
2. Working with Workbook Files
- a. Creating an empty workbook
- b. Opening a workbook
- c. Saving a workbook
- d. Closing a workbook
- e. Using a workbook template
- f. Deleting a workbook
- g. Creating multiple windows for a workbook
3. Working with Worksheets in a Workbook
- a. Worksheets
- b. Manipulating your worksheet
- c. Moving around in a worksheet
- d. Moving a worksheet
- e. Deleting a worksheet
4. Entering Data into a Worksheet
- a. Entering data
- b. Entering formulas
5. Editing the Data you Enter
- a. Basic cell editing
- b. Undoing changes and mistakes
- c. Using AutoComplete
- d. Using AutoFill
- e. Using automatic decimal points
- f. Using cell comments
- g. Searching for data
- h. Searching and replacing data
- i. Spell checking
6. Making Your Work Look Good
- a. Using AutoFormats
- b. Formatting cells and ranges
- c. Copying formats
- d. Formatting numbers
7. Selecting, Copying, and Moving Data
- a. Selecting cells and ranges
- b. Copying cells and ranges
- c. Moving cells and ranges
8. Using Formulas and Functions
- a. Using formulas
- b. Identifying formula errors
- c. Using absolute, relative, and mixed references
- d. Using functions in your formulas
- e. Using the formula palette
9. Managing and Analyzing your Data
- a. Filtering and sorting lists
- b. Performing advanced filtering
- c. Goal-seeking (making a formula return a desired value)
- d. Performing what-if analysis (scenarios)
10. Charting
- a. Using the chart wizard
- b. Charting basics
- c. Changing the chart type
- d. Dealing with chart elements
