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.

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.

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.

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.

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

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.

Sage 50 is the popular and easy-to-use accounting software for home offices and small businesses. Learn to set up company files and enter transactions for general ledger, accounts receivables, accounts payable, and inventory, and how to manage capital expenses. All final exams conducted on campus, in person.Prerequisites: Bookkeeping Level 1 and basic computer skills or equivalent required. Note: Software for PC only. Textbook is required and available at the Langara Bookstore.

Build upon your Sage 50 knowledge by adding multi-currency transactions, bank reconciliations, payroll, customized reporting features, credit card payment, and receipts. Enter company histories and learn such important topics as network security, projects, and setting budgets. All final exams conducted on campus, in person.Prerequisites: Sage 50-1 or equivalent required. Note: Software for PC only. Textbook is required and available at the Langara Bookstore.

This course covers the setup and transaction processing of the Sage 300 Accounts Payable module. Topics include: recording of Accounts Payable Invoices, Adjustments, and Payment transactions. Other topics include: vendor and vendor group maintenance. At the end of the course, you will have the skills to work effectively as an accounts payable clerk using the Sage 300 ERP software. Prerequisites: Bookkeeping Level 1 and basic computer skills or equivalent required. Note: Textbook is optional and available at the Langara Bookstore. Software is for PC only and access to a laptop required.

This course focuses on recording transactions and analyzing reports in the General Ledger and Accounts Receivable module. Topics will include: advanced recording and editing of GL Journal Entries, and reporting of financial data. In addition, you will also learn to create and record invoices, payments, and adjustments in the Accounts Receivable module. Finally, there will be an in-depth discussion on how to reconcile bank statements using the appropriate modules. Prerequisites: Sage 300-1 or equivalent required. Note: Textbook optional and available at the Langara Bookstore. Software is for PC only and access to a laptop required.

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.

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.

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 is not offered at this time. Please email rchow@langara.ca for details.

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.

A knowledge of accounting is highly useful in modern business. This course is for individuals who want a brief but comprehensive introduction to up-to-date and practical accounting principles and procedures.Note: Textbook will be available for purchase at the Langara Bookstore prior to the first class.All final exams conducted on campus, in person.

Expand your knowledge of accounting principles, from journal entry to trial balance. Prepare yourself for a career in accounting by exploring the concepts of detailed financial statements, including adjusting and closing entries.Prerequisites: Bookkeeping Level 1 or equivalent.Note: Textbook will be available for purchase at the Langara Bookstore prior to the first class.All final exams conducted on campus, in person.

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.

Whether youre a beginner or simply want to refresh your skills, this course is the perfect introduction to the Office Suite. Create professional looking documents with Word, functional spreadsheets with Excel, and dynamic presentations with PowerPoint. Mandatory Prerequisite: Basic computer skills or equivalent. Note: Textbook is optional and is available at the Langara Bookstore.