OTEC 1822 Microsoft Excel
Course Information
| Course Number | OTEC 1822 |
|---|---|
| Course Title | Microsoft Excel |
| Description | This course prepares students to work with Microsoft Excel in a career setting or for personal use. It begins with the introduction of concepts such as creating, editing, and formatting worksheets in a uniform, attractive style. It includes inserting formulas, creating charts, and enhancing the display of worksheets of varying complexity. The course will move on to the advanced concepts and features of formatting, using functions, analyzing numerical data, and projecting outcomes to make informed decisions. Features of protecting workbooks, using macros, using pivot tables, and customizing the Excel environment are also included. Current communication needs will be met by including hyperlinks to external information, as well as importing, exporting, and sharing data. (Prerequisite: none) |
| Total Credits | 4 |
| Total Hours | 64 |
| Instruction Type | Credits and Hours |
|---|---|
| Lecture | 4 Credits, 64 Hours |
Pre/Corequisites
None
Institutional Core Competencies
- Communication - Students will be able to demonstrate appropriate and effective interactions with others to achieve their personal, academic, and professional objectives.
- Critical and Creative Thinking - Students will be able to demonstrate purposeful thinking with the goal of using a creative process for developing and building upon ideas and/or the goal of using a critical process for the analyzing and evaluating of ideas.
Course Competencies
- Prepare an Excel Workbook
- Apply Formulas, Functions, and Formatting in a Worksheet
- Work with Large Worksheets, Create Charts, and Use What-If Analysis
- Use and Create Financial Functions and Data Tables
- Work with Multiple Worksheets and Workbooks
- Create, Sort, and Query a Table
- Create Templates, Import Data, Work with SmartArt, Images, and Screenshots
- Create and PivotTables, PivotCharts, Slicers, and Trendlines
- Edit PivotTables, PivotCharts, Slicers, and Trendlines
- Use Formula Auditing, Data Validation, and Complex Problem Solving Processes
- Perform Data Analysis with Power Tools
- Create and Execute Macros
- Use Visual Basic Applications (VBA), User Interfaces, and Collaboration Features in Excel
SCC Accessibility Statement
South Central College strives to make all learning experiences as accessible as possible. If you have a disability and need accommodations for access to this class, contact the Academic Support Center to request and discuss accommodations.
North Mankato: Room B-132, (507) 389-7222; Faribault: Room A-116, (507) 332-7222.
Additional information and forms can be found at: southcentral.edu/disability
This material can be made available in alternative formats by contacting the Academic Support Center at 507-389-7222.