UofC Navigation

ICT 416 Microsoft Excel Level 2

 Email this information to yourself or a friend
 Remind me of this course at a later date



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

Coming Soon


Prerequisites

  • ICT 415 Microsoft Excel Level 1
  • Students must also meet the recommendations and requirements in the Notes section along with any proficiencies identified below.

Instructional Delivery

  • Face-to-face in a lab

Registration

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

Top of Page


Course Content

Course Level Learning Outcomes

  • Coming Soon

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

Top of Page


Notes

Required Tools

  • Online and in class students need acess to Microsoft Excel 2016 outside of lab/class time to work on assignments, projects, or other course work. This software may be downloaded from Microsoft.

Textbooks

Attendance

It is strongly recommended that students attend every class. It is the responsibility of the student to communicate potential absenteeism to the instructor.

Top of Page


 

Prerequisites

  • ICT 415 Microsoft Excel Level 1
  • Students must also meet the recommendations and requirements in the Notes section along with any proficiencies identified below.

Top of Page


Proficiencies

  • 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

Top of Page


 


Applies Towards the Following Certificate(s)




Sections

  ICT 416 - 052 Microsoft Excel Level 2  
  Fall 2016   Status:  Available
 
Class:   Wed 8:30AM - 4:30PM
19 Oct 2016 to 26 Oct 2016
Number of Sessions: 2 Sessions
Hours: 14.00
Course Fees:   Flat Fee non-credit    $575.00
 
Campus: Main Campus
Delivery Options:  Class
Instructor(s): Somasundari Sankaragomathi
  Section Notes:  

COURSE SCHEDULE AND DELIVERY

This course has 2 classes scheduled once per week for 2 weeks. This course is delivered in an in class format. Classes are held in a classroom lab.

PREREQUISITES

ICT 415 Microsoft Excel Level 1

TRANSFER AND WITHDRAWAL FEES

A $25 fee applies for course withdrawals and transfers. For our standard Refund, Withdrawal and Transfer Policy visit conted.ucalgary.ca/refund

  
 
  ICT 416 - 053 Microsoft Excel Level 2  
  Spring 2017   Status:  Available
 
Class:   Thu 8:30AM - 4:30PM
04 May 2017 to 11 May 2017
Number of Sessions: 2 Sessions
Hours: 14.00
Course Fees:   Flat Fee non-credit    $575.00
 
Campus: Main Campus
Delivery Options:  Class
Instructor(s): Somasundari Sankaragomathi
  Section Notes:  

COURSE SCHEDULE AND DELIVERY

This course has 2 classes scheduled once per week for 2 weeks. This course is delivered in an in class format. Classes are held in a classroom lab.

PREREQUISITES

ICT 415 Microsoft Excel Level 1

TRANSFER AND WITHDRAWAL FEES

A $25 fee applies for course withdrawals and transfers. For our standard Refund, Withdrawal and Transfer Policy visit conted.ucalgary.ca/refund

  
 


Search ContEd