Skip Navigation
PowerCampus Logo Close Window

2021 Spring Dual Cr
CAPS123/Lecture/D83 - 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.

    Teaching Mode:  Teaching Mode



Registration Type Traditional
Fees CE Spring Tuition $79.00 (Fee Group All)
Instructors Lojacono, Samuel D
Duration 4/28/2021 - 6/25/2021
Schedule WRF  9:26 AM - 10:06 AM;  GROTON CENTRAL SCHOO, Groton High School, Room GHS
Credit Types Dual Audit Dual Credit
Class 30 Seats | 20 Remaining

Primary population and other student populations allowed to register for this course:
 Primary Population# Others Allowed# Others Registered
Campus  Tompkins Cortland Community College300
Program  Under Grad300
College  Acct/Bus./Int'l Bus.3010
Department  Computer Applicatns3010
Class Level  First Year305
Population  General3010