Skip to main content
National College Credit Recommendation Service
Coopersmith Career Consulting | Evaluated Learning Experience
Microsoft Excel (TCH-163)
Various;distance learning format.
Varies (self-study; self-paced).
Instructional delivery format:
Upon successful completion of this proficiency exam, 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.
This self-study comprehensive exam 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.
In the lower division baccalaureate/associate degree category, 2 semester hours in Computer Applications, Information Management, Information Systems, or as General Elective (8/13) (8/18 revalidation).