Course Description

Microsoft Excel Level 2 teaches students how to apply basic skill sets along with some intermediate to advanced functions to manage and audit numerical reports.

Students will learn to create and manipulate charts, work with different types of graphics, look at various methods of analyzing, organizing, linking and sharing workbooks, learn to use advanced formatting features.

Course Details


Registrations within 24 hours of course start time must be made by phone (403-220-2866)

Course Content

Course Level Learning Outcomes

Upon successful completion of this course, you will be able to:

  • Use name ranges
  • Use intermediate formulas in a worksheet
  • Use conditional formatting
  • Work with and arrange worksheet panes and windows
  • Create and work with charts
  • Add and work with graphic images (shapes and pictures)
  • Practice methods of organizing data
  • Work with tables
  • Analyze data
  • Search worksheets for values
  • Make workbooks more accessible
  • Use hyperlinks in a worksheet
  • Import and export data between other applications

Topics of Instruction

  • Working with Data
  • Using Advanced Formulas
  • Creating Charts and Sparklines
  • Adding Pictures and Shapes to a Worksheet
  • Using Quick Analysis
  • Applying conditional formatting
  • Inserting subtotals
  • Creating outlines
  • Collapsing groups of data in outlines


  • Students must be familiar with the personal computer, keyboard and mouse.
  • Students must have Microsoft Windows skills and knowledge, and be able to perform the following tasks:
    • start and run Windows
    • use the taskbar, Start button and Help feature
    • use Minimize, Maximize, Restore Down/Up and Close
    • use the left and right mouse buttons appropriately
    • understand file management techniques
    • navigate between files, folders, or drives

Applies Towards the Following Certificate(s)


Enrol Now - Select a section to enrol in

May 04, 2020 to May 18, 2020
Delivery Options
Course Fees
Flat Fee non-credit $575.00
Reading List / Textbook

Title: Microsoft Excel 2016 Core Certification Guide
Edition: 2016
Publisher: CCI Learning
ISBN: 978-1-55332-473-7

For e-book: Visit CCI Learning 

Section Notes

You will require access to a computer with the required software: Microsoft Office 2016.

Please Note: Starting September 2020, the required software for all Office Application courses will be updated to Microsoft Office 2019.

This course uses Desire2Learn (D2L), an online learning management system. The instructor will post your course outline and other materials in D2L. For more information about D2L, please visit our Online Learning Resources.

Unless notified, all online courses are available at 9 am MT the day before the start date. Students who register on (or after) the start date will receive access within one day of registration.

Unless otherwise stated, notice of withdrawal or transfer from a course must be received at least seven calendar days prior to the start date of the course.

Required fields are indicated by .