Skip to main content

National College Credit Recommendation Service

Board of Regents  |  University of the State of New York

Search Google Appliance

Coopersmith Career Consulting | Evaluated Learning Experience

Microsoft Excel (TCH-163)

Location: 
Various, distance learning format.
Length: 

Varies (self-study; self-paced).

Dates: 
July 2013 - Present.
Instructional delivery format: 
Proficiency exam
Learner Outcomes: 

Upon successful completion of the course, students will be able to: create worksheets and present them in different ways showing various fonts, styles, sizes, colors, etc.; use the power of Excel to automatically calculate mathematical data and apply it seamlessly to spreadsheets; copy cells and ranges of cells and perform other complex manipulations of spreadsheets, including adding charts, subtables, etc.; perform financial functions and data tables to produce amortization schedules and use Excel's formula checking function to minimize the possibility of error; create, sort, and query tables and the data within them; work with multiple worksheets and separate workbooks; and create templates by working with other features such as art, images, and screenshots to work these features into an Excel spreadsheet.

Instruction: 

This self-study comprehensive course covers all the functions and features of Excel 2010 for students of any skill level. Major topics include: introduction to spreadsheet terminology, Excel's components, entering and editing text, values, formulas, and pictures, absolute and relative references, ranges, rows, and columns, advanced formatting options, lookup functions, data validation, database functions, and using simple and complex formulas to assist with calculations.

Credit recommendation: 
In the lower division associate/baccalaureate degree category, 2 semester hours in Computer Applications, Information Management, Information Systems, or as General Elective (8/13).

Top