BT 123 MS EXCEL for Business

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 may also explore Google Sheets and other software in a business context. Note - computer required (chromebooks/tablets will not suffice)

Credits

4

Prerequisite

BT 120 or any 4+ credit CIS/CS course and MTH 065 or higher or equivalent via the math placement process

Course Learning Outcomes

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