Access
MICROSOFT OFFICE ACCESS
| Access 2010 | Access 2013 | Access O365 |
| Course Outline | Course Outline | Course Outline |
| Exercise File | Exercise File | |
Course Objective:In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft® Office Access™ relational database application. Target Student:The Level 1 course is for the individual whose job responsibilities include working with tables to create and maintain records, locate records, and produce reports based on the information in the database. It also provides the fundamental knowledge and techniques needed to advance to more technical Access responsibilities, such as creating and maintaining new databases and using programming techniques that enhance Access applications. |
||
| Access 2010 | Access 2013 | Access O365 |
| Course Outline | Course Outline | Course Outline |
| Exercise File | Exercise File | |
Course Objective:You will maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Microsoft® Office Access™ with other applications. Target Student:The Level 2 course is for individuals whose job responsibilities include maintaining data integrity; handling complex queries, forms, and reports; and sharing data between Access and other applications. This course is also a prerequisite to taking more advanced courses in Access. Individuals who want to pursue Microsoft Certified Application Specialist certification in Microsoft Office Access can also take this course. |
||
| Access 2010 | Access 2013 | Access O365 |
| Course Outline | Course Outline | Course Outline |
| Exercise File | Exercise File | |
Course Objective:You will create complex Access databases by structuring existing data, writing advanced queries, working with macros, making effective use of forms and reports, and performing database maintenance. Target Student:This course is for the individual whose job responsibilities include working with related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for students pursuing the Microsoft® Office Specialist Certification for Microsoft® Office Access™, and it is a prerequisite to take more advanced courses in Microsoft® Office Access™ |
||
Excel
Microsoft® Office® Excel
| Excel 2010 | Excel 2013 | Excel O365 |
| Course Outline | Course Outline | Course Outline |
| Exercise File | Exercise File | |
Course Objective:You will create and edit basic Microsoft® Office Excel® worksheets and workbooks. Target Student:This course is designed for people preparing for certification as a Microsoft Certified Application Specialist in Excel, who already have knowledge of Microsoft® Office, Windows® 2000 (or above), and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel worksheets. |
||
| Excel 2010 | Excel 2013 | Excel O365 |
| Course Outline | Course Outline | Course Outline |
| Exercise File | Exercise File | |
Course Objective:You will apply visual elements and advanced formulas to a worksheet to display data in various formats. Target Student:The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web. In addition, this course helps prepare students who desire to take the Microsoft Office Specialist exam in Excel and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets. |
||
| Excel 2010 | Excel 2013 | Excel O365 |
| Course Outline | Course Outline | Course Outline |
| Exercise File | Exercise File | |
Course Objective:You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications. Target Student:This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data. In addition, the course is also for students desiring to prepare for the Microsoft Certified Application Specialist exam in Microsoft® Office Excel®, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data. |
||
| Excel 2010 | Excel 2013 | Excel O365 | |
| Course Outline | Course Outline | Course Outline | |
| Exercise File | |||
Course Objective:You will use VBA to create macros for automating repetitive tasks in Excel. Target Student:Students looking to gain the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. In addition, students who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data. |
|||
| Excel 2010 | Excel 2013 | Excel O365 | |
| Course Outline | Course Outline | Course Outline | |
Course Objective:You will be introduced to the new features in Microsoft Office Excel. Target Student:This course is designed for experienced Excel users who have worked with earlier versions of Microsoft Office Excel and who have upgraded. |
|||
Office - New Features
Microsoft® Office®
| Course Outline | Exercise File | |
Course Objective:You will work with the new and updated features of Microsoft Office 2016. Target Student:This course is intended for individuals who already have foundational knowledge and skills in Office 2010 or 2013 and who are interested in transitioning from the earlier version of Office to Office 2016. |
||
Office 365 - OneDrive
Microsoft® Office®
| Course Outline | ||
Course Objective:In this course, you will be able to use your knowledge of the Office 2007 or 2010 desktop application suite to work productively in the cloud-based Microsoft Office 365 environment. Target Student:This course is intended for business users and knowledge workers in a variety of roles and fields who have competence in a desktop-based installation of the Microsoft® Office 2007 or 2010 edition of the Microsoft Office productivity suite, and who are now extending Microsoft Office to a collaborative cloud-based Office 365 environment. |
||
OneNote
Microsoft® Office® OneNote®
| OneNote 2010 | OneNote 2013 | OneNote O365 | |
| Course Outline | Course Outline | Course Outline | |
| Exercise File | Exercise File | ||
Course Objective:In this course, you will develop digital note-taking, note-collaboration, and note-synchronizing skills with Microsoft OneNote 2013, which will allow you to create and update notes; manage lists and outlines; search; add content including voice memos, pictures, and video; take notes in online meetings; and interact with other Microsoft software programs. Target Student:This course is intended for students, educators, business users, and knowledge workers in a variety of roles and fields who have competence in a desktop-based installation of the 2007 or 2010 edition of the Microsoft Office productivity suite, and who are now incorporating digital note-taking and note collaboration with Microsoft OneNote 2013 into their standard work environment while using a laptop, desktop, tablet, or other mobile device. |
|||
Outlook
Microsoft® Office® Outlook®
| Outlook 2010 | Outlook 2013 | Outlook O365 |
| Course Outline | Course Outline | Course Outline |
| Exercise File | Exercise File | |
Course Objective:You will compose and send email, schedule appointments and meetings, manage contact information and tasks, and use notes. Target Student:This course is designed for any person with a basic understanding of Microsoft Windows who needs to use Microsoft® Office Outlook® to compose and send email, schedule appointments and meetings, manage contact information and tasks, and use notes. In addition, this course helps prepare students who desire to take the Microsoft Certified Applications Specialist certification for Outlook. |
||
| Outlook 2010 | Outlook 2013 | Outlook O365 |
| Course Outline | Course Outline | Course Outline |
| Exercise File | Exercise File | |
Course Objective:You will customize your environment, Calendar, and mail messages to meet your specific needs as well as track, share, assign, and quickly locate various Outlook items. Target Student:This course is designed for experienced Outlook users who need to customize their environment, Calendar, and email messages to meet their specific requirements and who wish to track, share, assign, and locate various Outlook items. |
||
| Outlook 2010 | Outlook 2013 | Outlook O365 | |
| Course Outline | Course Outline | Course Outline | |
| Exercise File | Exercise File | Exercise File | |
Course Objective:You will work with the advanced features of Outlook. Target Student:This course is for persons with an intermediate understanding of Outlook and who need to use Outlook to personalize and organize their email, Outlook items, manage Outlook data files, share and link contacts, create forms, and work offline and remotely. |
|||
PowerPoint
Microsoft® Office® PowerPoint™
| PowerPoint 2010 | PowerPoint 2013 | PowerPoint O365 |
| Course Outline | Course Outline | Course Outline |
| Exercise File | Exercise File | |
Course Objective:You will explore the PowerPoint environment and create a new presentation. You will format text on slides to enhance clarity. In order to enhance the visual appeal, you will add graphical objects to a presentation and modify them. You will also add tables and charts to a presentation to present data in a structured form. You will then finalize a presentation to deliver it. Target Student:This course is designed for students who are interested in learning the fundamentals needed to create and modify basic presentations using Microsoft® Office PowerPoint. This course is also intended for students interested in pursuing Microsoft Office Specialist certification in Microsoft® Office PowerPoint |
||
| PowerPoint 2010 | PowerPoint 2013 | PowerPoint O365 |
| Course Outline | Course Outline | Course Outline |
| Exercise File | ||
Course Objective:You will enhance your presentation with features that will transform it into a powerful means of communication. You will customize the PowerPoint interface to suit your requirements and use the new and enhanced features to create dynamic and visually appealing presentations. You will then finalize a presentation and secure it to authenticate its validity. Target Student:This course is designed for students who want to gain the skills necessary to work with design templates, various types of diagrams, special effects, custom slide shows, collaboration functionality, and advanced presentation delivery. This course also assists in the preparation for the Microsoft Office Specialist exam in Microsoft® Office PowerPoint. It is for students who already have knowledge of the basics of PowerPoint, including slide formatting and working with tables, charts, images, objects, and presentation preparation. |
||
| PowerPoint 2010 | PowerPoint 2013 | PowerPoint O365 | |
| Course Outline | Course Outline | Course Outline | |
Course Objective:You will explore the components of the results-oriented interface of the PowerPoint environment and customize the interface to suit your requirements. You will identify and use the new and enhanced features of PowerPoint to create dynamic and visually appealing presentations. You will then finalize a presentation and secure it with a digital signature to authenticate its validity. Target Student:This course is designed for experienced PowerPoint users who have worked with earlier versions of Microsoft Office PowerPoint and who have upgraded. |
|||
Project
Microsoft® Office® Project™
| Project 2010 | Project 2013 | Project O365 |
| Course Outline | Course Outline | Course Outline |
| Exercise File | ||
Course Objective:You will create a project plan containing tasks, organize these tasks in a work breakdown structure containing task relationships, create and assign resources, and finalize the project to implement the project plan. Target Student:This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans. |
||
| Project 2010 | Project 2013 | Project O365 |
| Course Outline | Course Outline | Course Outline |
| Exercise File | ||
Course Objective:You will exchange project plan data with other applications, update project plans, create visual reports, and reuse project plan information. Target Student:This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans. |
||
Publisher
Microsoft® Office® Publisher™
| Publisher 2010 | Publisher 2013 | Publisher O365 |
| Course Outline | Course Outline | |
| Exercise File | ||
Course Objective:You will create, manage, revise, and distribute publications. Target Student:This course was designed for persons with a basic understanding of Microsoft Windows and Microsoft Word who need to learn how to use Microsoft® Publisher to create, layout, and edit publications. |
||
Visio
Microsoft® Office® Visio™
| Visio 2010 | Visio 2013 | Visio O365 |
| Course Outline | Course Outline | Course Outline |
| Exercise File | Exercise File | |
Course Objective:You will design and manage basic diagrams, workflows, and flowcharts. Target Student:This course is designed for persons who have an understanding of basic workflows and the concept of end-to-end flowcharting. |
||
| Visio 2010 | Visio 2013 | Visio O365 |
| Course Outline | Course Outline | Course Outline |
| Exercise File | Exercise File | |
Course Objective:You will create custom elements and a custom template, represent external data as a drawing, and share your work with others. Target Student:This course is designed for individuals who have an understanding of the basic workflow and the concept of end-to-end flowcharting. |
||
Word
Microsoft® Office® Word™
| Word 2010 | Word 2013 | Word O365 |
| Course Outline | Course Outline | Course Outline |
| Exercise File | Exercise File | |
Course Objective:You will create, edit, and enhance standard business documents using Microsoft® Office Word. Target Student:This course is intended for individuals who want to gain basic knowledge of working on Word. Individuals who want to pursue Microsoft Certified Application Specialist certification in Microsoft Office Word can also take this course. |
||
| Word 2010 | Word 2013 | Word O365 |
| Course Outline | Course Outline | Course Outline |
| Exercise File | Exercise File | |
Course Objective:You will create complex documents in Microsoft® Office Word documents and build personalized efficiency tools in Microsoft Word. Target Student:This course was designed for persons who can create and modify standard business documents in Microsoft Word, and who need to learn how to use Microsoft Word to create or modify complex business documents as well as customized Word efficiency tools. It will be helpful for persons preparing for the Microsoft Certified Application Specialist exams for Microsoft Word. |
||
| Word 2010 | Word 2013 | Word O365 |
| Course Outline | Course Outline | Course Outline |
| Exercise File | Exercise File | |
Course Objective:You will create, manage, revise, and distribute long documents. Target Student:This course is designed for persons who want to gain skills necessary to manage long documents, collaborate with others, and secure documents. In addition, it will be helpful for persons preparing for the Microsoft Certified Application Specialist exams for Microsoft® Office Word. |
||
| Word 2010 | Word 2013 | Word O365 | |
| Course Outline | Course Outline | Course Outline | |
Course Objective:You will explore the components of the results-oriented interface of the Word environment and customize the interface to suit your requirements. You will then use the tools available in Word to create documents that look professional and also visually appealing. You will then compare different versions of a document, in addition to finalizing and securing your document before it reaches its target audience. Target Student:This course is designed for experienced Word users who have worked with earlier versions of Microsoft Office Word and who have upgraded. |
|||