BTE 112 Excel I

5 credits

This is a beginning and intermediate course in spreadsheets. Topics covered include document creation, retrieval, entering text, numbers, and formulas, formatting, financial functions, what-if analysis, graphs, and charts.

Prerequisites: BTE 120 or instructor permission.

Quarters Offered: All

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

Create, name, retrieve, and exit a spreadsheet
Enter and format labels and values
Enter simple and complex formulae
Use functions, what-if, and lookup commands
Adjust row height, column width, margins for printing
Use appropriate data to create pie, column, bar, and 3-D charts

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