Title

ACCT1124 - Spreadsheet Applications

Description

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.
API ID

Credits

3 (3/0/0)

Prerequisites

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.
Degrees that use this course

Degrees that use this course

Accounting
Degree:
Associate of Applied Science (AAS)
This program provides the knowledge and skills necessary to examine, analyze, interpret and correct accounting data for the purposes of...
Location:
Moorhead Campus
Online
Credits:
60
Accounting Clerk
Degree:
Diploma
This program provides the knowledge and skills necessary to perform routine calculating, journalizing, posting and verifying duties to...
Location:
Moorhead Campus
Online
Credits:
32
Agribusiness
Degree:
Associate of Applied Science (AAS)
This program includes courses in all major areas of agribusiness, including management, marketing, agronomy, animal science, precision...
Location:
Moorhead Campus
Online
Credits:
60
Business
Degree:
Associate of Applied Science (AAS)
Success in a business career in the 21st century requires preparation in core business subjects. In this program, students learn management...
Location:
Fergus Falls Campus
Moorhead Campus
Online
Credits:
60
Human Resources
Degree:
Associate of Applied Science (AAS)
Human resources programs prepare students to provide support to companies and individual employees in the area of human resources. Associate...
Location:
Online
Credits:
60
Payroll Specialist
Degree:
Diploma
This program provides the knowledge and skills necessary to perform routine calculating, journalizing, posting and verifying duties to...
Location:
Moorhead Campus
Online
Credits:
32