BA 169Z Data Analysis Using Microsoft Excel
Lecture Hours: 4
Credits: 4
Covers Microsoft Excel software skills necessary for evidence-based problem-solving, including workbook editing, formula creation, charting, and pivot tables. Emphasizes hands-on learning using Excel functions to perform data analysis to enhance decision-making.
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.
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
|