CIS 125E - Excel-Workbooks

Lecture Hours: 4
Credit Hours: 4

Provides the tools necessary to create and use basic spreadsheets presenting them in a multi-worksheet environment using Microsoft Excel. Includes concepts associated with data types; how to build effective workbooks for use in projection; and analysis of typical business situations. Includes workbook applications such as the use of arithmetic formulas, functions, proper formatting, macros, graphics, pivot tables, charts, and other analysis tools available in Microsoft Excel. Extends to Business Intelligence (Power BI) with Microsoft Excel as a database. Includes concepts such as defining data models, queries, and forecast projections using charts and trend analysis.

Prerequisite: CIS 101 or CIS 120, either with a grade of C or better; or consent of instructor.