Public Service Commission
Department Overview
Branches
Computer Courses
General Workshops
New to Computers?
For those who would like to learn the basic elements of computing.
This workshop will cover the following topics:
- Using a Mouse
- Introduction to the Windows World
- Create, Save, Spell Check and Send an E-mail Message
- Create, Save, Spell Check and Print a Memo
File Your Computer Documents and Email Messages
Learn where files belong, how to get them there and how to find them later.
- learn the different places to store files, (G: or H:, and why not C:)
- create folders relevant to your projects
- file your documents
- find and retrieve your documents
- disk space issues
MS Outlook
MS Outlook Fundamentals
Learn to use your e-mail software
In this course you will learn the following basic skills:
- send/receive email
- create folders and file e-mail
- reply to and forward e-mail
- send e-mail with attachments
- save, edit, return edited attachments
- create a distribution list
- create appointments in the calendar
- create a "to-do" list in Tasks
MS Outlook Tools
Learn to use specific features of your e-mail software
For those who use Outlook now but need to learn more, taking this course you will:
- use the calendar to sit up group meetings and recurring appointments
- create contacts to save addresses, phone numbers and other information about people and companies you contact frequently
- view and print contacts as a phone list or a detailed address list
- send e-mails and set up meetings with contacts
- create a reminder for a contact
- use V-cards to e-mail contacts to others
- create tasks as reminders, and track tasks assigned to others
MS Outlook Contacts
Merge your Outlook e-mail contacts to form letters
This feature is covered in the Word - Mail Merge workshop.
MS Word
MS Word Fundamentals
Get started using this word processing program
In this introductory course you will cover the following topics:
- creating and editing documents
- formatting paragraphes, pages and sections
- cut, copy, paste text
- create headers and footers
- work with envelopes and labels
- check grammar and spelling
MS Word - Document Enhancements
- apply borders and shading to pages and paragraphs
- create watermarks to put things like the word "DRAFT" or an image behind your text
- use the drawing toolbar to draw arrows, circles, and 3d boxes
- insert clipart and pictures into your documents
MS Word - Tables
- Organize your information into table format for sorting either alphabetically or numerically.
- Perform simple calculations.
- transfer existing text into a table format and use autoformat to give your table a polished look.
MS Word - Mail Merge
- send the same letter, memo, or e-mail to many different people
- create a mailing list
- use an existing list
- use MS Outlook contacts
MS Word - Automation Tools
- templates
- styles
- auto-correct/auto-text
- table of contents
- page numbering and section breaks
- tools and options choices
MS Excel
MS Excel Fundamentals
Use this program to help you track your financial data
This course will give you a good overview of the capabilities of Excel:
- create, save and edit a worksheet
- edit and select data
- create formulas
- navigate in a worksheet
- format a worksheet
- headers and footers
MS Excel Tools
Learn some of the more advanced capabilities of Excel to increase your spreadsheet skills
Tackle techniques for:
- using multiple worksheets and workbooks
- linking data between worksheets and workbooks
- showing data using charts
- using functions
- creating templates
- using dates
MS Excel - Database Functions
Learn to manipulate your data into a report format
Topics covered include:
- sorting
- extracting specific data
- creating and working with pivot tables
MS Access
MS Access Fundamentals
Learn to use this database program to manage your data effectively
This basic course will cover the following topics:
- defining database concepts
- basics of creating an access database
- building and modifying tables
- working with table data
- working with forms
- creating and modifying queries
- working with reports
MS Access Tools
Create a database from start to finish using the skills you learned in the Fundamentals workshop.
MS Access Links
MS Powerpoint
MS Powerpoint Fundamentals
Create dynamic presentations using Powerpoint
The following topics will assist in making effective presentations:
- create and save presentations
- add or edit text and slides
- create notes pages and handouts
- add visual interest with drawing objects
- add graphics and transitions to slides
- run your slide show
MS Powerpoint - Create Your Own Presentation
Get assistance and ideas from others while you create your own presentation
Bring your thoughs to the classroom to get assistance with Powerpoint. Log on as yourself to access any text and pictures you might already have. The class will be kept small to ensure everyone can share their ideas and get help with their presentation.
MS Project
MS Project - Versions 98, 2000, or 2002
Project software lets you track a variety of projects from very simple schedules to complex budgeting and reporting systems
Due to low enrolment for this course, we suggest you apply to take the course on-line at the Northern Knowledge Website. Browse the course catalogue to see a description of the MS Project courses.
MS Project - Resources
Check for course offerings
- Staff Development Quarterly
Courses are offered to Yukon government employees.
