Welcome to the new NAIT.ca! We encourage you to explore the site and provide your feedback.

Continuing Education

CCTO240 - Microsoft Excel Level II

Course Code

A unique identifier used at NAIT for this specific course.

Campus

The location where your NAIT courses will be held.

Course Overview

Expand your knowledge of Excel’s many capabilities as you learn to use multiple worksheets and multiple workbooks efficiently. Use absolute referencing and named ranges in your formulas. Apply IF statements so Excel will enter one of two answers. Have Excel interpret a lookup function to pull information from a table. Manipulate the contents of a database by sorting, filtering, and calculating. Create a basic PivotTable to analyze a database. Generate business charts and format them.

Recommended: CCTO140 Microsoft Excel Level I.

Upcoming Offerings