Office Technology COURSES

Learn how office technology can help you improve your professional and personal productivity. Our courses familiarize you with many of the most common office applications and teach you tips for getting the most out of your workplace or home computer.

SUBSCRIBE NOW! Receive course information and updates by email.

Course Topics

•   •   •

WINDOWS 7 AND OFFICE 2007 - QUICK START NEW

If you have just bought a new PC, this course introduces Microsoft’s new operating system to you. Find your favourite old Windows features as well as new ones! Discover new Windows features such as the new user interface, instant search and sync centre, and new Office 2007 features, including the Ribbon and new menu, charting engine and Microsoft Live. Prior experience with Windows XP or Vista and Microsoft Office is recommended. For details, view tech.ubc.ca/hope.

Required: Internet access for an optional assignment.
2 Thu, Apr 29-May 6, 6:30-9:30pm; UBC Robson Square. $250+tax
Register Now

Outlook: Getting Out of the Inbox NEW

Outlook is far more than a simple email program. It is a productivity tool that allows you to manage your communications, tasks, processes, commitments, priorities and keep a journal of all of your activities. Learn to use these features of Outlook to be more productive and find out how satisfying it can be to empty your inbox every day. For details, view tech.ubc.ca/hope.
Note: Not all features discussed are available in Outlook 2003, but the principles will be applicable. If possible, bring your portable computer running Outlook to the session.

Prerequisites: Prior experience with Microsoft Office Outlook 2003 or 2007.
Thu, Mar 25, 9am-4pm; UBC Robson Square. $250+tax
Register Now

[Top]

Word 2007 Quick Start NEW

If you are an experienced user of earlier versions of Microsoft Word, then making the initial transition to Word 2007 is easy, until you try to do familiar things like formatting and extensive editing. In this course we uncover the mysteries of the new fluent user interface (the Ribbon) to help you to do what you have always done like create and edit text, format with styles and outlines, check grammar and spelling. We also explore new ways to be productive with shapes, smart art, quick parts, references and more. For details, view tech.ubc.ca/hope.

Prerequisite: Prior experience with Word 2003 or earlier would be an asset. Access to the Internet to review post-course resources is highly recommended.
Thu, May 27, 9am-4pm; UBC Robson Square. $250+tax
Register Now

[Top]

Introduction to Excel (formerly Excel – Level 1)

In this hands-on introductory workshop examine spreadsheet principles, charting, data management and printing. Applications for Excel are explored using examples and case studies. For details, view tech.ubc.ca/hope.

Prerequisites: Knowledge of Windows and Internet access.
2 Mon, Mar 22-29, 9am-4pm; UBC Robson Square. $345+tax
Register Now

[Top]

Troubleshooting and Designing Excel Worksheets (formerly Excel – Level 2)

This course covers planning and designing worksheets, troubleshooting large, complex worksheets, protecting files, working with, named ranges, built-in and user-defined functions, macros, and integrating Excel with other Microsoft Office products. For details, view tech.ubc.ca/hope.
Note: The material in this course is most relevant to those who have been working with Excel for six months or more.

Prerequisite: Excel - Introduction to Excel (IG016) or equivalent.
2 Mon, Apr 12-19, 9am-4pm; UBC Robson Square. $345+tax
Register Now

[Top]

Introduction to Access (formerly Access – Level 1)

Microsoft Access allows you to capture, manipulate and analyze data easily. Learn the fundamental concepts, terminology, objects and tools that make up a database. Design and create tables, queries, forms and reports, and get an introduction to the standard language of databases: SQL. For details, view tech.ubc.ca/hope.

Prerequisites: Working knowledge of Windows (XP or Vista) and access to the Internet.
2 Mon, Apr 26-May 3, 9am-4pm; UBC Robson Square. $345+tax
Register Now

[Top]

Troubleshooting and Designing Access Databases
(formerly Access – Level 2)

Starting with data in various forms including ASCII text files, Excel spreadsheets and existing Access databases, examine typical problems that arise when dealing with data that is not appropriately formatted. Explore advanced topics relating to table maintenance, queries, forms, reports, relationships between tables and exports to different file types. For details, view tech.ubc.ca/hope.
Note: You will need Access 2000 or later in order to fully utilize the material covered in this course.

Prerequisites: Introduction to Access (IG009) or equivalent and access to the Internet (Mozilla Firefox or Internet Explorer 6.0 or later).

Highly Recommended: Experience in working with Access for at least six months.
2 Mon, May 10-17, 9am-4pm; UBC Robson Square. $345+tax
Register Now

[Top]

PowerPoint 2007

PowerPoint 2007 has a new look with the addition of the Ribbon. This course helps you upgrade your skills from PowerPoint 2003 and shows you timesaving tips to help you make sense of the Ribbon. Students learn to apply new design themes, find favourite settings and menu items, and use new effects for text including soft shadows and WordArt. Students also customize the Quick Access Toolbar, discover Smart Art, import outlines from Word and turn them into effective slide presentations with animation, sounds, narration and special effects.
Note: Please bring a USB drive to class.

Prerequisite: Prior experience with PowerPoint 2003 or earlier would be an asset.
2 Sat, May 8-15, 9am-4pm; UBC Robson Square. $345+tax
Register Now

[Top]

Introduction to Simply Accounting 2009 NEW

This introductory workshop is intended for small to medium-sized business owners. Learn how to set up your company profile and manage inventory, accounts payable, accounts receivable and more with Simply Accounting 2009.
Note: Please bring a USB key to class.

Prerequisite: Knowledge of accounting principles and concepts in North America.
Recommended for newcomers to Canada: Fundamental Accounting Principles and Concepts in North America (IG093).

(Presented in Mandarin)
2 Tue & 2 Thu, Mar 16-25, 6:30-9:30pm; UBC Point Grey. $345+tax
Register Now

(Presented in English)
4 Wed, Apr 21-May 12, 6:30-9:30pm; UBC Point Grey. $345+tax
Register Now

[Top]

Fundamental Accounting Principles and Concepts in North America NEW

This 6-hour course is targeted to newcomers to Canada who have no accounting knowledge or experience in the North American business environment. You learn basic accounting concepts including the accounting cycle, transactions, journals, general ledgers, trial balances and financial statements.

2 Wed, Jun 16-23, 6:30-9:30pm; UBC Point Grey. $250+tax
Register Now

Effective Workplace Communication Skills

Effective communication is an essential part of taking your valuable ideas from concept to reality. Learn the skills to communicate with your target audience. In this workshop you develop writing, speaking, teamwork and interpersonal communication skills to help you realize your ideas. This workshop helps you to think strategically about your communications in the workplace setting. We look at a range of practices and guidelines to give you the opportunity to practise your skills, and provide you with feedback to help you strengthen them. For details, view tech.ubc.ca/hope.

2 Tue, Jun 1-8, 6:30-9:30pm; UBC Robson Square. $250+tax
Register Now

[Top]