Office Administration has evolved into a multi-tasking job that can include a variety of manual and electronic tasks, spreadsheet and basic financial management, as well as customer service and interpersonal relations. This program will build your skills in today's most commonly-used office computer applications and in the project management skills required by today's employers.
If you are not confident in using business software, such as the Microsoft Suite of programs, but enjoy multitasking and developing interpersonal relationships, this certificate will give you the skills you need to become a valued administrative member of an office team. If you already possess some knowledge of business software, this certificate allows you to upgrade your skills to a more advanced level.
Basic Windows computer and Internet skills (managing files and folders, keyboarding, email and Internet searches).
Details and registration below
Learn to use Microsoft Word for Windows, a word processing package that has the convenience and efficiencies of pull-down menus. Learn to create, edit, format and print documents. Use paragraph, page, and character formatting commands. Create multiple page documents with tables, and explore desktop publishing. Software: Word 2016, 2019 or 365. Not suitable for MAC users.
Learn to use Microsoft Excel to create and format spreadsheets in order to analyze data and make more informed business decisions. You will discover how to create, edit, format and print workbooks; use mathematical formulas and functions; create and format charts and shapes; insert images; cut, copy and paste data. Software: Excel 2016, 2019 or 365. Not suitable for MAC users.
Become proficient in a broad range of office tasks, including Internet research and reporting, e-mail messages, time and stress management, telecommunications, office reception and customer service, meetings and travel arrangements, office mail procedures and records management.
Obtain an overview of important communication concepts and skills required in business. Learn to write clear reports and documentation, make effective presentations, and foster interpersonal skills.
Learn the fundamental principles of project management including: project initiating, project definition, creating the Work Breakdown Structure, estimating effort, budgeting, scheduling using Gantt charts and network diagrams, risk management, controlling resources, quality assurance, auditing and closing.
Develop your understanding of customer service, both internal and external, and the skills associated with understanding the needs of customers, meeting those needs and fostering an environment that encourages customers to return.
Focus on recording business transactions, preparing financial statements, end-of-period adjustments, accounting for merchandising firms, accounts receivable, cash management and an introduction to financial ratios. Software requirements: Microsoft Word and Excel
These skills are valued in every company and organization. Practice creative thinking and reasoning techniques and apply these skills to help analyze and respond appropriately to a wide variety of personal and work situations, including strategic planning, decision-making and problem solving.
Building on the introductory Excel course, you will create and analyze spreadsheets using PivotTables and PivotCharts, and use Excel's What-If analysis tools. You will explore many of Excel's advanced functions, including logical and conditional, financial, date and time, and database functions and also how to create your own custom functions. In addition, you will learn how to protect and share their workbooks. Prerequisite: Excel - Core/Specialist or equivalent experience. Software: Microsoft Excel 2016, 2019 or 365 for Windows. Not suitable for MAC users. This course is designed for the Windows operating system.
Gain detailed insight into the functions of project planning and scheduling, resource allocation and costing, progress monitoring and reporting. Move from a basic to an advanced level of familiarity with the functions of Microsoft Project, a typical project management software. Prior experience with project management is recommended. Software: Microsoft Project 2019/365.
Using Microsoft Word, you will learn to combine basic design principles and techniques to produce a variety of printed matter, such as stationery, business cards, posters, newsletters, resumes, and more. This is a practical, hands-on course that will place emphasis on producing real-life, professional materials using specific desktop publishing terminology and document-handling techniques. Software: Microsoft Word 2016
QuickBooks Online is a cloud-based accounting software program. You will learn the difference between QuickBooks Pro and QuickBooks Online before utilizing program features such as tracking and communicating with customers, invoicing, supplier management, profitability analysis, payroll, HST management and reporting, as well as 3rd party application integration. As this course introduces you to computerized accounting, you will need experience with basic computer operations and bookkeeping principles before registering. A trial version of the software will be downloaded as part of the course.
Learn to use this database tool to manipulate, link, chart, query and report your data to customize information. Create databases, view, format, manage and modify data tables and fields. You will learn to create forms, queries, reports and explore data relationships using its pull-down menus, toolbars and dialog boxes. Microsoft certified courseware publication is used to present the software features in a well-illustrated graphic format. Software: Microsoft Access v. 2019/365.