B.C.'s Energy College

Apply Now
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:

Total Hours: 18
Seminars and Tutorials: 18

Total Weeks:

This course is offered online:

WFTR 530 MicroSoft Excel Level 1 or permission of CE/WFTR Coordinator

Non-Course Pre-Requisites:


Rearticulation Submission:

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
- Using Advanced 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

Grading System:

Passing Grade:

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

Number of Assignments:

Nature of Participation:

Percentage of Individual Work:

Course Offered in Other Programs:

Additional Comments:
Completion of this course partially prepares students to write the Microsoft Certified Application Specialist exam. By completing the other levels available for this application students will have reviewed all of the exam objectives.

Text Books:
Required - Microsoft, 2008, Microsoft Office Excel 2007 Level 2 - Building Productivity (CCI Learning Solutions Inc.). Chapters Covered: All
Home   |   About NLC   |   Admissions   |   Programs   |   Services   |   Student Life   |   News & Events   |   Contact Us