|
|
Technology Education
 Excel
2007:
Intermediate
|
Workshop
description: |
|
This course provides
instruction in the following topics: creating and using Excel
tables (formerly lists); filtering and sorting tables; adding
subtotals to tables; adding data validation criteria; protecting
cells and worksheets; creating custom lists for data entry and
sorting; using 3-D references across worksheets; linking
workbooks; creating templates; using IF, PMT, FV, VLOOKUP, and
HLOOKUP functions; and creating and running macros. |
| |
|
|
|
Prerequisites: |
|
|
|
OLTE 8105 or
a basic familiarity with the editing and formatting data in
Excel |
| |
|
|
|
Materials needed: |
|
|
|
None |
| |
|
|
|
The facilitator: |
|
|
Jane Helton, BIT
instructor
224-3900 ext. 0470
jhelton@cnm.edu |
To register for this
event, use the online registration form built into the
Calendar
of Events. If you have any questions or problems registering,
please email Jean M. Garcia at
jmontano@cnm.edu.
|
|
