Gain the skills required to pass the Microsoft Office certification exam with the Microsoft Office 2019 course and lab. The lab is versatile and delivers a hands-on experience, replacing expensive physical labs. The Microsoft Office training course covers objectives of the Microsoft Office Specialist and Expert exams for Word 2019 and offers an interactive learning experience in creating and saving documents and using different document views; inserting, formatting, and laying out pictures; inserting and formatting tables; and more.
Here’s what you will get
The Microsoft Word (Word and Word 2019) certification validates candidates’ competency in the correct application of the principal features of Word by creating and editing documents for a variety of purposes and situations. The MOS Word 2019 exam covers the ability to create and maintain professional-looking reports, multi-column newsletters, resumes, and business correspondence.
Lessons
59+ Lessons | 624+ Quizzes | 413+ Flashcards | 413+ Glossary of terms
TestPrep
77+ Pre Assessment Questions | 80+ Post Assessment Questions |
Hand on lab
134+ LiveLab | 00+ Minutes
Lessons 1: Introduction
Lessons 2: Fundamentals
- Module A: Getting around
- Module B: Creating documents
- Module C: Document views
- Summary
Lessons 3: Formatting
- Module A: Formatting characters
- Module B: Formatting paragraphs
- Module C: Quick Styles
- Module D: Making lists
- Summary
Lessons 4: Document setup
- Module A: Page layout
- Module B: Proofing documents
- Module C: Printing, headers, and footers
- Module D: Templates
- Summary
Lessons 5: Graphics
- Module A: Inserting pictures
- Module B: Formatting pictures
- Module C: Picture layout
- Summary
Lessons 6: Tables
- Module A: Creating tables
- Module B: Formatting tables
- Summary
Lessons 7: Introduction
Lessons 8: Illustrations
- Module A: Shapes and text
- Module B: SmartArt
- Module C: 3D models
- Summary
Lessons 9: Managing documents
- Module A: Custom themes
- Module B: Building blocks
- Module C: Section breaks
- Module D: Page backgrounds
- Summary
Lessons 10: Styles
- Module A: Character styles
- Module B: Paragraph styles
- Summary
Lessons 11: References and hyperlinks
- Module A: Reference notes
- Module B: Table of contents
- Module C: Hyperlinks
- Summary
Lessons 12: Navigation and organization
- Module A: Navigating documents
- Module B: Master documents
- Summary
Lessons 13: Saving and sharing documents
- Module A: Saving and sending
- Module B: Comments
- Module C: Protecting documents
- Summary
Lessons 14: Introduction
Lessons 15: Advanced formatting
- Module A: Tables and charts
- Module B: Creating building blocks
- Module C: Linking text
- Summary
Lessons 16: Advanced document management
- Module A: Configuring Word options
- Module B: Working with templates
- Module C: Tracking and reviewing changes
- Summary
Lessons 17: Using references
- Module A: Internal references
- Module B: Indexing
- Module C: Citing external sources
- Summary
Lessons 18: Creating mailings
- Module A: Recipient lists
- Module B: Performing mail merges
- Module C: Envelopes and labels
- Summary
Lessons 19: Macros and forms
- Module A: Macros
- Module B: Forms
- Summary
Appendix A: Internationalization and accessibility
- Module A: Internationalization
- Module B: Managing accessibility in documents
Appendix B: Video Tutorials
Lessons 22: Introduction
Lessons 23: Fundamentals
- Module A: Getting around
- Module B: Workbook basics
- Summary
Lessons 24: Creating worksheets
- Module A: Entering data
- Module B: Formulas
- Module C: Functions
- Module D: Moving and copying data
- Module E: Reference types
- Summary
Lessons 25: Formatting
- Module A: Text formatting
- Module B: Number formatting
- Module C: Alignment
- Module D: Borders and highlighting
- Module E: Styles and themes
- Summary
Lessons 26: Manipulating data
- Module A: Data entry shortcuts
- Module B: Paste options
- Module C: Inserting, deleting, and hiding
- Summary
Lessons 27: Charts
- Module A: Creating charts
- Module B: Chart types and elements
- Summary
Lessons 28: Output
- Module A: Managing worksheet windows
- Module B: Printing worksheets
- Module C: Sharing workbooks
- Summary
Lessons 29: Settings and templates
- Module A: Workbook options and properties
- Module B: Templates
- Summary
Lessons 30: Introduction
Lessons 31: Managing workbooks
- Module A: Managing worksheets
- Module B: Customizing Excel
- Summary
Lessons 32: Named ranges
- Module A: Using names in formulas
- Summary
Lessons 33: Tables
- Module A: Sorting
- Module B: Filtering tables
- Module C: Structured references
- Module D: Validation
- Module E: Transposing data
- Summary
Lessons 34: Summarizing data
- Module A: Consolidation
- Module B: Subtotals
- Summary
Lessons 35: PivotTables
- Module A: Creating and formatting PivotTables
- Module B: Manipulating PivotTables
- Module C: PivotCharts
- Summary
Lessons 36: Presentation features
- Module A: Conditional formats
- Module B: Custom Formats
- Module C: Graphics
- Summary
Lessons 37: Advanced charts
- Module A: Special chart types
- Module B: Sparklines
- Module C: Quick Analysis
- Summary
Lessons 38: Collaboration
- Module A: Permissions
- Module B: Shared workbooks
- Summary
Lessons 39: Introduction
Lessons 40: Logical and Lookup Functions
- Module A: Decision-making functions
- Module B: Lookup and reference functions
- Summary
Lessons 41: Advanced Formulas
- Module A: Auditing and error-trapping
- Module B: Formula options
- Module C: Arrays
- Summary
Lessons 42: Special functions
- Module A: Date and time functions
- Module B: Text functions
- Module C: Other functions
- Summary
Lessons 43: Importing and Exporting
- Module A: The Power Pivot Data Model
- Module B: Exporting data
- Summary
Lessons 44: Analysis
- Module A: What-if analysis
- Module B: The Analysis Toolpak
- Summary
Lessons 45: Macros and Forms
- Module A: Recording macros
- Module B: Running macros
- Module C: Forms
- Summary
Appendix: Video Tutorials
Lessons 47: Introduction
Lessons 48: Fundamentals
- Module A: Exploring the PowerPoint environment
- Summary
Lessons 49: Creating a presentation
- Module A: Creating a presentation
- Module B: Creating and modifying slide content
- Summary
Lessons 50: Formatting
- Module A: Working with slide masters and layouts
- Module B: Formatting slides and text
- Summary
Lessons 51: Working with shapes and images
- Module A: Creating and formatting shapes
- Module B: Working with images
- Summary
Lessons 52: Working with charts and tables
- Module A: Working with charts
- Module B: Working with tables
- Summary
Lessons 53: Customization
- Module A: Slide transitions
- Module B: Additional text options
- Module C: Printing
- Summary
- Creating a Presentation and its Slide and Exploring the PowerPoint Environment: Interactive Exercise
- testing
- test2
Lessons 54: Introduction
Lessons 55: Advanced formatting
- Module A: Inserting and formatting SmartArt
- Module B: Inserting and formatting 3D models
- Module C: Additional formatting options
- Summary
Lessons 56: Animation, time effects, and media
- Module A: Animating slide content
- Module B: Inserting and formatting media
- Summary
Lessons 57: Reviewing content, tracking changes, and saving in other formats
- Module A: Reviewing content and tracking changes
- Module B: Saving a presentation in other formats
- Summary
Lessons 58: Custom slide shows
- Module A: Working with notes pages
- Module B: Configuring, rehearsing, and presenting slide shows
- Summary
Lessons 59: Sharing, collaborating, and security
- Module A: Protecting your presentations
- Module B: Sharing your presentations
- Summary
- Working with slide masters and layouts, creating…rmatting shapes and images: Interactive Exercise
- Working with slide masters and layouts, creating…rmatting shapes and images: Interactive Exercise
- Working with slide masters and layouts, and crea…rmatting shapes and images: Interactive Exercise
- Working with charts and tables, applying slide t… WordArt from text, and setting printer settings
Hands-on LAB Activities
Fundamentals
- Zooming a Document
- Creating and Saving a Document
Formatting
- Formatting the Text to Bold
- Changing the Font Style and Font Size
- Changing the Text Color
- Showing the Paragraph Marks
- Changing the Heading Style
- Creating a Bulleted List
- Inserting and Editing a Citation
Document setup
- Changing the Basic Page Setup
- Formatting the Text into Columns
- Adding an AutoCorrect Shortcut
- Setting the Header and Footer
- Creating a Document Using a Template
Graphics
- Inserting a Picture from a File
Tables
- Formatting the Table Border
- Inserting Rows and Columns
- Inserting a Table
- Modifying the Table Design
Illustrations
- Inserting a Shape
- Using WordArt
- Adding a SmartArt
- Inserting a 3D Model
Managing documents
- Creating a Custom Theme
- Inserting a Cover Page
- Using Section Breaks
- Adding Color to a Page
- Adding a Watermark
Styles
- Inserting a Symbol
References and hyperlinks
- Inserting an Endnote
- Modifying and Inserting Footnotes
- Inserting a Table of Contents Using Marked Entries
- Creating an Email Hyperlink
Saving and sharing documents
- Creating PDF and XPS Documents
- Creating a Blog Post
- Adding and Modifying a Comment
- Editing Restrictions
- Finding and Replacing Text
Advanced formatting
- Creating a Chart
- Inserting a Formula
Advanced document management
- Combining Documents
- Using Document Tracking
Using references
- Adding a Bookmark
- Indexing a Document
- Inserting a Bibliography
- Editing a Citation
Creating mailings
- Creating a Signature Line
- Creating a Mail Merge
Fundamentals
- Saving a Workbook
Creating worksheets
- Creating a New Workbook
- Performing Calculations with Formulas
- Entering a Function
- Using Relative, Absolute, and Mixed References
Formatting
- Changing the Date Format
- Formatting Numbers
- Merging a Heading
- Applying a Theme
Manipulating data
- Deleting and Editing the Cell Content
Charts
- Creating a Simple Chart
- Changing the Chart Color
- Changing the Chart Style
- Editing a Legend in the Chart
- Creating a Column Chart and Switching its Rows and Columns
Output
- Splitting a Large Worksheet
- Setting Page Margin
- Setting and Saving the Print Area
- Adding a Header
- Saving a Workbook as a PDF File
Settings and templates
- Checking Compatibility
- Creating a Workbook from a Template
Managing workbooks
- Inserting Hyperlink to an Image
Named ranges
- Creating Names for Cell Ranges
- Editing Names
Tables
- Sorting Data
- Sorting by Multiple Columns
- Filtering Data
- Creating Formulas Using Structured References
PivotTables
- Creating a PivotTable Automatically
Presentation features
- Inserting WordArt
- Inserting SmartArt
Advanced charts
- Inserting a Trendline on a Chart
- Customizing Sparklines
Collaboration
- Adding Comments
- Merging Shared Workbooks
Logical and Lookup Functions
- Using the IF Function
- Using the SUMIF Function
- Using the SUMIFS Function
- Using VLOOKUP
- Using the MATCH Function
Advanced Formulas
- Using an Array Formula
- Using an Array Function
Special functions
- Performing Calculations Using Date Functions
- Performing Simple Time Calculations
- Using the Concatenate Function
- Calculating the Minimum and Maximum Sales Value
Importing and Exporting
- Importing Data from a File
- Creating Relationships Between Tables
- Exporting to a Text File
Macros and Forms
- Creating a Blank Form
Creating a presentation
- Creating a Presentation Using a Template
- Duplicating a Slide
- Inserting Content into a Placeholder
- Inserting a Hyperlink on a Slide
- Inserting an Online Image
- Inserting an Image from the Desktop
Formatting
- Adding and Modifying a Footer
- Applying a Theme
- Modifying the Slide Layout
- Formatting a Slide’s Background
- Applying and Formatting Bulleted and Numbered Lists
Working with shapes and images
- Showing Gridlines
- Inserting and Formatting Shapes
- Applying the Artistic Effect
- Applying Effects to a Shape
- Applying Styles and Effects to a Picture
- Applying Image Alt Text
- Inserting a Screenshot
Working with charts and tables
- Adding a Chart to a Presentation
- Working with Tables
- Importing and Editing a Table
Customization
- Applying the Transition
- Creating WordArt from the Text
Advanced formatting
- Inserting SmartArt and Arranging the Picture’s Position
- Converting a List into SmartArt
- Inserting and Modifying a 3D Model
Animation, time effects, and media
- Applying Animation on an Online Picture
- Animating Text
- Animating a 3D Model
- Adding a Video
Reviewing content, tracking changes, and saving in other formats
- Checking the Spelling Automatically
- Adding a Comment
- Modifying the Text Style
- Customizing the Handout Master
Custom slide shows
- Adding Notes
- Creating a Custom Slide Show
- Rehearsing Slide Timings
Sharing, collaborating, and security
- Making a Presentation Read-Only
Reviews
There are no reviews yet.