The Working Centre - Access to Technology

Home
Monthly Calendar
Fundraising

Site Map
Volunteering
About Us


Computer Training Resources

Below you will find some useful online resources that offer free computer training tutorials.

Here are links to some Computer Basics tutorials online.

Here are the links to the Office online training offered by Microsoft.

Office 2003

Office 2007

Windows Tutorials

Information about Microsoft Office Certification

Back to top

Open Office

Open Source

Back to top

Web Design

Programming Languages

Databases

Back to top

Here are links to some typing tutorials online.

Back to top

Word 2003

  1. Create your first document
  2. Some Features in Word
  3. Customize Keyboard Shortcuts
  4. How to protect Word documents
  5. Review Documents with Track Changes and comments
  6. Decorate documents with backgrounds, borders, and text effects
  7. Add graphics and keep them where you want them
  8. Introduction to Tables: Create and format basic tables
  9. Tables II: Use tables to simplify complex page layouts
  10. Tables III: Manage financial tables and tables from Excel and the Web
  11. Adding Headers and Footers
  12. Create Footnotes and Endnotes
  13. Inserting a Table of Contents
  14. Table of Contents II: Advanced TOCs, long documents, and other tables
  15. Create a document outline
  16. Format your document with styles
  17. Create individual envelopes and labels
  18. Prepare for the holidays: Write and send a newsletter with Word
  19. Introduction to XML in Word

Excel 2003

  1. Create your first workbook
  2. Enter Formulas
  3. Enter Formulas: Audio Course
  4. Help secure and protect data in Excel
  5. Great Excel features
  6. Great Excel features: Audio Course
  7. Printing options in Excel
  8. How to use lists in Excel 2003
  9. Publish Excel 2003 lists to a SharePointsite
  10. All About AutoFilter
  11. Plan payments and savings by using financial formulas
  12. Use formulas to edit, correct and proofreadtext
  13. Excel statistical functions
  14. Make time count by using formulas
  15. Figure out dates by using formulas
  16. Find functions and enter arguments
  17. Charts I: how to create a chart
  18. Chart II: Choose the right chart type
  19. Chart III: Create a professional looking chart
  20. Chart IV: Charts for the scientist
  21. PivotTable I: What’s so great about PivotTable Reports?
  22. PivotTable II: Swing into action with PivotTable Reports
  23. PivotTable III: Show off your PivotTable skills
  24. Import external data into Excel
  25. Filter external data before importing it into Excel
  26. Import text files into Excel
  27. Using XML in Excel 2003
  28. Working with really big worksheets
  29. Working with really big worksheets: AudioCourse
  30. Get in the loop with Excel Macros
Back to top

PowerPoint 2003

  1. Create your first presentation
  2. Great PowerPoint features
  3. Flowcharting with flair
  4. Organizational Charts: A to Z
  5. Use Visio drawings in presentations, documents and publications
  6. Animations I: Preset and custom animation
  7. Animations II: Motion paths
  8. Animations III: Timing
  9. Playing sound
  10. Playing movies
  11. Design efficiently with masters
  12. Create your own template
  13. The small print: headers and footers
  14. Navigation know-how
  15. Printing I: Know your options
  16. Printing II: Work with color commands

Access 2003

  1. Get to know Access
  2. Access security I: Introduction to security
  3. Table that data
  4. Forms I: Create a form to enter and view your data
  5. Forms II: Use Subforms
  6. Reports I: Show off your data
  7. Queries I: Get answers with queries
  8. Queries II: Limit your data and calculate values
  9. Queries III: Create parameter queries that prompt users for input
  10. Queries IV: Working with complex criteria
  11. Combo boxes, list boxes and other controls
  12. Create labels from your database
  13. Work with a database you didn’t create
Back to top

Outlook 2003

  1. Great Outlook features to organize your Inbox
  2. Search Folders: The easy way to find, read and organize your e-mail
  3. Send and receive photos and attachments with confidence
  4. Tips to get an address on the TO line fast
  5. Control how you send and see mail messages
  6. Become an address book expert
  7. How Outlook helps protect you from junk e-mail
  8. Create great-looking signatures for your e-mail
  9. Manage the size of your mailbox
  10. File or archive your e-mail on your own computer
  11. Find, copy or back-up e-mail on your computer
  12. Get to know your Outlook Calendar
  13. Great Outlook Calendar features to make time work for you
  14. See and share multiple calendars
  15. Organize meetings with Outlook
  16. Keep track of birthdays and anniversaries
  17. Delegate access: let someone else mind your busyness
  18. Great Outlook features to organize your contacts
  19. Share contacts using Outlook and Windows SharePoint services
  20. Share a calendar using Outlook and Windows SharePoint services

Publisher 2003

  1. Get started designing your own professional publications
  2. Create catalogs or directories
  3. Prepare a publication for commercial printing
  4. Create an accessible Office document
  5. Use Visio drawings in presentations, documents and publications
  6. Customize your toolbars and menus
  7. See what you can do with the Research service
  8. Organize your clip art and other media

Project 2003

  1. Present your project in Word, PowerPoint or Visio
  2. Dig deeper into scheduling
  3. Linking project tasks

Back to top


Word 2007

  1. Create your first document
  2. Make changes to your Microsoft Office Word 2007 documents
  3. Make document look great
  4. Up to speed with Word 2007
  5. Save time with templates
  6. Bullets, numbers and lists
  7. Decorate documents with backgrounds, borders and text effects
  8. Reuse text and other document parts: Introducing building blocks
  9. Revise documents with tract changes and comments in word 2007
  10. Header and footers basics
  11. Headers and footers for document sections
  12. Inserting a Table of Contents
  13. Table of contents II: Customize your TOC
  14. Table of content III: Use fields to create a TOC and multiple TOCs
  15. Mail merge I: Use mail merge for mass mailings
  16. Mail merge II: Use the Ribbon and perform a complex mail merge
  17. Keyboard shortcuts in 2007 Office system
  18. Security I: How the 2007 Office system helps you to stay safer

Excel 2007

  1. Get to know excel 2007
  2. Create your first workbook
  3. Enter formulas
  4. Learn how to figure out date using formulas
  5. Chart I: how to create charts in excel
  6. Pivot table I: Get started with pivot table reports in excel 2007
  7. Pivot table II: Filter pivot table report data in excel 2007
  8. Pivot table III: Calculate data in pivot table reports in excell2007
  9. Share excel data with others by exporting it to SharePoint site
  10. Excel services I: The basics
  11. Excel services III: Control what people see
  12. Excel services IV: Allow user input
Back to top

PowerPoint 2007

  1. Up to speed with PowerPoint
  2. Create your first presentation
  3. Create a basic presentation quickly
  4. Put your photos into PowerPoint
  5. Put your photos into PowerPoint: Video version
  6. Select a picture (Brain Storm Inc.)
  7. Adjust a picture (Brain Storm Inc.)
  8. Add photos to an album (Brain Storm Inc.)
  9. Get visual with the SmartArt graphics
  10. Insert charts (Brain Storm Inc.)
  11. Select chart options (Brain Storm Inc.)
  12. Use table options (Brain Storm Inc.)
  13. Choose table styles (Brain Storm Inc.)
  14. Add sound effect to a presentation
  15. Record narration (Brain Storm Inc.)
  16. Adjust recording quality (Brain Storm Inc.)
  17. Insert movies (Brain Storm Inc.)
  18. Use movie options (Brain Storm Inc.)
  19. Add animation to text and objects
  20. Keep sane with the selection pane
  21. See how “themes” replace design templates
  22. Personalize your slide design
  23. Discover the power of custom layouts
  24. SharePoint slide libraries I: Set up a library for your team
  25. SharePoint slide libraries II Use slides in the library
  26. Lesson: Proof, print, and prep for the show
  27. Add slide numbers and other footers to slides
  28. Add headers and footers to presentation handouts
  29. Choose slide-show options (Brain Storm Inc.)
  30. Distribute a PowerPoint presentation on CD
  31. Download PowerPoint versions of online courses
  32. More Office videos about PowerPoint 2007
  33. More Brain Storm, Inc, videos about PowerPoint 2007

Access 2007

  1. Choose between Access and Excel
  2. Get to know 2007 access
  3. Up to speed with Access 2007
  4. Demo: Up to speed with Access 2007
  5. Take charge of your database with your navigation pane
  6. Demo: Meet the navigation pane
  7. Design tables for a new Access in 2007 database
  8. Create tables for a new Access 2007 database
  9. Build relationships for a new Access 2007 database
  10. Create queries for a new Access 2007 database
  11. Create forms for a new Access 2007 database
  12. Create reports for a new Access 2007 database
  13. Easy Access with templates I: Create a database
  14. Easy Access with templates II: Modify a database
  15. Datasheets I: Create a table by entering data
  16. Datasheets II: Sum, sort, filter and find your data
  17. Datasheets III: Make data easier to read by formatting columns and rows
  18. Import data from Excel to new table in Access
  19. Queries I: Get started with queries
  20. Queries II: Create basic select queries
  21. Queries III: Use expressions and other criteria
  22. Queries IV: Use functions and calculated fields in your queries
  23. Queries V: Use “And”, “Or”, and “In” to set multiple conditions
  24. Queries VI: Use wildcards in queries and parameters
  25. Queries VII: Query multiple sources for data
  26. Queries VIII: Dealing with ambiguous joins
  27. Demo: Set the relationship between two tables
  28. Demo: Use the Expression Builder
  29. Demo: Collect data in Access 2007 by using e-mail
  30. Watch this: Make a query ask for input
Back to top

Outlook 2007

  1. Up to speed with Outlook 2007
  2. Interactive guide: Outlook 2003 to Outlook 2007 command reference guide
  3. Get out of your inbox with Outlook 2007
  4. Create great-looking signature for your e-mail
  5. Outlook and RSS: Internet information delivered to your mailbox
  6. Sent text messages from Outlook 2007 to a mobile phone
  7. Manage your mailbox I: Find its size and trim it down
  8. Manage your mailbox II: understand your choices for storing
  9. Manage your mailbox III: Move or copy messages to personal folders
  10. Manage your mailbox IV: Archive old messages
  11. Manage your mailbox V: Retrieve, back up or share messages
  12. Calendar I: Outlook calendar basics
  13. Calendar II: See and use multiple calendars
  14. Birthdays I: Keep tract of birthdays and anniversaries
  15. Birthdays II: Linking contacts and birthdays
  16. Create and use your own Electronic Business Card
  17. Reduce spam! Get your Junk E-mail filter in top condition

Publisher 2007

  1. Get started designing your own professional publications
  2. Commercial printing I: Understand your printing options
  3. Commercial printing II: Publisher and color printing
  4. Commercial printing III: Publisher and printed graphics
  5. Commercial printing IV: Using the Design Checker in Publisher 2007
  6. Check spelling and grammar in another language

Project 2007

  1. Present your project in Word, PowerPoint or Visio
  2. Linking Project Tasks
  3. Check Spelling and Grammar in Another Language

General Office 2007

  1. Up to speed with the 2007 Office system
  2. Keyboard shortcut in the 2007 Office system
  3. Security I: How the 2007 Office system helps you to stay safer
  4. Security II: Turn off the Message Bar and run code safely
  5. Security III: Sign your own macros for stronger security
  6. Office Open XML I: Exploring the Office Open XML Formats
Back to top