Credits

3 (3/0/0)

Description

This course provides students with in-depth coverage of a spreadsheet application as used in a business setting. Students should be familiar with Windows and word processing.

Prerequisites

BUS1100

Competencies

Demonstrate in-depth knowledge of the use of algebraic formulas for formula entry and auditing.
Demonstrate critical thinking skills in gathering, formatting and disseminating data.
Use relative, mixed and absolute cell references in formulas and functions.
Demonstrate in-depth knowledge of financial, statistical and logical functions to calculate, report and analyze business data.
Create and format charts.
Consolidate data across multiple worksheets and workbooks.
Import and format data from external sources.
Use data analysis tools including data tables, pivot tables and charts.
Use advanced filtering and sorting techniques.