ZPDI0584 - Microsoft Office 365 Suite 2019 (Online)

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.

• Cable and DSL internet connections recommended for best experience.

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

• 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.

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

• 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.