Consortium for International Studies | Evaluated Learning Experience
Microsoft Excel CIS 103
Various; distance learning format.
September 2018 - Present.
Upon successful completion of this 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; 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 include these features in an Excel spreadsheet.
This self-study comprehensive course covers all the functions and features of Excel 2016 for students of any skill level. Major topics include: introduction to spreadsheet terminology, Excel's components, entering and editing text, values, formulas, charts 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 Business, Information Systems, or Information Technology (8/18).