Computer Skills for the Office

Use Access to create true relational databases with linked tables, data entry forms, queries, and printed reports. Import data from Excel spreadsheets and perform common tasks such as sorting, filtering, and searching records. Turn data into useful information with queries using multiple criteria, and perform database maintenance and back-ups. Prerequisites: Basic computer skills or equivalent recommended. Note: Textbook is optional and is available at the Langara Bookstore.

Use Excel to create effective and attractive spreadsheets. Enhance their appearance with borders, shading, font, and formatting. Introduction advanced features such as formulas, relative and absolute references, goal seek, and calculations with dates. Analyze your results with charts and format your worksheets for high-impact printing. Prerequisites: basic computer skills or equivalent. Note: Optional textbook available at the Langara Bookstore.

Use Powerpoint to create dynamic presentations. Quickly create slides with bullet text, ClipArt, SmartArt, and organization charts. Modify slide masters to create templates with your own look. Add animation effects, slide transitions, and audio. Learn how to output handouts with speaker notes, as well as HTML web pages. Prerequisites: Basic computer skills or equivalent recommended. Note: Textbook is optional and is available at the Langara Bookstore.

Learn how to create professional and attractive documents quickly and easily with Word. Use character, paragraph, and page formatting effectively, add ClipArt, set page borders, and use Smart Art to enhance your documents. Finally, take advantage of Office 365 features to speed up productivity.Prerequisites: basic computer skills or equivalent.Note: Optional textbook available at the Langara Bookstore.

This powerful organizer sets the standard for corporate email and scheduling. Learn how to manage your emails through the use of folders, send options, formatting, voting buttons, and attachments. Other handy features include: scheduling meetings, creating distribution lists, and using mail merge. Prerequisites: Computing Fundamentals, or equivalent. Note: Software for PC only.

Enhance the functionality of your excel spreadsheets with nested functions, If statements, VLookup, Pivot tables, and charts. Increase efficiency by linking cells, worksheets, and workbooks. Analyze data using subtotal functions and advanced filters. Enrich data analysis visually using conditional formatting. Incorporate workbook security features and more.Prerequisites: Excel 1 or equivalent. Note: Optional textbook available at the Langara Bookstore.

Use advanced features to quickly create larger documents with consistent styles, tables of contents, and more. Speed up your productivity with mail merge to generate form letters, address labels, envelopes, and catalogues. Learn how to create and work with table lists, columns, charts, and templates. Prerequisites: Word 1 or equivalent. Note: Optional textbook available at the Langara Bookstore.

Develop the skills you need to successfully manage projects - on time and on budget. Learn how to analyze risks, define tasks, develop a project scope, build teams, and create resource plans. Conclude with a peak at Microsoft Project and discover how to effectively use this tool to administer and organize your complex projects.

Quickbooks Online (QBO) has become one of the most popular accounting applications on the market. This course provides hands-on instruction on setting up Quickbooks on the cloud, customizing forms, and processing sales transactions, invoices, and bill payments, as well as managing inventory, payroll, and sales taxes through your web browser. You will also learn to use QBO to analyze financial data and improve your business strategies. All final exams conducted on campus, in person.Prerequisites: Bookkeeping Level 1 and basic computer skills or equivalent required. Note: Please bring a USB to class. Textbook and USB available at the Langara Bookstore for purchase.

Using Quickbooks Online (QBO), this course will teach you more advanced skills, such as banking and credit cards, foreign currencies, payroll, and how to customize settings. Additional topics include generating employee T4 slips and Employee Record of Employment. All final exams conducted on campus, in person.Prerequisites: Quickbooks 1 or equivalent experience required. Please bring a USB to class. Note: Textbook and USB available at the Langara Bookstore for purchase.

Design often starts in the professional layout tools such as: Illustrator, Photoshop, and InDesign. Through a series of practical assignments and projects you'll learn to confidently navigate these often obscure programs. Raise your standard of design with their sophisticated layout tools and professional typesetting for both vector and raster art. Prerequisites: Basic computer skills or equivalent recommended.

This course is not offered at this time. Please email rchow@langara.ca for details.

Adobe Acrobat is used by professionals in a variety of industries. However, you may not have had the opportunity to explore this softwares full potential. In this course, you will discover how to optimize and organize your PDF for print and web, use optical character recognition on a scan, create simple fillable forms, and add security settings to your files.

This course will increase your touch-typing speed for work, school, or business and is suitable for both beginners and those with some prior keyboarding experience. All participants will develop their skills through drills and exercises through an online keyboarding program. Textbook available at the Langara Bookstore.

This course is not offered at this time. Please email rchow@langara.ca for details.

For those with keyboarding skills, speed and accuracy become increasingly important. In addition to the mastering the alphabet keys, practice punctuations, symbols, and numbers. Textbook available at the Langara Bookstore. Prerequisite: Students must be able to type, at a minimum, 35 WPM accurately by touch.

This course is not offered at this time. Please email rchow@langara.ca for details.