Make your everyday tasks easier by taking your skills to a high level and gain a valuable credential for your portfolio. Companies, organizations all around the world use Microsoft’s Word, Excel, PowerPoint, Access, Project, Visio, and Macros and VBA products.
This flexible program makes it possible to customize a certificate to meet your specific needs. If you already have experience in an application, you may begin your learning at the level that fits your needs.
Courses may be completed in any combination as long as all prerequisites are met.
Courses have been developed at a level that meets Microsoft certification criteria in Word, Excel, PowerPoint, or Access. and to get passed you should get 128 study hours
CORE COURSES – 64 hours
Students must take at course (16 hours) from each of: Word, Excel, PowerPoint and Access. The remaining requirement of six courses may be made up of higher level courses in these streams, or from the list of optional courses.
WORD – 16 hours
Microsoft Word Level 1 and 2 – 16 hours
This course teaches students how to create and edit documents, save, open and close documents, apply formatting options, set tabs and indents, change the view mode, manipulate the text using features such as copy/paste, and preview/print documents. Microsoft Word Level 1 teaches the information worker how to work with different types of documents using a variety of core and intermediate features to create and format business documents such as letters, forms, and newsletters.
Create more complex documents. Students will learn features such as creating and formatting tables, inserting and modifying pictures or shapes, learn what merging means in relation to mass mailings, and look at different ways of sharing documents with others.
Use a variety of intermediate and advanced features to create and format business documents such as online forms, personalized mailings, or cites reference sources. Students will learn about automating tasks using merge features, referencing sources used in a document, organizing information by sorting and outlining, protecting documents, and collaborating on documents with others.
EXCEL – 16 hours
Microsoft Excel Level 1 and 2 – 16 hours
Microsoft Excel Level 1 has been designed to reinforce workforce skills. Students learn to create and edit professional-looking spreadsheets for a variety of purposes and situations. Students work on real-world problems like the ones they will encounter in the workplace ensuring they are ready for real professional challenges.
Apply basic skill sets along with some intermediate to advanced functions to manage and audit numerical reports. Students will learn to create and manipulate charts, work with different types of graphics, and look at various methods of analyzing, organizing, linking and sharing workbooks, learn to use advanced formatting features.
How to work with different types of documents using a variety of core and intermediate features to create and edit professional-looking spreadsheets for a variety of purposes and situations. Students will look at productivity tools to increase data entry, features to enable collaboration with others, and use various commands to analyze large numerical reports.
POWERPOINT – 16 hours
Microsoft PowerPoint allows the information worker to create and manage presentations. Students will learn how to add and edit text; create templates; add and modify slides layouts and themes; add and modify WordArt, graphics, shapes or illustrations, SmartArt, tables and charts; create and modify slide masters; add, remove and create custom animations; use slideshow features; create a presentation from an outline; import slides; insert hyperlinks, media clips and sounds; view and manage markups and comments; add signatures and security; remove hidden data; create self-running presentations and publish to a web server.
ACCESS – 16 hours
Microsoft Access Level 1 and 2 – 16 hours
Microsoft Access Level 1 has been designed to re-enforce workforce skills. Students learn to create and manage a database, and build tables and forms. Students will work on real-world problems like the ones they will encounter in the workforce ensuring they are ready for real professional challenges.
Use advanced commands to work with forms, reports, designing tables, and manipulating queries. Students will learn a variety of commands, functions, and database capabilities.
Use advanced commands to work with forms, reports, designing tables, manipulating queries, as well as using sub-forms.
OPTIONAL COURSES 0 – 80 hours (at least 64 hour)
Microsoft Macros and VBA Level 1 and 2 – 16 hours
Take full advantage of Microsoft Office suite by automating routine tasks. No matter which application you’re using, there are some tasks you perform dozens of times, such as typing a section of text, running a series of menu commands, or formatting a document in a particular way.
This course shows you how to accomplish the same tasks by incorporating them into a macro that you can run with just a few mouse clicks or keystrokes.
Exploring the advanced features of VBA programming. Students will learn how to write programs that control Microsoft Excel. You will receive dozens of example macros that will provide you with practical, business-oriented tools that you can use right away to improve your productivity .
Microsoft Outlook Levels 1 and 2 – 16 hours
Microsoft Outlook Levels 1 and 2 teaches students how to: create, edit, send and manage messages; use different features for tracking; manage attachments; manage email folders; create signatures; create and modify appointments, meetings, contacts, notes and tasks; work with data files; create search folders; manage auto replies; use RSS; manage security; share calendar and contacts.
Microsoft Project Levels 1 and 2 – 16 hours
Microsoft Project Levels 1 and 2 teaches robust project management tools with the right blend of usability, power, and flexibility, so the user can manage projects more efficiently and effectively. Stay informed and control project work, schedules, and finances; keep project teams aligned; and be more productive through integration with familiar Microsoft Office system programs, powerful reporting, guided planning, and flexible tools. Learn to better organize projects and people. Discover core tools to manage schedules and resources independently.
Microsoft SharePoint Levels 1 and 2 – 16 hours
Students will learn how to create and format content, manage SharePoint sites, participate in user communities, configure and consume site search results, and integrate SharePoint services with Microsoft Office applications. Microsoft SharePoint is a web application platform that can be used to provide content management, document and file management, intranet portals, collaboration, social networks, extra-nets, websites, enterprise search, and business intelligence. It also has capabilities around system integration, process integration, and workflow automation.
Microsoft Visio Levels 1 and 2 – 16 hours
Microsoft Visio Levels 1 and 2 teaches students how to: create and work with stencils and drawing pages; utilize drawing tools; utilize the text editing and formatting tools; use shape
connectors; add headers, footers and backgrounds to drawings; create, modify and apply custom styles; master shapes; layers; background pages; how to manipulate shapes; understand shape behaviours, and enter custom shape data.
Students who take four courses per session can complete this program in less than one year.
You can take courses first and enroll in the certificate later; however, as programs are subject to change, we recommend you apply for admission to the certificate as early as possible. Once you are admitted, you can be confident that you have locked in the requirements leading to your graduation.To be admitted students must be 18 years of age; successful completion of grade 12 or equivalent; workplace experience is an asset. If English is not your first language please review the English language proficiency requirements. A degree or diploma is not required to enroll in the program certificate.
PRIOR LEARNING ASSESSMENT
Prior learning from other post-secondary institutions Advanced Standing may be granted for equivalent, graded courses completed at other post-secondary institutions. Credit may be granted for up to a maximum of 30 hours towards this certificate.