You are here

Microsoft Excel - Level 3 (Two Days - MS Teams)

Learning Objectives:

Participants will learn to work across multiple worksheets and workbooks while sharing, collaborating and protecting their work. Participants will learn to use audit workbooks and forecast data.

Microsoft Excel Level 2 or equivalent experience is recommended.

Course Objectives:

  • Audit worksheets
  • Troubleshoot invalid data and formula errors
  • Watch and evaluate formulas
  • Apply conditional formatting
  • Add data validation criteria
  • Create a data list outline
  • Create pivot tables
  • Create scenarios
  • Perform a What-If analysis
  • Link workbooks
  • Consolidate data
  • Merge workbooks
  • Export Excel data
  • Import data
  • Create macros
  • Secure a workbook

Dates and Times: February 1-2, 2023

  Kitikmeot (MDT) Kivalliq (CDT) Qikiqtaaluk (EDT)
Start Time 8:30 a.m. 9:30 a.m. 10:30 a.m.
End Time 3:30 p.m. 4:30 p.m. 5:30 p.m.

Important Note:

All GN employees are welcome to register for this course, but it will be offered based on Central Daylight Time (CDT) from 9:30 a.m. – 430 p.m. Participants enrolled are expected to complete this course based on this time zone.

 

Start Date: 
Wednesday, February 1, 2023
End Date: 
Thursday, February 2, 2023
Location: 
Online, MS Teams
Community: 
Across Nunavut
Region: 
Kivalliq
Contact Name: 
Karen Tutanuak
Registration Deadline: 
Tuesday, January 31, 2023
Contact Email: 

Application Form

Completed application forms must be downloaded, printed and signed by the employee and the employee’s supervisor, then emailed or faxed. All registrations are accepted on a first-come, first-served basis.