Units: |
2.00 |
Prerequisite: |
CISA 315 (Introduction
to Electronic Spreadsheets) with a grade of "C"
or better |
Hours: |
27 hours lecture, 27
hours laboratory |
Description: |
This course is a
continuation of electronic worksheets with emphasis
on workbook design and integration, template design,
use of complex formulas, and built-in financial,
logical, and database functions. It also includes
look-up tables, the use of worksheet analysis tools,
macros, and data integration. |
|
Section 3: Learning Outcomes and Objectives
Upon completion of this course, the
student will be able to:
- apply conditional formatting by entering parameters
for rules, utilizing predefined rules and constructing
new rules for individual or grouped worksheets.
- restrict data entry and ensure data integrity by
creating validation criteria and rules.
- create and edit links to external references and
other workbooks.
- construct formulas using named ranges and advanced
features of financial, logical, lookup, and database
functions.
- produce a worksheet database and manipulate,
extract, and analyze data by applying advanced math
functions and data filtering options.
- integrate data from various computer applications
and web sites into a workbook using consolidation
techniques and prepare workbook data for distribution to
other applications.
- create, edit, and format a PivotTable and
PivotChart.
- audit a worksheet using auditing tools to trace
precedents, troubleshoot, and resolve errors in
formulas.
- create, edit, and run macros using shortcut key
combinations.
|