Tompkins Cortland Community College

CAPS123 - Advanced Spreadsheets

Advanced topics in Microsoft Excel that fulfill most of the objectives for the Microsoft Office Specialist (MOS) Expert Exam in Excel. Topics include planning, recording, running and editing macros, creating VBA procedures, enhancing charts, adding sparklines, identifying data trends, using what-if-analysis (scenario manager, goal seek, data tables), analyzing data, creating PivotTables and PivotCharts, exchanging data with other programs such as Microsoft Word, PowerPoint and Access, sharing, customizing and maintaining workbooks, importing and exporting data and auditing worksheets. Students taking this course in an online format should have access to a computer with Excel. Prerequisites: CAPS 121; RDNG 116 if required by placement testing; ENGL 099 or prior completion or concurrent enrollment in ESL 120, 121, and 122 (or prior completion of ESL 103) if required by placement testing; prior completion or concurrent enrollment in MATH 090 if required by placement testing. 1 Cr. (2 Lec., 2 Lab. for 5 weeks) Fall and spring semesters.