Fleming College

Program Highlights

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.

Is This You?

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.

Career Prospects

• Front line / reception staff
• Office Assistant
• Office Administration
• Information Management
• Professional development

Recommended skills and pre-requisites

Basic Windows computer and Internet skills (managing files and folders, keyboarding, email and Internet searches).

Courses in Office Administration Certificate (Online)

Details and registration below

Mandatory

• Microsoft Word Core (COMP602)
• Microsoft Excel Core (COMP221)
• Office Technology and Procedures (BUSN055)
• Organizational Business Communications (COMM059)
• Introduction to Project Management (MGMT021)
• Building and Maintaining Customer Relationships (BUSN031)

Electives - choose 3

• Accounting Basics 1 (ACCT038)
• Creative and Critical Thinking - Leadership Development (BUSN153)
• Microsoft Excel Expert (COMP164)
• Project Management Scheduling Software (COMP289)
• Desktop Publishing for Business (COMP158)
• QuickBooks Online 1 (COMP283)
• Microsoft Access Core (COMP572)

Mandatory

Microsoft Word Core

COMP602

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.

Microsoft Excel Core

COMP221

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.

Office Technology and Procedures

BUSN055

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.

Organizational Business Communications

COMM059

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.

Introduction to Project Management

MGMT021

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.

Building and Maintaining Customer Relationships

BUSN031

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.

Electives - choose 3

Accounting Basics 1

ACCT038

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

Creative and Critical Thinking - Leadership Development

BUSN153

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.

Microsoft Excel Expert

COMP164

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.

Project Management Scheduling Software

COMP289

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.

Desktop Publishing for Business

COMP158

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 1

COMP283

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.

Microsoft Access Core

COMP572

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.