Skip Navigation
PowerCampus Logo Close Window

2020 Spring 3rd 5 Weeks
CAPS123/Lecture/BL1 - 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 Wells, Frances B
Duration 4/10/2020 - 5/15/2020
Schedule WEB  12:00 AM - 12:00 AM;  Distance Learn - Web, Distance Learning - Web, Room BBoard
Credit Types Audit Credit Contract Dual Credit Equiv. Credit Global Connections International Educat On-line Dual Credit Proficiency Exam Permission to Attend Regional Summer Sch Sr Audit Tech Prep X-Enroll
Class 20 Seats | 7 Remaining

Primary population and other student populations allowed to register for this course:
 Primary Population# Others Allowed# Others Registered
Campus  Tompkins Cortland Community College200
Program  Under Grad200
College  Acct/Bus./Int'l Bus.205
Department  Computer Applicatns2013
Class Level  First Year208
Population  General203