CMSY 117 Advanced Spreadsheets (Online)This course is a hands-on course that covers advanced Excel skills and includes advanced formatting techniques and functions, what-if analysis, PivotTables, custom and advanced filters, and auditing worksheets.
| Credits | 1 |
| Prerequisites | CMSY-101 Beginning Spreadsheets |
| Fees | This course has fees totaling $10.00. |
| Instructor | Joanne Kearns |
| Office Technology Classroom | ELB-301 |
| Phone | (410) 772-4876 |
| Email | jkearns@howardcc.edu |
Registered Students | Overall Course Objectives | Major Course Topics | Course Format | Orientation | Course Requirements | Materials | Exams |
Registered Students
Immediately after enrolling, send Joanne Kearns an e-mail at jkearns@howardcc.edu; include your name, the semester, the course and section. You will receive specific course instructions the week classes start.
Overall Course Objectives
Once you have completed this course you will be able to:
- Retrieve records using AutoFilter and custom filter.
- Insert automatic subtotals, use lookup functions to locate list entries, and apply database functions to summarize list data that meets specific criteria.
- Use advanced financial, statistical, logical, text, lookup, and math functions.
- Track what-if scenarios and generate summary reports using Excel Scenario Manager.
- Use Goal Seek to perform what-if analysis involving multiple variables.
- Plan, design, create, update, and change the layout of a PivotTable report.
- Exchange data between Excel and other Windows programs which includes embedding and linking.
- Create a shared workbook.
- Perform a worksheet audit and add comments.
- Record and run a macro.
Major Course Topics
- Working with lists
- Sorting a list using multiple criteria
- Creating a custom filter
- Filtering a list with AutoFilters
- Extracting list data
- Creating subtotals using grouping and outlines
- Using data validation
- Using advanced functions
- Using financial functions: PPMT, NPV, and PV
- Using math and trig functions: SUMIF and RAND
- Using statistical functions: COUNTIF, AVERAGEIF, and SUBTOTAL
- Using database functions: DSUM and DAVERAGE
- Using lookup functions: VLOOKUP and HLOOKUP
- Using logical functions: IF, AND, OR, NOT, and IFERROR
- Using text functions: PROPER, UPPER, LOWER, and SUBSTITUTE
- Using analysis tools
- Performing a what-if analysis
- Creating scenarios
- Using Goal Seek
- Planning, designing, creating, and updating a PivotTable
- Creating a PivotTable report
- Projecting values using trendlines and regression analysis
- Exchanging data with other programs
- Importing data
- Embedding and linking objects
- Collaborating
- Setting up a shared workbook and tracking changes
- Applying and removing passwords
- Applying and removing cell, worksheet, and workbook protection
- Managing and auditing worksheets
- Auditing workbooks
- Recording, running, and editing a macro
- Working with templates and workbooks
- Creating and editing a template
- Managing workbook properties
- Consolidating data from several worksheets
- Using advanced formatting
- Creating custom formats
- Using conditional formatting
- Using themes
- Using Paste Special
Course Format
This course:
- Is not self-paced. However, you may accelerate your pace so that you may finish the course in fewer than 14 weeks.
- Does not require on-campus meetings. However, this course does require on-campus attendance for tests. Tests may be taken during any open hours in the Office Technology classroom. Please note, however, that all CMSY-117 online students are welcome to come to the Office Technology classroom to do classwork and/or to get personal help from an instructor.
- Does not require real-time chats.
- Uses email for communication.
Orientation
This course does not have a face-to-face orientation. You will receive detailed course information the week classes start.
Course Requirements
- Review the Checklist for Registered Online Students section of the Distance Learning Homepage.
- This course is for students who have completed CMSY-101 Beginning Spreadsheets. If you feel that you already have the skills included in Beginning Spreadsheets, you may take an exam to show that you have the skills to take Advanced Spreadsheets. Call Cathy Sutton at 410-772-4562 for more information.
- Install Microsoft Excel 2007 on your computer.
- Come to the college periodically to take both written and computer tests, which have deadlines for completion.
- Complete three homework assignments.
Materials
Required:
Seguin, Denise. Microsoft Excel 2007, Level 2, Windows XP Edition, Benchmark Series. Paradigm, 2008.
Buy your textbooks from our online Bookstore, or visit our Bookstore.
Technical Requirements for Online Students:
Review the Technical Requirements link above. The course requires
Exams
For purposes of verification and assessing learning outcomes, this course has six exams, which have deadlines for completion. The exams must be taken at the college during any open hours in the Office Technology classroom. There are three theory exams (written) and three production exams (taken on the computer).
