Excel 2000 - XP Level III

Institution:

Tompkins Cortland Community College

Subject:

Description:

You will learn to: use names to assign descriptive labels to cells; use logical and financial functions to calculate values based on conditions use lookup functions to return values from table use data tables to view the effects of multiple input values on a formula use data forms and validation to facilitate data entry in lists create and use Pivot Tables to analyze and compare large amounts of data import data from and export data to external databases use Goal Seek and Solver to perform what-if analyses, and use custom scenarios and views to manage different versions of worksheets run and record macros to automate complex or repetive tasks publish a worksheet as an interactive web page Prerequisites: Excel Level II or wquivalent knowledge

Credits:

3.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Lecture

Notes:

Additional Information:

Historical Version(s):

Institution Website:

www.TC3.edu

Phone Number:

(607) 844-8211

Regional Accreditation:

Middle States Association of Colleges and Schools

Calendar System:

Semester

The Course Profile information is provided and updated by third parties including the respective institutions. While the institutions are able to update their information at any time, the information is not independently validated, and no party associated with this website can accept responsibility for its accuracy.