Soft Skills and Office Applications

Course Description:

This one-day course is aimed for anyone wanting to maximize your team’s productivity and grow skills with our Advanced  Microsoft Teams Mastery —  a collaborative online work environment that enables you to maximize your team’s productivity.

Course Topics:

• Adding and customizing and removing tabs
• Adding a connector; changing connector settings
• Using the calendar tab and working with calendar views
• Scheduling, joining and participating in meetings
• Sharing information in meetings

Course Description:

In this one-day workshop you’ll learn how to best organize your priorities and work towards achieving your goals and objectives. As an office professional you are confronted and pulled by a multitude of demands throughout the day. There are unexpected interruptions from colleagues, telephone calls, emails and urgent requests from clients, meeting assignments, and new project tasks to juggle. Conquer the stress associated with handling multiple tasks and deadlines by adopting portable techniques for managing your time and schedule. You’ll achieve maximum productivity and put the “sanity” back into your day. 

Course Topics:

• Establishing your priorities: identifying and working towards goals and objectives, understanding the cycle of productivity
• Using smart goals to increase your productivity: setting up a to do list that works for you, build action plans to help achieve your goals and objectives
• Managing your workload: using the time matrix model to plan, schedule and implement your action items, planning the important tasks to work proactively
• Managing yourself: identifying time wasters, identifying/understanding the six styles of procrastination, pitching positive work habits
• The science of productivity: five simple steps that apply order to chaos
• Planning for success and staying on track: tracking is a powerful tool for increasing how much you move each day, importance of using the calendar

Course Description:

In this half-day workshop, you will learn how to create an Excel workbook, modify and format worksheets and use formulas.

Course Topics:

• Getting started: customizing the toolbar, creating, saving, opening and closing workbooks
• Modifying worksheets: inserting/deleting columns and rows, editing cell contents, copying/pasting cell contents, using autofill
• Using formulas and functions: creating and using formulas, creating and using basic functions, using absolute cell references
• Formatting and viewing worksheets: formatting worksheets, viewing worksheets
• Printing workbooks: using page setup, previewing and printing workbooks

Course Description:

This 56 hours (ten day) course is an elective course in the Municipal Management Program. The course focus is for participants to explore the nature of human dynamics within an organizational context from the perspective of the human resources practitioner is explored.

Course Topics:

• Self- reflection
• Stress management
• Human communications
• Learning and motivation
• Ethics
• Creativity
• Leadership
• Decision-making
• Power and conflict
• Team dynamics
• Organizational culture
• Change management

Build your skills in Microsoft Outlook with the option of courses from Level 1-2.

Course Description:

This 42 hours (eight-day) course is an elective course in the Municipal Management Program. The course focuses on effective and practical writing skills are important for successful communication in business. Students develop practical writing skills using basic word processing technology.

Course Topics:

Students will learn how to compose business correspondence including emails, memoranda, letters, and reports, with a focus on routine and persuasive messages. A review of basic grammar is also included.

Course Description:

In this half-day workshop, you will explore the Outlook environment including email messages, managing your messages, and managing tasks.

Course Topics:

• Understanding the Outlook environment: getting started and working in Outlook
• Communicating with e-mail messages: send, reply, forward and delete messages, use BCC, using categories
• Managing messages: use signatures, organizing, sorting and finding messages, search folders, use follow up flags
• Managing tasks: creating, editing and deleting/complete tasks, organizing and tracking tasks

Course Description:

This one-day course is aimed for anyone wanting to maximize your team’s productivity and grow skills with Beginner Microsoft Teams Mastery. Microsoft Teams is a collaborative online work environment that enables you to maximize your team’s productivity.

Course Topics:

• Understand the benefits of using the platform to work collaboratively with your teams from anywhere and across a variety of devices
• Know how to organize and participate in Teams virtual meetings, as well as track and manage your team’s work
• Be able to use the platform’s chat-based communication tool to share information and files in real time

Course Description:

This one and a half day course is aimed for anyone wanting to learn efficient methods of working in each of Microsoft’s core applications. Participants will learn Microsoft Word and Microsoft Excel tips and tricks and time management in Microsoft Outlook.

Course Topics:

• Microsoft Word – toolbar customization; application defaults; navigation; shortcut keys; formatting; editing; bullets; numbering; themes; global defaults; quick parts; table of contents; sections and tabs
• Microsoft Excel – editing; formatting; autofill; basic/intermediate calculations; sparklines; range names
• Time Management Microsoft Outlook – managing your outbox and inbox; file structure; processing your email; daily/weekly review; categories; follow-up flags; search folders; quick steps; custom rules; conversation view; ignore/clean up conversations; conditional formatting; outlook today 

Course Description:

In this one-day course participants will coverer these topics:

• Stress: With this course you will learn skills to identify your stressors, and your typical response to stressful situations. As well you will be able to practice different healthy responses that make you more resilient and able to be your best in stressful situations.
• Conflict: When conflict does occur this course will help build skills to defuse the situation, respond professional to conflict and seek solutions that work for everyone.
• Managing Priorities: You can do anything; you can’t do everything. Having too many priorities is as challenging as having no priorities – everything is equally important. Knowing what must be done first and what follows frees you from trying to do everything. There are even some things that don’t need to be done at all, or at least not by you.

Course Description:

This two-day course is aimed for anyone wanting to explore the use of Microsoft Project software.

Topics Covered:

• Plan, organize and deliver projects using Microsoft Project®. 
• Learn how to create a project
• Project resources and costs
• Printing schedule information
• Changing scheduling methods
• Resolving resource conflicts
• Tracking project
• Progress; sorting, filtering and grouping
• Formatting the project environment

Course Description:

This one-day course is aimed for anyone wanting to develop and/or better their professional negotiation skills. Participants will become more successful and confident at negotiation, be it at an interpersonal level or in a professional context.

Course Topics:

Whether requesting the raise you deserve, flexible work hours, expediting delivery, closing multi-million dollar contracts, or just deciding which toppings you want on a pizza, this course will increase your skills. You’ll have a roadmap to follow and be able to recognize and effectively employ a range of negotiation strategies.

Course Description:

This half-day course is aimed for anyone that wants to learn how professional writers approach business writing or individuals seeking to improve or refresh their business writing skills.

Course Topics:

This course focuses on knowing how to craft an effective business email. Effective emails help reduce misunderstandings and ensure that your message has its desired effect. Don’t miss this three hour online training opportunity to get the most out of your writing by improving your editing skills and knowing when to minimize your sentences for greater effect.

LinkedIn Learning Access for Nunavut Municipal Employees

The MTO and NWT School of Government has partnered to offer new training opportunities to Municipal Staff. This new program offers all participants access to online videos and training until December 31, 2021. This opportunity is FREE!

It includes:

• Unlimited access to 16,000+ expert-led courses
• Learn from industry experts who are passionate about teaching
• Earn a certificate when you complete a course
• Receive course recommendations tailored to you
• Use project files and quizzes to practice while you learn
• View courses anytime on your computer or phone

Course Description:

In this one-day workshop you will learn how to create and use the Excel table feature, as well as add, edit, search for and delete records in a data list using data forms.  

Course Topics:

• Maintaining data: data list and Excel table concepts, using data forms, using lookup tables
• Sorting lists: sorting concepts, custom sort orders
• Filtering lists: filtering concepts, using AutoFilter, using advanced filter, working with filtered data
• Summarizing data: automatic subtotals, working with sub-totaled lists, using functions to summarize data
• PivotTables: PivotTable concepts, creating PivotTables, modifying PivotTable layouts, working with PivotTables, slicers
• External data: external data concepts, importing query data from access, importing query data from web pages, importing query data from text files

Build your skills in Microsoft Teams with the option of beginner or advanced courses.

Course Description:

This one-day course is aimed for anyone wanting to develop their writing by improving editing skills and use minimal words to communicate messages effectively. Participants will learn to write from your reader’s perspective, tell your story, and deliver your message so that it is memorable and has impact.

Course Topics:

• Produce clearly written text
• Learn how professional writers approach business writing
• Improve/refresh your writing
• Write proposals, reports, articles, speeches, news releases or any kind of business communication as part of your professional duties.

Course Description:

In this half-day workshop, you will learn how to organize Outlook folders, control messages and use notifications, schedule meetings and use the productivity improvement features. 

Course Topics:

• Managing folders
• Rules wizard
• Filtering a view
• Using advanced message features
• Controlling messages
• Message notifications
• Scheduling meetings
• Planning, requesting and scheduling meetings
• Rescheduling and cancelling meetings
• Personal productivity
• Calendar
• Contacts (create contact groups)
• Tasks
• Mail

Course Description:

During this one-day workshop, participants will learn to use various tools in order to organize worksheets, use advanced formulas and working with charts.

Course Topics:

• Worksheet organization: range names, workbook templates, worksheet security, outlining
• Advanced formulas: using the IF Function, linking formulas
• Using multiple workbooks and worksheets: working with multiple workbook, setting up and using multiple worksheets, creating links with formulas, modifying and restoring links, consolidating data
• Working with charts: creating charts, changing chart data, modifying chart elements. creating custom charts, applying formatting
• Annotating worksheets: creating styles, working with styles, using conditional formatting, using sparklines

Course Description:

This one-day course is aimed for anyone wanting to builds skills about feeling confident and comfortable speaking up when dealing with conflict.

Course Topics:

• Assertiveness: the foundation of all of the other skills. It is about saying what you mean, meaning what you say and not saying it mean. It is about consideration and respect – both for you and for the person that you are interacting with. It is also about saying ‘no’ and doing it without guilt or anxiety.
• Conflict: being assertive actually lowers the probability of there being conflict. When conflict does occur, you will have the confidence to defuse the situation, respond professional to conflict and seek solutions that work for everyone.

Course Description:

While conflict is most often perceived as undesirable, it can provide opportunities for mutual growth and bridging communication gaps. By the end of this course, you will focus on a plan for coping with conflict in the future rather than assigning blame to the past. It will also increase your ease in dealing with the inevitable situations that arise in the workplace and your personal life.

Course Topics:

• The nature and cause of conflict
• 5 conflict management style
• D.E.S.C. Model for resolving conflict
• When to withdraw, stand your ground or compromise
• Escalation of conflict
• Defusing conflict
• Effective communication skills for positive results

Course Description:

In this half-day workshop, you will learn about basics including text, layouts and writing tools.

Course Topics:

• Using Word basics: editing documents, printing and viewing documents
• Managing text: aligning text, moving, copying and replacing text

• Modifying and enhancing text appearance: character formatting using fonts and colours, using tabs, changing tab settings, setting indents, applying bullets and numbers, changing paragraph and line spacing
• Controlling page layout: changing margins, inserting page breaks, using headers and footers
• Using writing tools: checking spelling in a document, using autocorrect 

Course Description:

This half-day course will help you understand tables, use styles and formatting, reuse data, and create templates.

Course Topics:

• Creating and managing tables: creating tables, modifying and formatting tables
• Managing styles: styles overview, applying styles, creating styles, modifying styles, copying styles
• Reusing data and content: quick parts overview,  working with building blocks
• Working with templates and forms: using templates, create a form template

Course Description:

In this one-day workshop, you will learn how to create presentations based on templates or themes, use outlines, customizing themes and styles, preview and print presentations, use different slide layouts and text formatting tools, organize and edit information, enhance presentations by using WordArt, SmartArt and clip art, apply transitions and produce on-screen slide shows.

Course Topics:

• Understanding presentation concepts
• Creating a new presentation: organizing text in outlines
• Working with themes and masters: understanding themes and quick styles, modifying the theme slide master, previewing and printing a presentation
• Designing a presentation: applying slide layouts, formatting text
• Making modifications: formatting bullets, editing a presentation, applying transitions
• Enhancing presentations with objects: Adding and modifying WordArt, adding and formatting SmartArt, adding and managing objects, adding graphics
• Producing a presentation: building a slide show, running a slide show