Portland Community College | Portland, Oregon

Course Number:
BA 210
Course Title:
Advanced Accounting Spreadsheet Application
Credit Hours:
Lecture Hours:
Lecture/Lab Hours:
Lab Hours:
Special Fee:

Course Description

Presents the advanced functions of electronic spreadsheets as related to the accounting profession. Also applies to finance, marketing, operations, and other business occupations. Prerequisites: WR 115, RD 115, and MTH 20 or equivalent placement scores. Recommended: CAS 170 or BA 111 or BA 211. Audit available.

Addendum to Course Description

Improve computation skills as related to business by using spreadsheets with emphasis on critical thinking. 

Intended Outcomes for the course

  • Develop accurate, readable worksheets for a variety of business applications.

  • Use critical thinking to independently design and create complex worksheets.

Outcome Assessment Strategies

  • Performance tests

  • Objective tests

  • Individual Project

Course Content (Themes, Concepts, Issues and Skills)

Themes, Concepts, Issues: 

  • Communicate effectively using appropriate spreadsheet vocabulary.

  • Use critical thinking in designing spreadsheets for business applications.

  • Proofread for accuracy in the entry of data and creation of formulas.

  • Assess the document for readability.

  • Make effective use of spreadsheets with other applications including the Internet.

Competencies and Skills: 

  • Use spreadsheets to manage financial data.

  • Create formulas and use functions for business.

  • Plan, create, modify, and enhance the appearance of spreadsheets and charts.

  • Use list features such as conditional formatting, sorting, and filtering.

  • Use pivot tables and PivotCharts to summarize data in lists.

  • Create templates and use 3-D referencing to consolidate data.

  • Use lookup tables and linking to increase productivity.

  • Generate Web pages and hyperlinks to other documents.

  • Use spell check and auditing tools to assure accuracy of documents.

  • Design spreadsheet applications using natural language, validation, logical, and protection features.

  • Create macros using the macro recorder; edit and print macros using Visual Basic Editor.

  • Perform cost-volume-profit analysis using one- and two-variable data tables.

  • Enhance decision-making skills by using the scenario manager, goal seek, and the solver features.

  • Import data into Excel from text files, databases, the Internet, and XML documents.

  • Use Visual Basics to enhance business applications.