| |
Oct 23, 2026
|
|
|
|
|
BUS 1143 - Decision Making Using Excel
Credits: 3
Catalog Description
This comprehensive course focuses on using Microsoft Excel to design spreadsheets that organize, manage, and provide analysis on personal or organizational data. Students will use problem solving and critical-thinking skills to make decisions based on Excel spreadsheets. This course covers basic to advanced features in Microsoft Excel such as creating, editing, and formatting worksheets and workbooks; constructing formulas and using functions; charting data; creating Excel tables, PivotTables, and PivotCharts; conducting what-if analysis; importing data from external sources; working with other programs; and running macros. The course is taught using the current Windows version of Microsoft Excel 365. After successfully completing this course, students will have been introduced to the majority of the spreadsheet procedures found in the Microsoft Office Specialist (MOS) Excel certification exam.
Recommended Skills, Abilities, or Coursework: BUS 1112
Additional fee to student: No
Learner Outcomes
- Design spreadsheet files that effectively display, organize, manage, and secure data.
- Enter, edit, and troubleshoot formulas, functions, macros, and other spreadsheet procedures.
- Select charts to graphically represent specified data.
- Import data into spreadsheet files from outside sources and programs.
- Analyze data and make decisions based on spreadsheet results.
Major Areas of Course Content
- Getting Started with Excel
- Formatting Workbook Text and Data
- Performing Calculations with Formulas and Functions
- Analyzing and Charting Financial Data
- Generating Reports from Multiple Worksheets and Workbooks
- Managing Data with Data Tools
- Summarizing Data with PivotTables
- Performing What-If Analyses
- Exploring Financial Tools and Functions
- Analyzing Data with Business Intelligence Tools
- Exploring PivotTable Design
- Developing an Excel Application
Credit for Prior Learning Options
Course-Specific Exam
Credit for Prior Learning Option Procedure(s)
Student must take an Excel production exam that includes creating several workbooks with varying complexity. Students will be asked to bring in and discuss a portfolio of previously created Excel workbooks.
Add to Portfolio (opens a new window)
|
|
