ZPDI1524 - Microsoft Office 365 Suite 2019 (Online) (DPU)

Course Description

This course covers Word, Excel, PowerPoint and Outlook 2019. Students receive a free one-year Microsoft Office 365 license (from date of enrollment).

The course prepares students for the Microsoft Word 2019, Excel 2019, PowerPoint 2019 and Outlook 2019 national certification exams.

Course Outline

Microsoft Word 2019

• Lesson 1: Creating and Modifying a Flyer
• Lesson 2: Creating a Research Paper and a Multi-Page Document
• Lesson 3: Creating a Business Letter and Using Mail Merge
• Lesson 4: Creating a Resume and a Newsletter
• Lesson 5: Using Collaboration and Creating a Reference Document
• Lesson 6: Creating an Online Form and Using Macros

Microsoft Excel 2019

• Lesson 1: Creating a Worksheet
• Lesson 2: Working With Formulas and Large Worksheets
• Lesson 3: Financial Functions and Working in Multiple Spreadsheets
• Lesson 4: Creating Tables and Templates
• Lesson 5: Using PivotTables and Complex Problem-Solving
• Lesson 6: Data Analysis and User Interfaces

Microsoft PowerPoint 2019

• Lesson 1: Creating and Editing Presentations With Pictures
• Lesson 2: Enhancing Presentations With Shapes, SmartArt, WordArt, Charts and Tables
• Lesson 3: Customizing Slide Masters and Collaborating
• Lesson 4: Tables and Charts
• Lesson 5: Adding Media to a Presentation
• Lesson 6: Delivering the Presentation

Microsoft Outlook 2019

• Lesson 1: Managing Email Messages
• Lesson 2: Managing Calendars
• Lesson 3: Managing Contacts
• Lesson 4: Tasks
• Lesson 5: Customizing Outlook

Notes

Students have 12 months to complete this self-paced online course.

All necessary course materials included.

Certification(s):

• This course prepares students for the Microsoft Word 2019, Excel 2019, PowerPoint 2019 and Outlook 2019 national certification exams.

System Requirements:

Internet Connectivity Requirements:

• Cable and DSL internet connections recommended for best experience.

Hardware Requirements:

• CPU: 1 GHz or higher
• RAM: 2 GB or higher
• Resolution: 1280 x 720 or higher
• Speakers / Headphones
• Microphone (Webinar / Live Online sessions)

Operating System Requirements:

• Microsoft Windows 7 or 10 (Home, Pro)
• Mac OSX 10 or higher.
• Latest Chrome OS
• Latest Linux Distributions
  • NOTE: While our courses can be viewed on Android and iPhone devices, we do not recommend using these devices for our courses. The size of these devices does not provide a good learning environment for participants taking online or live online-based courses.

Web Browser Requirements:

• Latest Google Chrome recommended for best experience.
• Latest Mozilla Firefox
• Latest Microsoft Edge
• Latest Apple Safari

Basic Software Requirements:

• Office suite software (Microsoft Office, OpenOffice or LibreOffice)
• PDF reader program (Adobe Reader, FoxIt)
• Courses may require other software that is denoted in the above course outline.