BUSN 218 - Spreadsheet Construction

5 Credits

Students will learn how to quickly build linked systems of spreadsheets for the analysis of accounting, financial and statistical data in order to provide useful information to business decision makers. Students also learn how to make basic to advanced business and financial calculations. Emphasis on math skills, critical thinking and spreadsheet construction theory.

Pre-requisite(s) BUSN 216 with min. 2.0
FeesCF

Quarters Typically Offered

Fall Day
Winter Online

Designed to Serve Students in AAS Business programs,or related programs. Business community needing advanced Excel skills.
Active Date 20190612T13:20:58

Grading Basis Decimal Grade
Class Limit 28
Contact Hours: Lecture 55
Total Contact Hours 55
Degree Distributions:
ProfTech Course Yes
Restricted Elective Yes
Course Outline

Types of data In Excel: Numbers, Text, Logical, Errors.
Stylistic formatting: Style Formatting, Page Setup, Styles.
Number Formatting, including Custom Number Formatting.
Formulas and Functions.
The eleven formula elements: Equal Sign, Cell References, Math Operators, Comparative Operators, Numbers, Text, Operators, Functions, Ampersand, Array Constants, Wild Cards.
The five types of formulas: Calculating, Text, Lookup, Array, Logical.
Eight types of cell references: Relative, Absolute, Mixed, Worksheet, Workbook, Defined Named Ranges, Formulas To Define Reference, Table Nomenclature.
Advanced formulas: Nesting, Mega-Formulas and Array Formulas.
Extensive coverage of categories of functions, including: Lookup, Finance, Statistical, Logical and Text.
Data analysis features: Sort, Filter, Advanced Filter, Subtotals, PivotTables, Data Import, Text To Columns.
Advanced Pivot Tables.
Advanced data analysis: Formulas and PivotTables.
Create efficient formula input areas and data analysis criteria areas that allow efficient spreadsheet construction and that automate data analysis and what if analysis.
What if analysis: Goal Seek and Scenario Manager.
Use Data Validation to validate data inputs.
Creating dynamic charts, including: Column, Bar, Stacked Column, Stacked Column, Pie, Pie Within Pie, Histograms, X-Y Scatter and Regression Line, X-Y Scatter Break Even, Line, Multiple Chart Type in One Chart, Dynamic Ranges, Sparklines.
Conditional Formatting: built-in features and Logical Formulas.
Recorded Macros.

Student Learning Outcomes
Explain and use the different types of data in Excel including distinguishing between raw data and information.

Import, clean and transform data.

Perform data analysis, creating useful information in the form of reports, visualizations and dashboards to facilitate business decisions.

Create intermediate to advanced formulas & functions for business calculations & data analysi

Build efficient spreadsheets models for calculations and data analysis.