Courses
The Computer Skills for the Office and the Administrative Assistant programs are both eligible for short-term skills training funding starting fall 2023. Learn more about the StrongBC Future Skills grant here.
Courses
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.
This course is not offered at this time. Please email rchow@langara.ca for details.
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.
This course is not offered at this time. Please email rchow@langara.ca for details.
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.
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.