CCTO 240 - Microsoft Excel Level II

Course Description

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. 

Take the pre-assessment available here which helps recommend the appropriate Microsoft Excel course for your skill level: 
https://northern-alberta-institute-of-technology.involve.me/ccto140-ms-excel-level-1

To be eligible to take CCTO240 Microsoft Excel Level II, students must either:
1. Take and pass CCTO140 Microsoft Excel Level I 
2. Earn 80% or higher on the CCTO141 Excel Level I Challenge Exam 

Course Information

Applies Towards the Following Certificates

• Excel and Power BI for Business : Required Courses
• Excel Expert : Required Courses
• Medical Office Administrator : Computer Training Courses
• Office Technology : Required Courses