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