Our Programs‎ > ‎Business Technology‎ > ‎Accounting‎ > ‎

Spreadsheets 1 and 2

Spreadsheets I

Students work at their own pace preparing spreadsheets using Microsoft Excel software.  Students who are new to spreadsheets and those who have some experience preparing spreadsheets will be able to work independently at their own level.  This is an excellent, elective course to be taken with accounting courses.

The class begins with the basics of creating a worksheet and advances to intermediate topics of table lookup, database functions, and customizing a worksheet for the user's need.

Suggested Prerequisites

  • Keyboarding
  • Basic computer literacy
Length: One year
Grades: 10,11, 12, and Adult
Clock Hours: 122
Microsoft Office Specialist (MOS) certification (Core and Expert Levels), which are becoming an industry standard, can be obtained after successfully completing the testing requirements. HCTC students showing aptitude for a MOS exam will have their test fee waived (normally $65 per test).

Spreadsheets II

Second-year spreadsheets will allow students to utilize critical thinking and accounting concepts, while applying advanced features of spreadsheet design and implementation.

Prerequisites for Spreadsheets II

  • Spreadsheets I with a grade of “C” or better
Length: One year
Grades: 10,11, 12, and Adult
Credits: 1
Clock Hours: 122

Job Opportunities:

The demand will continue to expand for individuals to successfully interact with the computer to create spreadsheet documents, gather information, and solve problems.  The spreadsheet skills paired with accounting skills will prepare a person for entry level employment as:
  • Bookkeeper
  • Spreadsheet designer & analyst
  • Data entry clerk
  • Office clerk

Learning Activities:

  • Keyboarding
  • Math Skills
  • Spreadsheets
  • Integrated software packages
  • Job-seeking skills
  • Maintain records using a spreadsheet
  • Create reports using a spreadsheet