CMPT 2460 - Advanced Microsoft Excel Spreadsheet

Institution:

University of Toledo

Subject:

Description:

Covers advanced features of Excel to design and create accurate, professional worksheets using advanced functions and formulas. These include financial, logical, statistical, lookup, and database functions. Hands-on exercises include exploring the advanced features of data tables, creating complex graphs, using pivot tables; performing "what-if" data analysis, examining various scenario models, protecting and sharing workbooks, using 3-D cell references, automating with macros; and importing, exporting, and distributing data, and customizing the software to suit various needs.

Credits:

2.00

Credit Hours:

Prerequisites:

CMPT 1410 FOR LEVEL UG WITH MIN. GRADE OF D-

Corequisites:

Exclusions:

Level:

Instructional Type:

Lecture

Notes:

Additional Information:

Historical Version(s):

Institution Website:

www.utoledo.edu/

Phone Number:

(419) 530-4636

Regional Accreditation:

North Central 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.