Catalog Course Search Details

 Department:    BUS

 Course #:    220

 Credits:    5

 Variable:     No

 IUs:    5

 CIP:    52.1401

 EPC:    MAMBAAPT

 REV:    2024

 Course Description  

Develop intermediate spreadsheet skills for operational and financial analysis and business decision making. Use Microsoft Excel to generate, analyze, manage, and present data within a variety of business contexts.

 Prerequisite  

Prerequisite: BUS 120 with a grade of C or higher or instructor permission.

Contact Hours (based on 11 week quarter)

Lecture: 55

Lab: 0

Other: 0

Systems: 0

Clinical: 0

Intent: Distribution Requirement(s) Status:  

Vocational Preparatory Required for ATA degree  

Equivalencies At Other Institutions

Learning Outcomes

After completing this course, the student will be able to:

1. Build spreadsheets to solve problems and analyze data for specific business scenarios.
2. Find numerical solutions by writing arithmetic formulas and using basic to advanced built-in functions.
3. Generate possible outcomes for decision-making scenarios using what-if analysis tools.
4. Format worksheets to display and communicate data clearly and effectively.
5. Present data in visually meaningful ways with charts and other graphical enhancements.
6. Organize data into meaningful arrangements using tables, PivotTables, and sorting/filtering techniques.
7. Manage worksheets and workbooks including protecting workbook data.
8. Create spreadsheets that incorporate efficient construction and time-saving features such as templates, macros, data linking, built-in functions, and conditional formatting.

General Education Learning Values & Outcomes

Revised August 2008 and affects outlines for 2008 year 1 and later.

Course Contents

1. Guidelines for effective spreadsheet development.
2. Techniques for entering data efficiently, proofing/editing data, and checking accessibility.
3. Procedures for writing mathematical formulas.
4. Beginning to advanced functions (statistical, financial, math & trig, lookup, text, date & time, logical) including nesting functions.
5. Formula auditing techniques (trace precedents/dependents, error checking, and evaluating formulas).
6. Formatting techniques (number, text, styles, alignment, cells, page layout, format painter, etc.).
7. Data visualization tools such as charts, sparklines, and illustrations.
8. Data organization with PivotTables and Tables including methods for sorting and filtering data.
9. Worksheet and workbook management features including the protection of workbook data.
10. Techniques for linking and referencing data between cells, worksheets, and workbooks.
11. What-if Analysis tools including Scenario Manager, Goal Seek, and Data Tables.
12. Efficiency and time-saving spreadsheet tools such as templates, macros, conditional formatting, built-in functions that improve productivity (text, logical, lookup), and other shortcuts.