2021-2022 Pierce College Catalog 
    Apr 25, 2024  
2021-2022 Pierce College Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

CIS 138 Applied Spreadsheet Application II (2 credits)

Prerequisite CIS 137  with a 2.0 or higher.

Course Description
Microsoft Excel is an integral part of most business organizations. It is a robust data tracking, analytical, and decision-making tool used by for-profit and non-profit organizations around the world. It is commonly applied for operational, marketing, and financial computations decision-making. Business professionals who hold Excel certifications demonstrate facility with this powerful software and ability to add value to an organization. This course covers the advanced topics in Microsoft Excel and ties to the second level Microsoft Office Specialist (MOS) certification exam.

Student Outcomes
1. Manage workbook options and settings such as templates, ribbons, macros, protection, and versions.
2. Apply custom number, conditional, filtering, color, style, theme, and international formats and layouts.
3. Create and use advanced date, time, logical, statistical, financial, and lookup formulas/functions.
4. Create advanced charts and tables to include trend-lines, dual-axis, chart templates, Pivot Tables, Pivot Charts, and Slicers.
5. Maintain safe, secure, and valid data and spreadsheet files according to business and legal requirements.
6. Solve business problems in such fields as accounting, finance, operations, and marketing using spreadsheet capabilities.
7. Provide legal, owner, and user spreadsheet documentation.

Add to Portfolio (opens a new window)