Dec 02, 2022  
2021-2022 Lane Community College Catalog 
2021-2022 Lane Community College Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

BT 223 - MS EXCEL for Business-Expert

4 Credit(s)

Advanced Excel functions for business problem solving. Focus on creation of effective business spreadsheets to assist managers in decision making.

Prerequisite: BT 123  and MTH 095  or higher, or instructor consent. Recommend the ability to type 30 words per minute. Visit business for Business Department keyboarding guidelines or contact the instructor for details.
Learning Outcomes

Upon successful completion of this course, the student should 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.

Add to Portfolio (opens a new window)