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: