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

Outlook 2007/2010: Getting out of the Inbox
JIM HOPE

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 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. Please view instructor Jim Hope's website for more detailed information.

Note: We recommend prior experience with Microsoft Office Outlook 2003 or 2007.
IG007W12A 1 Tue, Jan 17, 9am-4pm; UBC Robson Square. $250+tax
Register Now

Excel - Introduction
JIM HOPE

As the spreadsheet component of Microsoft Office, Excel is an extremely versatile tool for manipulating numeric data, creating charts and sorting and filtering text data. In this hands-on introductory workshop you will examine spreadsheet principles, charting, data management and printing. Several applications for Excel are explored using examples and case studies. Please view instructor Jim Hope's website for more detailed information.

Prerequisite: A working knowledge of Windows.
IG016W12A 2 Tue, Jan 24 and 31, 9am-4pm; UBC Robson Square. $345+tax
Register Now

Quickbooks for Business Owners
ELENA BARANOVSKAYA

Although QuickBooks is a popular accounting software program, many users feel intimidated by its vast capacity. Discover how to effectively use the program, avoid errors and produce useful reports. This course covers sales and collections, purchases and payments, payroll and government reporting of payroll liabilities and sales taxes, budgeting, and reporting. Learn how to customize reports that suit your specific objectives. Content is based on Intuit recommendations, extensive instructor knowledge of the program and feedback from users ranging from business owners to accounting clerks.

Note: Please bring a USB flash drive to class.
IG094W12A 6 Mon, Feb 6-Mar 12, 6:30-9:30pm; UBC Robson Square. $530+tax
Register Now

Access - Introduction
JIM HOPE

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. Please view instructor Jim Hope's website for more detailed information.

Prerequisite: A working knowledge of Windows.
IG009W12A 2 Tue, Feb 7 and 14, 9am-4pm; UBC Robson Square. $345+tax
Register Now

Excel - Troubleshooting and Designing Worksheets
JIM HOPE

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. Please view instructor Jim Hope's website for more detailed information.

Note: This course is most relevant to those who have been working with Excel for six months or more.
Prerequisite: Excel - Introduction (IG016) or equivalent.
IG017W12A 2 Tue, Feb 21 and 28, 9am-4pm; UBC Robson Square. $345+tax
Register Now

Access - Troubleshooting and Designing Databases
JIM HOPE

Starting with data in various forms including ASCII text files, Excel spreadsheets and existing Access databases, you 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. Please view instructor Jim Hope's website for more detailed information.

Note: Access 2000 or later is required in order to fully utilize the material in this course. Experience in working with Access for at least six months is highly recommended.
Prerequisite: Access – Introduction (IG009) or equivalent
IG047W12A 2 Tue, Mar 6 and 13, 9am-4pm; UBC Robson Square. $345+tax
Register Now

NEW Adobe Acrobat - Improving Your Digital Workflow

This introductory course explains what Adobe Acrobat is and how it can help you work more efficiently. Learn how to convert documents to PDF format, combine and modify documents, and prepare them for distribution, whether for print, the Web or presentations. More advanced functionality, such as creating electronic forms and adding document navigation, is also covered.

IG083 Next offered in Spring/Summer 2012

PowerPoint 2007
GERALDINE SOMBKE

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. You learn to apply new design themes, find favourite settings and menu items, and use new effects for text including soft shadows and WordArt. You 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 flash drive to class. Prior experience with PowerPoint 2007 or later would be an asset.
IG028 Next offered in Spring/Summer 2012

Windows 7 and Office 2007/2010
JIM HOPE

If you have just upgraded your PC, this course introduces you to Microsoft’s latest operating system. Find your favourite old Windows features and discover new ones. Explore the new user interface, instant search and sync centre, and Office 2007 updates, including the Ribbon and new menu, charting engine and Microsoft Live.

Note: Internet access is required for an optional assignment. Prior experience with Windows XP or Vista and Microsoft Office is recommended.
IG316 Next offered in Spring/Summer 2012

Word 2007/2010 QuickStart
JIM HOPE

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

Note: Prior experience with Word 2007 or earlier would be an asset.
IG004 Next offered in Spring/Summer 2012

[Top]