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

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

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

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