May 28, 2022  
2021-2022 Lane Community College Catalog 
    
2021-2022 Lane Community College Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

BT 123 - MS EXCEL for Business

4 Credit(s)

This course introduces students to the use of Microsoft Excel to analyze questions found in a typical business setting. Students will create accurate, professional-looking spreadsheets and graphs. This course will also explore Google sheets and their business application.

Prerequisite: CIS 101  or CS 120  or BT 120  and MTH 065  or higher or equivalent math placement test. Recommend the ability to accurately type 30 words per minute and key 130-132 strokes per minute on an electronic calculator (or numeric keypad). Visit lanecc.edu/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, and manage common business workbooks and worksheets for organizations of any size
2. Use cell, row and column, and worksheet formatting techniques to create professional-looking spreadsheets
3. Use absolute and relative cell references to create flexible formulas and functions
4. Analyze data through the use of filters, pivot tables, formulas, and functions
5. Create, modify, and position diagrams and charts based on worksheet data
6. Apply and modify cell formats and styles, row and column formats, and worksheet formats
7. Use sophisticated Excel functions to perform sensitivity analysis to solve business problems
8. Manage workbooks by using templates, moving, inserting, deleting content, organize worksheets, setup pages for printing, file management and saving data in appropriate formats



Add to Portfolio (opens a new window)