THE ILLUSTRATED SERIES, MICROSOFT OFFICE 365 & OFFICE 2019

Table of Contents (TOC)

Word 2019

· 1. Creating Documents with Word (Objective)

· 2. Editing and Formatting Documents

· 3. Formatting Text and Graphics

· 4. Formatting Tables and Documents

· 5. Working with Styles, Themes, and Building Blocks

· 6. Merging Word Documents

· 7. Illustrating Documents with Graphics

· 8. Integrating with Other Programs and Collaborating

· 9. Developing Multi-page Documents

· 10. Build Forms

Word Capstone Project:

Excel 2019

· 1. Getting Started with Excel

· 2. Formatting a Worksheet

· 3. Analyzing Data Using Formulas

· 4. Working with Charts

· 5. Working with Tables

· 6. Managing Workbook Data

· 7. Working with Images and Integrating With Other Programs

· 8. Analyzing Data with PivotTables

· 9. Automating Worksheet Tasks

· 10. Advanced Worksheet Management

· 11. Advanced Formulas and Functions

· 12. Performing What-If Analysis

Excel Capstone Project:

Access 2019

· 1. Getting Started with Access

· 2. Building Tables and Relationships

· 3. Creating Queries

· 4. Working with Forms and Reports

· 5. Improving Tables and Creating Advanced Queries

· 6. Creating Forms

· 7. Creating Reports

· 8. Importing and Exporting Data

· 9. Creating Action Queries

· 10. Creating Macros

· 11. Creating Modules and VBA

· 12. Completing the Application

Access Capstone Project: