Skip Navigation
Close Window
2020 Spring 3rd 5 Weeks
CAPS123/Lecture/BL2 - 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
View Book Information
Registration Type
Traditional
Fees
N/A
Instructors
Cancelled, Class
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
| 20
Remaining
Primary population and other student populations allowed to register for this course:
Primary Population
# Others Allowed
# Others Registered
Campus
Tompkins Cortland Community College
20
0
Program
Under Grad
20
0
College
Acct/Bus./Int'l Bus.
20
0
Department
Computer Applicatns
20
0
Class Level
First Year
20
0
Population
General
20
0