BA 144 - Applied Excel in Business

Description
This course develops applied Excel skills for business decision-making. Students learn to build and modify spreadsheets, apply formulas and functions, create charts, and construct models that integrate data across worksheets. The course emphasizes analytical techniques for evaluating business scenarios and introduces practical methods for organizing and preparing data to support decision-making.

Credit Hours: 3
Contact Hours: 3
Prerequisites/Other Requirements: None
English Prerequisite(s): None
Math Prerequisite(s): None
Course Corequisite(s): None
Academic Program Prerequisite: None
Consent to Enroll in Course: No Department Consent Required
Dual Enrollment Allowed?: Yes
Number of Times Course can be taken for credit: 1
Programs Where This Course is a Requirement:
Pre-Accounting, A.B. (3+1, Davenport University), Pre-Business, A.B. (3+1, Davenport University), Pre-Business, A.A. (Grand Valley State University), Pre-Management, A.B. (3+1, Davenport University), Pre-Marketing, A.B. (3+1, Davenport University)

Other Courses Where This Course is a Prerequisite: None
Other Courses Where this Course is a Corequisite: None
Other Courses Where This course is included in within the Description: None

General Education Requirement:
None
General Education Learner Outcomes (GELO):
NA
Course Learning Outcomes:

Construct accurate, well-structured worksheets using appropriate data types, formulas, functions, and formatting to solve business problems.
Analyze and summarize data using logical functions, retrieval functions, tables, database tools, PivotTables, and PivotCharts to support business decision-making.
Communicate findings visually by creating charts and other representations that clearly convey patterns, relationships, and business insights.
Prepare and clean data from multiple sources to ensure it is organized, reliable, and ready for analysis.
Develop multi-worksheet and multi-workbook Excel applications using auditing tools, data validation, macros, protection features, templates, and VBA functions.
Apply forecasting and optimization tools, such as data tables, Scenario Manager, and Solver, to evaluate and compare business scenarios.

Course Outline:
I. Create, Navigate, Work with, and Print Worksheets

II. Formats, Functions, and Formulas

III. Cell References, Named Ranges, and Functions

IV. Effective Charts

V. Complex Logical and Retrieval Functions

VI. Integrating Complex Functions into Business Analysis

VII. Multiple Worksheets, Workbooks, and Templates

VIII. Building an Application with Multiple Worksheets and Workbooks

IX. Organize, Import, Export, and Cleanse Data Sets

X. Data Tables, Scenario Manager, and Solver

XI. Visual Basic

Approved for Online and Hybrid Delivery?:
Yes
Instructional Strategies:
Individualized Instruction (Observe/Coach): 75-95%

Lecture/Demonstration: 5-25%
Mandatory Course Components:
None
Equivalent Courses:
None

Accepted GRCC Advanced Placement (AP) Exam Credit: None
Name of Industry Recognize Credentials: None

Course-Specific Placement Test: None
Course Aligned with ARW/IRW Pairing: N/A

Mandatory Department Assessment Measures:
None

GRCC Course Type:
Program Requirement: Meets the learning needs of students in a specific GRCC program.
Course Format:
Lecture - 1:1
Total Lecture Hours Per Week: 3
People Soft Course ID Number: 105049
Course CIP Code: 52.9999
Maximum Course Enrollment: 24
Course Software Utilized: Microsoft Excel

School: School of Business & Industry
Department: Business
Discipline: BA
First Term Valid: Fall 2020 (8/1/2020)
1st Catalog Year: 2020-2021
Faculty Credential Requirements:
Master’s Degree (GRCC general requirement)
Faculty Credential Requirement Details:
Master’s degree in Business or business related field (such as Accounting, Finance, Sales, Marketing, Production and Operations Management).

Major Course Revisions: N/A
Last Revision Date Effective: 20260219T14:43:44
Course Review & Revision Year: 2030-2031