Skip Navigation
Distance Learning
Home > Academics > eLearning > Course Formats > Online > CMSY Online Courses > CMSY 117 Advanced Spreadsheets - Online

CMSY 117 Advanced Spreadsheets - Online

After successful completion of this course, the student will be able to use Microsoft® Excel to apply advanced formatting techniques and functions, perform what-if analysis, create PivotTables, use custom and advanced filters, and audit worksheets. This course may be completed in fewer than 14 weeks. All of the work (except tests) may be done outside of class if student has compatible software. 

Credits                                    1
Prerequisites                            CMSY-101 Beginning Spreadsheets
Instructor                                Joanne Kearns
Office Technology Classroom    DH 101
Phone                                      (443) 518-4876

Registered Students | Overall Course Objectives | Major Course Topics | Course Format | Orientation | Course Requirements | Materials | Exams |

Registered Students

Immediately after enrolling, please go to, choose the semester, and complete the pre-semester notification form.

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.

Top of Page

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

Top of Page

Course Format

  • This course is not self-pace.  However, students may accelerate their page so that they may finish the course fewer than 14 weeks.
  • The syllabus lists course requirements.
  • This schedule is posted in the learning management system and is available for students all semester.
  • No on-campus meetings are required.  However, this course does require on-campus attendance for tests.  The tests may be taken during any open hours in the Office Technology classroom. please note, however, that all CMSY117 students are welcome to come to the Office Technology classroom to do classwork and/or to receive personal help from an instructor.
  • Modules contain course instructions.
  • Canvas learning management system is the method of communication.
  • Real-time chats are not required.

Top of Page


This course has a mandatory face-to-face orientation held on the Saturday morning prior to the semester start.  Please click on to view the orientation schedules.

Top of Page

Course Requirements

For complete technical requirements, specific course instructions, and information to help you assess options that best fit your lifestyle and learning style, visit

  • This course is for students who have completed CMSY-101 Beginning Spreadsheets.
  • If you feel that you already have the skills included in CMSY-101 Beginning Spreadsheets, call Cindy Garnsey at 443-518-4502 or 443-518-4876 for more information.
  • Come to the Office Technology classroom to take tests which have deadlines for completion.
  • Microsoft Excel 2010.
  • Complete three homework assignments which have deadlines for completion.

Top of Page

 Texts and Materials Required

Microsoft Excel 2010 Level 2, Benchmark Series
Rutkosky and Rutkosky | Course Technology, Cengage Learning, 2011 | ISBN: 978-0-76384-315-1

Two flash drives

Additional textbook information:  Please visit and follow the instructions for selecting textbooks.

Technical Requirements for Online Students:

Review the Technical Requirements link above. The course requires 

  • A web browser

Top of Page


For purposes of verification and assessing learning outcomes, this course has three theory exams and three production exams, which have deadlines for completion.  The exams must be taken at the college during any open hours in the Office Technology classroom.    

If you have any questions or comments about this course, please send a message to Cindy Garnsey,

Last updated on July 9, 2013

© Howard Community College, 2012

Top of Page | Online Courses Home | eLearning Home | HCC Home

Student Profile - Maribel