BT 223 MS EXCEL for Business-Expert

The course presents advanced features of Excel useful in typical business situations. The focus is on using Excel as a tool to create useful, well-documented business spreadsheets. Student projects deal with intermediate to advanced scheduling, marketing, financing and production problems. This course also introduces strategies for independent learning about Excel.

Credits

4

Prerequisite

BT 123 and MTH 095 or higher, or instructor consent

Course Learning Outcomes

Upon successful completion of this course, the student will be able to:
1. Create, modify, share, and manage complex business workbooks and worksheets for organizations of any size
2. Use templates, automated procedures, and the Web to retrieve, analyze, and summarize data
3. Organize and analyze data through use of scenarios, solver, Lookup and Reference functions, and Database functions
4. Use text functions to parse, convert and manipulate text
5. Use business-modeling tools to perform what-if analysis
6. Build and use financial formulas
7. Know how to learn new Excel tools independently and be able to teach the skill to others
8. Use linking of cells, formulas, functions, worksheets and workbooks to gather information and complete analysis
9. Successfully complete the Microsoft Office Specialist: Excel 2003 Expert exam should the student choose to take the exam