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 87 (or equivalent placement scores for MATH 98 or higher)

Course Outcomes
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

Program Outcomes
This course teaches to the following program outcomes:

be prepared for entry-level positions as a business support professional
carry out office administration procedures and management support using office technology
use Microsoft Office software to produce complex integrated documents and spreadsheets

Total Hours: 60 Theory (Lecture) Hours: 40 Guided Practice (Lab or Clinical) Hours: 20