Skip Navigation
PowerCampus Logo Close Window

2020 Fall 3rd 5 Weeks
CAPS123/Lecture/M01 - Advanced Spreadsheets | Credits 1.00
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.



Registration Type Traditional
Fees N/A
Instructors Pask, Margery J
Duration 11/12/2020 - 12/18/2020
Schedule MW  3:30 PM - 5:10 PM;  TCCC/Main-Dryden, Main, Room 215C
Credit Types Audit Credit Contract Dual Credit Equiv. Credit Global Connections International Educat Proficiency Exam Permission to Attend Regional Summer Sch Sr Audit Tech Prep X-Enroll
Class 24 Seats | 22 Remaining

Primary population and other student populations allowed to register for this course:
 Primary Population# Others Allowed# Others Registered
Campus  Tompkins Cortland Community College240
Program  Under Grad240
College  Acct/Bus./Int'l Bus.242
Department  Computer Applicatns242
Class Level  First Year241
Population  General241