Catalog 2017-2018 
    Jul 28, 2021  
Catalog 2017-2018 [ARCHIVED CATALOG]

BTE 212 Excel II

5 credits
This course covers in-depth theory and application of spreadsheets. Topics include macros, databases, what-if analysis, pivot tables, import/export, advanced formulas and creating and managing files.

Prerequisites: BTE 112  and MATH 087  (or equivalent placement scores for MATH 098  or higher), or instructor permission.

Quarters Offered: Winter, Spring

Student Outcomes/Competencies:
Upon successful completion of this course students will be able to:

  • Work quickly and accurately in a spreadsheet application
  • Demonstrate proficiency in creating, modifying, and enhancing worksheets
  • Use advanced formula writing, functions, and templates
  • Solve problems and analyze data in business-related areas
  • Audit work
  • Create, modify, format, save, and print databases
  • Import and export data
  • Gather data and generate charts

Total Hours: 60 Lecture Hours: 40 Lab or Clinical Hours: 20