ACCT1124 - Spreadsheet Applications

Competencies

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