CIS 125E Excel-Workbooks
Lecture Hours: 4
Credits: 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.
Students cannot receive credit for both BA 169Z and CIS 125E. Please consult with an academic advisor if you have any questions regarding course equivalencies and credit eligibility.
Prerequisite: CIS 101 or CIS 120 , either with a grade of C or better; or consent of instructor.
Student Learning Outcomes:
- Create and manage worksheets using appropriate data formatting.
- Construct formulas with relative, absolute, and mixed cell references.
- Analyze data using logical, lookup, mathematical, statistical, and text functions.
- Manipulate large volumes of data using datasets and tables.
- Interpret data using data visualization tools, including pivot tables and charts.
Content Outline
- Workbook Overview
- Workbook Text and Data
- Calculations with Formulas and Functions
- Chart Financial Data
- Excel Tables, Pivot Tables, and Pivot Charts
- Multiple Worksheets and Workbooks
- Excel Application
- Advanced Functions
- Business Intelligence
|