CIT 155 - Excel Spreadsheets

Credits: 3
3 Lecture Hours

Prerequisites: Basic skills using a personal computer and Windows operating system, keyboarding and basic exposure to Microsoft Office. Ability to effectively manage Windows files and folders. Eligibility for MAT 090.

Description
This course introduces students to electronic spreadsheets, tables and charts for solving business and technical problems using Microsoft Excel. Students learn through applied and project-based activities that go beyond the mechanics of the software. Students utilize critical thinking activities for applied learning and problem solving. Topics include statistical, mathematical, financial and data analytical functions.

Learning Outcomes
Upon successful completion of the course, the student will:

Create effective worksheets and workbooks with formulas and functions.
Create and manage Excel tables, charts, PivotTables and PivotCharts.
Perform data analysis using What-If, Goal Seek, Scenario Manager and Solver.
Look up data using advanced functions.
Prepare workbooks for collaboration.
Create and modify macros.
Apply advanced conditional formatting and filtering.

Listed Topics

Excel workbook fundamentals
Formulas and functions
Cell, worksheet and workbook enhancements
Charts and chart tools
Pivot tables, charts and slicers
Workbook management
Advanced worksheet formatting
Advanced functions and formulas
Data analysis tools
Macro management

Reference Materials
Textbooks/material, current and appropriate software, multimedia for lecture and demonstration as required by instructor, access to the Internet.

Students who successfully complete this course acquire general knowledge, skills and abilities that align with CCAC’s definition of an educated person. Specifically, this course fulfills these General Education Goals:

Technological Competence
Critical Thinking & Problem Solving

Approved By: Dr. Quintin B. Bullock Date Approved: 01/02/2020

Course and Section Search

Print this Page

Catalog Home

CIT 155 - Excel Spreadsheets