Certification Prep for Microsoft Office 2019

By: D. Michael Ploor
Copyright: 2021
Subject: Certification - Microsoft
Grade Level: 9-14
Certification Prep for Microsoft Office 2019 will help prepare the user to take the Microsoft Office Specialist (MOS) 2019 certification exams. It provides step-by-step instruction for the features and commands covered on the Word, PowerPoint, Excel, Access, and Outlook certification exams. Each certification preparation guide can be completed in approximately 2.5 to 3 hours. Certification as a Microsoft Office Specialist demonstrates an aptitude with Microsoft Office software.
Products & Prices College & Career
ProductsISBNRetail PriceOrder Quantity
arrow image
Online Text, 1yr. Indv. Subscription (Instant Access)
978-1-64564-260-2
978-1-64564-260-2$60.00*
arrow image
Online Text, 6yr. Classroom Subscription (min. 15)
978-1-64564-261-9
978-1-64564-261-9$106.64*
*Qualified schools may be eligible for a 25% discount.
Please select a cart item or enter a item quantity above.

Table of Contents
Microsoft Word
Word Lesson 1: Basic Overview
Word Lesson 2: Quick Tour and Features
Word Lesson 3: Images and Word Art Basics
Word Lesson 4: Table Basics
Word Lesson 5: Lists, Colors, and Shapes
Word Lesson 6: Hyperlinks, Bookmarks, and Section Breaks
Word Lesson 7: References
Word Lesson 8: Page Views
Word Lesson 9: Reviewing a Document
Word Lesson 10: Backstage Tasks
Word Lesson 11: Mailings
Word Skills Mastery: Certification Simulation
Microsoft PowerPoint
PowerPoint Lesson 1: Basic Overview
PowerPoint Lesson 2: Beginning PowerPoint 2019
PowerPoint Lesson 3: Enhancing a Basic Presentation
PowerPoint Lesson 4: Tables and Bullets
PowerPoint Lesson 5: Chart Templates
PowerPoint Lesson 6: Creating an Organizational Chart Using SmartArt
PowerPoint Lesson 7: Hyperlinks and Buttons
PowerPoint Lesson 8: Proofing and Publishing
PowerPoint Lesson 9: Transitions and Timing
PowerPoint Lesson 10: Graphics and Photo Albums
PowerPoint Skills Mastery: Certification Simulation
Microsoft Excel
Excel Lesson 1: Basic Overview
Excel Lesson 2: Program Layout
Excel Lesson 3: Getting Acquainted
Excel Lesson 4: Data Tables
Excel Lesson 5: Using Formulas and Functions
Excel Lesson 6: Using Templates, Themes, and Images
Excel Lesson 7: Pivot Tables, SmartArt Graphics, and Charts
Excel Skills Mastery: Certification Simulation
Microsoft Access
Access Lesson 1: Introduction and Vocabulary
Access Lesson 2: Tables and Data Types
Access Lesson 3: Forms
Access Lesson 4: Data Entry
Access Lesson 5: Reports
Access Lesson 6: Queries
Access Lesson 7: Table Functions
Access Lesson 8: Query Functions
Access Lesson 9: Database Relationships
Access Lesson 10: Using Templates, Importing Data, and Backstage Tasks
Access Skills Mastery: Certification Simulation
Microsoft Outlook
Outlook Lesson 1: Basic Overview
Outlook Lesson 2: Outlook Setup
Outlook Lesson 3: Contacts
Outlook Lesson 4: Messages
Outlook Lesson 5: Tasks
Outlook Lesson 6: Calendar and Meetings
Outlook Lesson 7: Settings and Rules
Outlook Lesson 8: Alternative Practice for Activities Requiring an E-mail Server
Appendix: MOS Certification Exam Correlation Charts
Look Inside
The Look Inside images are for preview purposes only. The format of the actual product may vary from the images shown.
Online Text, 1yr. Indv. Subscription (Instant Access)
g-wonlinetextbooks.com
Front Matter (g-wonlinetextbooks.com Certification - Microsoft)
g-wonlinetextbooks.com
Word Lesson 3 (g-wonlinetextbooks.com Certification - Microsoft)
g-wonlinetextbooks.com
Excel Lesson 3 (g-wonlinetextbooks.com Certification - Microsoft)
Correlations
Microsoft Office Specialist
About the Author(s)

D. Michael Ploor - is the author of the CORE series of certification preparation guides. Mr. Ploor’s students have achieved exceptional results with the CORE certification preparation guides. His students collectively pass more than 500 industry certification exams each year without the need for other preparation materials. Mr. Ploor has demonstrated the strength of integrating the CORE guides in a diverse mix of courses.

Mr. Ploor is also the author of several textbooks on the subject of video game design: Video Game Design and Programming Concepts, Video Game Design Foundations, Video Game Design Composition, and Introduction to Video Game Design. He is a National Board Certified Teacher in Career and Technical Education and holds an MBA degree from the University of South Florida. He maintains professional teaching credentials in Business Education and as an Education Media Specialist.

Mr. Ploor is at the forefront of innovative teaching and curriculum development. He developed STEM curriculum while serving as the lead teacher in the Career Academy of Computer Game Design at Middleton Magnet STEM High School. Mr. Ploor has applied his skills as a STEM Curriculum Integration Specialist in designing innovative curriculum and by collaborating to construct the state standards for video game design in several states. He has also been instrumental in authoring competitive events for career and technical student organizations (CTSOs) such as the Future Business Leaders of America (FBLA) and Phi Beta Lambda (PBL).

In addition to publishing textbooks and lessons, Mr. Ploor provides professional development as a frequent presenter at regional and national conferences to promote CTE education and video game design curriculum.