Language: English
Short Description: Office 2019 has useful features and tools to master, and whether you're upgrading from an earlier version or encountering the Office applications for the first time, you'll appreciate this simplified approach. If you're looking for a way to get up to speed quickly on the 2019 version of Microsoft Office, this course offers step-by-step instructions to make it easy. Microsoft Office holds more than 90 percent of the market for Windows-based productivity suites. Our MS Office 2019 course makes this technology easy to understand, even for those who are new to computers. With this program you will learn to create and edit documents using Word, create and manage worksheets using Excel, develop presentations using PowerPoint, create and manage databases using Access, and manage email and calendars using Outlook. Mastering all of these skills will give you the confidence to utilize these office tools in any professional or personal setting. Included with this training, you will receive an exam voucher to sit for and obtain the Microsoft Office Specialist certification credential. This credential will show your knowledge and skills using all the features of Office 2019.
Instructor Description: This class supported by an Educational Mentor. Educational mentors have worked or are working in the subject they mentor. Educational Mentors review student work, student progress, and interact with students as needed. They respond to any questions or concerns you might have, as well as encouraging and motivating students to succeed.
Certification: WORD EXAM: Candidates should be able to create and edit 2-3 page documents for a variety of purposes and situations. Examples include professional-looking reports, multi-column newsletters, résumés, and business correspondence.
EXCEL EXAM: Candidates should be able to create and edit a workbook with multiple sheets for a variety of purposes and situations.
POWERPOINT EXAM: Candidates for this exam are IT professionals who use Office to build secure and flexible applications.
Requirements
This course includes all required materials.
Hide Syllabus
Lesson 1
Microsoft Office 2019 Module 1
Common Office Tasks
All About Office 365
Office Interface
Saving Your Files
Manipulating the Text
Handling Case or Capitalization
Entering Symbols and Foreign Characters
Undoing and Repeating Commands
Correcting Typos
AutoCorrect Command
Microsoft Office 2019 Module 2
Working With Word Part 1
Speed Techniques
Creating a New Document
Selecting Text
Laying Out Text and Pages
Numbering
Headers and Footers
Hyphenating Text
Word Styles
Constructing the Perfect Table
Neat Table Tricks
Microsoft Office 2019 Module 3
Working With Word Part 2
Spelling and Grammatical Errors
Finding and Replacing Text
Desktop Publishing with Word
Experimenting with Themes
Highlighting Parts of a Document
Track Changes
Reports and Scholarly Papers
Generating a Table of Contents
Compiling a Bibliography
Microsoft Office 2019 Module 4
Working With Excel
New Excel Workbook
Entering Data in a Workbook
Refining Your Worksheet
Selecting Cells
Deleting, Copying and Moving Data
Formulas and Functions
Laying Out a Worksheet
Analyzing Data
Managing Information Lists
Microsoft Office 2019 Module 5
Working With PowerPoint
Creating a New Presentation
Selecting, Moving and Deleting Slides
Themes and Slide Backgrounds
Choosing Slide Size
Footers and Headers on Slides
Transitions and Animations
Adding Audio
Adding Notes
Rehearsing and Timing
Microsoft Office 2019 Module 6
Working With Outlook
Outlook Folders
Categorizing Items
Searching for Stray Folder Items
Contacts Folder
Handling Email
Calendar
Scheduling Appointments and Events
Managing Time and Schedule
Tasks, Reminders and Notes
Microsoft Office 2019 Module 7
Working with Access
Tables and Queries
Forms
Creating a Database File
Designing a Database
Field Properties
Entering Data
Sorting
Querying
Filtering for Data
Microsoft Office 2019 Module 8
Working with Publisher
Introducing Frames
Creating a Publication
Redesigning a Publication
Formatting Text
Text Wraps
Placeholder Pictures
Frames
Decorating the Text
Design Checker
Microsoft Office 2019 Module 9
Working with Charts and Graphs
Creating a Chart
Saving a Chart as a Template
Chart Tricks
SmartArt Diagram
Handling Graphics and Photos
Touching Up a Picture
Drawing and Manipulating Lines, Shapes and Objects
WordArt
Microsoft Office 2019 Module 10
One Step Beyond
Customizing the Ribbon
Customizing the Quick Access Toolbar
Ways of Distributing Your Work
Working with Publisher
Printing a Publication
Filing Sharing and Collaborating
OneDrive
Sharing Files and Folders with Other
Hide Syllabus
buy 
Login/Create account
checkout
view cart (
0
)
