B.C.'s Energy College

WFTR550 - Microsoft Excel Level 2 - Building Productivity
Course Code:
WFTR 550

Calendar Description:
Microsoft® Office Excel – Level 2 teaches students how to apply basic skill sets along with intermediate to advanced functions to manage and audit numerical reports. Students will work with various functions to perform specific types of calculations, customize charts, work with pictures or shapes in a worksheet, customize formatting for specific types of data, and look at various features for managing different types of lists using a table or database format.

Date First Offered:
2009-07-01

Hours:
Total Hours: 18
Seminars and Tutorials: 18

Total Weeks:
3

This course is offered online:
No

Pre-Requisites:
WFTR 530 MicroSoft Excel Level 1 or permission of CE/WFTR Coordinator

Non-Course Pre-Requisites:
NONE

Co-Requisites:
NONE

Rearticulation Submission:
No

Course Content:
Unit 1: Using Functions
- What are Functions?
- Using Math and Trigonometric Functions
- Using Statistical Functions
- Working with Financial Functions
- Using Logical Functions
- Using Date and Time Functions
- Using Text Functions
- Using Information Functions
Unit 2: Working with Illustrations
- Drawing Shapes
- Using SmartArt Graphics
- Modifying Drawing Objects
Unit 3: Customized Charts
- Customizing Charts
- Using Trendlines
- Auditing a Worksheet
Unit 4: Customized Formatting
- Aligning the Cell Contents
- Using the Format Painter
- Hiding/Unhiding Data
- Using Cell Styles
- Looking at Custom Cell Formats
- Applying Conditional Formatting
Unit 5: Working with Tables
- Using Tables
- Working with Named Ranges
Unit 6: Working with Databases
- Working with Databases
- Filtering Information
- Using Database Functions
- Sorting Data

Learning Outcomes:
Upon successful completion of this course, the student will be able to:
- Define what a function is
- Use the correct syntax to insert functions
- Use math and trigonometric, statistical, financial, logical, date and time, text, or information functions
- Draw different types of objects
- Insert and modify graphics such as picture or SmartArt
- Customize chart elements
- Create and customize trend-line charts
- Audit a worksheet by finding and identifying errors
- Align data in a cell using a variety of methods
- Use the Format Painter to duplicate formatting
- Hide or unhide rows, columns, or workbooks
- Customize formats for numbers, dates, scientific or text data types
- Apply conditional formatting using a variety of rules
- Create and manipulate a table
- Apply cell styles and Quick Styles
- Use formulas in tables
- Convert a list to a table list
- Name, modify or delete a named range
- Use and define basic database concepts and terminology
- Create a database
- Use different filter features to find specific data
- Use some of the functions for databases such as creating totals or averages

Percentage

70%

Quizzes and Tests: 50 %
Assignments: 30 %
Lab Work: 15 %
Participation: 5 %

Number of Assignments:
6

Nature of Participation:
Attendance

Percentage of Individual Work:
100

Course Offered in Other Programs:
No