Certification Prep for Microsoft Office 2019
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.
Table of Contents
Abbreviated Contents
Certification Prep for Microsoft Office 2019
- Front Matter
- Microsoft Word
- Word Lesson 1 Basic Overview
- Word Lesson 2 Quick Tour and Features
- Word Lesson 3 Image and WordArt 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
- Appendix Microsoft Office Specialist (MOS) Exam Correlation Charts