INT-2140 Problem Solving with Spreadsheets

Credits: 3
Problem Solving with Spreadsheets is a comprehensive course using electronic spreadsheet software with an emphasis on managing workbook options and settings as well as creating advanced formulas, macros, charts, and tables. Using Microsoft Excel, students solve problems and analyze financial and other data. In addition, students effectively present data from spreadsheets in charts. This course helps prepare students for Microsoft Office Specialist certification exams. This course may also be taken as TEC-532 Problem Solving with Spreadsheets: MOS Excel Preparation

Prerequisite(s): INT-1010 with grade of C or higher.

Course Outcomes

Construct a variety of financial, statistical, logical, and other spreadsheet formulas and functions to solve problems.
Format spreadsheets for ease of reading and effective presentation of data.
Create multi-spreadsheet workbooks with formulas and functions.
Use advanced tools such as Excel tables, solver, and pivot tables.
Create a chart to display data.
Improve spreadsheet functionality through tools such as validation, protection, and macros.