Microsoft Office 2019

Introduction

Fundamentals

• Module A: Getting around
• Module B: Creating documents
• Module C: Document views
• Summary

Formatting

• Module A: Formatting characters
• Module B: Formatting paragraphs
• Module C: Quick Styles
• Module D: Making lists
• Summary

Document setup

• Module A: Page layout
• Module B: Proofing documents
• Module C: Printing, headers, and footers
• Module D: Templates
• Summary

Graphics

• Module A: Inserting pictures
• Module B: Formatting pictures
• Module C: Picture layout
• Summary

Tables

• Module A: Creating tables
• Module B: Formatting tables
• Summary

Introduction

Illustrations

• Module A: Shapes and text
• Module B: SmartArt
• Module C: 3D models
• Summary

Managing documents

• Module A: Custom themes
• Module B: Building blocks
• Module C: Section breaks
• Module D: Page backgrounds
• Summary

Styles

• Module A: Character styles
• Module B: Paragraph styles
• Summary

References and hyperlinks

• Module A: Reference notes
• Module B: Table of contents
• Module C: Hyperlinks
• Summary

Navigation and organization

• Module A: Navigating documents
• Module B: Master documents
• Summary

Saving and sharing documents

• Module A: Saving and sending
• Module B: Comments
• Module C: Protecting documents
• Summary

Introduction

Advanced formatting

• Module A: Tables and charts
• Module B: Creating building blocks
• Module C: Linking text
• Summary

Advanced document management

• Module A: Configuring Word options
• Module B: Working with templates
• Module C: Tracking and reviewing changes
• Summary

Using references

• Module A: Internal references
• Module B: Indexing
• Module C: Citing external sources
• Summary

Creating mailings

• Module A: Recipient lists
• Module B: Performing mail merges
• Module C: Envelopes and labels
• Summary

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

Introduction

Fundamentals

• Module A: Getting around
• Module B: Workbook basics
• Summary

Creating worksheets

• Module A: Entering data
• Module B: Formulas
• Module C: Functions
• Module D: Moving and copying data
• Module E: Reference types
• Summary

Formatting

• Module A: Text formatting
• Module B: Number formatting
• Module C: Alignment
• Module D: Borders and highlighting
• Module E: Styles and themes
• Summary

Manipulating data

• Module A: Data entry shortcuts
• Module B: Paste options
• Module C: Inserting, deleting, and hiding
• Summary

Charts

• Module A: Creating charts
• Module B: Chart types and elements
• Summary

Output

• Module A: Managing worksheet windows
• Module B: Printing worksheets
• Module C: Sharing workbooks
• Summary

Settings and templates

• Module A: Workbook options and properties
• Module B: Templates
• Summary

Introduction

Managing workbooks

• Module A: Managing worksheets
• Module B: Customizing Excel
• Summary

Named ranges

• Module A: Using names in formulas
• Summary

Tables

• Module A: Sorting
• Module B: Filtering tables
• Module C: Structured references
• Module D: Validation
• Module E: Transposing data
• Summary

Summarizing data

• Module A: Consolidation
• Module B: Subtotals
• Summary

PivotTables

• Module A: Creating and formatting PivotTables
• Module B: Manipulating PivotTables
• Module C: PivotCharts
• Summary

Presentation features

• Module A: Conditional formats
• Module B: Custom Formats
• Module C: Graphics
• Summary

Advanced charts

• Module A: Special chart types
• Module B: Sparklines
• Module C: Quick Analysis
• Summary

Collaboration

• Module A: Permissions
• Module B: Shared workbooks
• Summary

Introduction

Logical and Lookup Functions

• Module A: Decision-making functions
• Module B: Lookup and reference functions
• Summary

Advanced Formulas

• Module A: Auditing and error-trapping
• Module B: Formula options
• Module C: Arrays
• Summary

Special functions

• Module A: Date and time functions
• Module B: Text functions
• Module C: Other functions
• Summary

Importing and Exporting

• Module A: The Power Pivot Data Model
• Module B: Exporting data
• Summary

Analysis

• Module A: What-if analysis
• Module B: The Analysis Toolpak
• Summary

Macros and Forms

• Module A: Recording macros
• Module B: Running macros
• Module C: Forms
• Summary

Appendix: Video Tutorials

Introduction

Fundamentals

• Module A: Exploring the PowerPoint environment
• Summary

Creating a presentation

• Module A: Creating a presentation
• Module B: Creating and modifying slide content
• Summary

Formatting

• Module A: Working with slide masters and layouts
• Module B: Formatting slides and text
• Summary

Working with shapes and images

• Module A: Creating and formatting shapes
• Module B: Working with images
• Summary

Working with charts and tables

• Module A: Working with charts
• Module B: Working with tables
• Summary

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

Introduction

Advanced formatting

• Module A: Inserting and formatting SmartArt
• Module B: Inserting and formatting 3D models
• Module C: Additional formatting options
• Summary

Animation, time effects, and media

• Module A: Animating slide content
• Module B: Inserting and formatting media
• Summary

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

Custom slide shows

• Module A: Working with notes pages
• Module B: Configuring, rehearsing, and presenting slide shows
• Summary

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