BUS 199 - Directed Study

Unit(s): 1 to 4

Course Description: This course is designed specifically for students who speak Mandarin and wish to learn the fundamentals of Excel 2013 as it is used for common business applications. A translator will be present in the room at all times while the class meets, translating all lectures, questions, and answers. Extensive use of the Lynda.com tutorials will be used, accessible by all USF students.

Primary Learning Goal:

1. To attain proficiency in the use of Excel 2013 spreadsheet technology for managing common analytical problems all businesses face.

Secondary Learning Goals: At the end of this course, students should be knowledgeable regarding the following:

1. Elements of the Excel screen and basic navigation

2. Principles of worksheet structure

3. Introductory and advanced formulas and functions

4. Formatting in depth

5. Charting in depth

6. Pivot Tables in depth

7. Cleaning data

8. Power Shortcuts

9. Interaction with other Office 2013 software

School of Management