ACCT1124 - Spreadsheet Applications

Credits
3 (3/0/0)
Description
This course covers use of a computerized spreadsheet system for accounting applications. Topics include document creation, storage and retrieval, editing, printing, chart creation, database applications and file distribution.
Prerequisites
Competencies
  1. Perform formula entry and auditing procedures.
  2. Create and format charts.
  3. Use relative, mixed and absolute cell references in formulas and functions.
  4. Apply financial, statistical and logical functions to calculate, report and analyze business data.
  5. Consolidate data across multiple worksheets and workbooks.
  6. Utilize tables for advanced queries and database functions.
  7. Use data analysis tools including data tables, pivot tables and charts.
  8. Import and format data from external sources.
  9. Use advanced filtering and sorting techniques.
Degrees that use this course

Accounting AAS

Associate of Applied Science (AAS)

Accounting Clerk

Diploma

Business

Associate of Applied Science (AAS)

Business Entrepreneurship

Associate of Applied Science (AAS)

Business Entrepreneurship

Diploma

Payroll Specialist

Diploma