GO! with Microsoft Office 365, 2019 Edition Introductory

<div class="c-un-numbered-headers-and-contents-list__container"> <h3>MICROSOFT OFFICE</h3> <ul> <li><strong>Chapter 1: Microsoft Office Common Features and Windows 10 Features and File Management</strong> <ol> <li>Explore Microsoft Office</li> <li>Create a Folder for File Storage</li> <li>Download and Extract Zipped Files and Enter, Edit, and Check the Spelling of Text in an Office Program</li> <li>Perform Office Commands and Apply Office Formatting</li> <li>Finalize an Office Document</li> <li>Use the Office Help Features</li> <li>Explore Windows 10</li> <li>Prepare to Work with Folders and Files</li> <li>Use File Explorer to Extract Zipped Files and to Display Locations, Folders, and Files</li> <li>Start Programs and Open Data Files</li> <li>Create, Rename, and Copy Files and Folders</li> </ol></li> </ul> <h3>WORD</h3> <ul> <li>Introducing Microsoft Word 2019</li> </ul> <ul> <li><strong>Chapter 1: Creating Documents with Microsoft Word</strong> <ol> <li>Create a New Document and Insert Text</li> <li>Insert and Format Graphics</li> <li>Insert and Modify Text Boxes and Shapes</li> <li>Preview and Print a Document</li> <li>Change Document and Paragraph Layout</li> <li>Create and Modify Lists</li> <li>Set and Modify Tab Stops</li> <li>Insert a SmartArt Graphic and an Icon</li> </ol></li> <li><strong>Chapter 2: Creating Cover Letters and Using Tables to Create Resumes</strong> <ol> <li>Create a Table for a Resume</li> <li>Format a Table</li> <li>Present a Word Document Online</li> <li>Create a Letterhead for a Cover Letter</li> <li>Create a Cover Letter and Correct and Reorganize Text</li> <li>Use the Word Editor to Check Your Documents</li> <li>Print an Envelope, Change Style Sets, Create a Word Template and Use Learning Tools</li> </ol></li> <li><strong>Chapter 3: Creating Research Papers, Newsletters, and Merged Mailing Labels</strong> <ol> <li>Create a Research Paper</li> <li>Insert Footnotes in a Research Paper</li> <li>Create Citations and a Bibliography in a Research Paper</li> <li>Use Read Mode and PDF Reflow</li> <li>Format a Multiple-Column Newsletter</li> <li>Use Special Character and Paragraph Formatting</li> <li>Create Mailing Labels Using Mail Merge</li> </ol></li> </ul> <h3>EXCEL</h3> <ul> <li>Introducing Microsoft Excel 2019</li> </ul> <ul> <li><strong>Chapter 1: Creating a Worksheet and Charting Data</strong> <ol> <li>Create, Save, and Navigate an Excel Workbook</li> <li>Enter Data in a Worksheet</li> <li>Construct and Copy Formulas and Use the SUM Function</li> <li>Format Cells with Merge &amp; Center, Cell Styles, and Themes</li> <li>Chart Data to Create a Column Chart and Insert Sparklines</li> <li>Print a Worksheet, Display Formulas, and Close Excels</li> <li>Check Spelling in a Worksheet</li> <li>Enter Data by Range</li> <li>Construct Formulas for Mathematical Operations</li> <li>Edit Values in a Worksheet</li> <li>Format a Worksheet</li> </ol></li> <li><strong>Chapter 2: Using Functions, Creating Tables, and Managing Large Workbooks</strong> <ol> <li>Use Flash Fill and the SUM, AVERAGE, MEDIAN, MIN, and MAX Functions</li> <li>Move Data, Resolve Error Messages, and Rotate Text</li> <li>Use COUNTIF and IF Functions and Apply Conditional Formatting</li> <li>Use Date &amp; Time Functions and Freeze Panes</li> <li>Create, Sort, and Filter an Excel Table</li> <li>View, Format, and Print a Large Worksheet</li> <li>Navigate a Workbook and Rename Worksheets</li> <li>Enter Dates, Clear Contents, and Clear Formats</li> <li>Copy and Paste by Using the Paste Options Gallery</li> <li>Edit and Format Multiple Worksheets at the Same Time</li> <li>Create a Summary Sheet with Column Sparklines</li> <li>Format and Print Multiple Worksheets in a Workbook</li> </ol></li> <li><strong>Chapter 3: Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools</strong> <ol> <li>Chart Data with a Pie Chart</li> <li>Format a Pie Chart</li> <li>Edit a Workbook and Update a Chart</li> <li>Use Goal Seek to Perform What-If Analysis</li> <li>Design a Worksheet for What-If Analysis</li> <li>Answer What-If Questions by Changing Values in a Worksheet</li> <li>Chart Data with a Line Chart</li> </ol></li> </ul> <h3>ACCESS</h3> <ul> <li>Introduction to Microsoft Access 2019</li> <li><strong>Chapter 1: Getting Started with Microsoft Access 2019</strong> <ol> <li>Identify Good Database Design</li> <li>Create a Table and Define Fields in a Blank Desktop Database</li> <li>Change the Structure of Tables and Add a Second Table</li> <li>Create a Query, Form, and Report</li> <li>Close a Database and Close Access</li> <li>Use a Template to Create a Database</li> <li>Organize Objects in the Navigation Pane</li> <li>Create a New Table in a Database Created with a Template</li> <li>View a Report</li> </ol></li> <li><strong>Chapter 2: Sort and Query a Database</strong> <ol> <li>Open and Save an Existing Database</li> <li>Create Table Relationships</li> <li>Sort Records in a Table</li> <li>Create a Query in Design View</li> <li>Create a New Query From an Existing Query</li> <li>Sort Query Results</li> <li>Specify Criteria in a Query</li> <li>Specify Numeric Criteria in a Query</li> <li>Use Compound Criteria in a Query</li> <li>Create a Query Based on More Than One Table</li> <li>Use Wildcards in a Query</li> <li>Create Calculated Fields in a Query</li> <li>Calculate Statistics and Group Data in a Query</li> <li>Create a Crosstab Query</li> <li>Create a Parameter Query</li> </ol></li> <li><strong>Chapter 3: Forms, Filters, and Reports</strong> <ol> <li>Create and Use a Form to Add and Delete Records</li> <li>Filter Records</li> <li>Create a Form by Using the Form Wizard</li> <li>Modify a Form in Layout View and in Design View</li> <li>Create a Report by Using the Report Tool and Modify the Report in Layout View</li> <li>Create a Report by Using the Report Wizard</li> <li>Modify the Design of a Report</li> <li>Keep Grouped Data Together in a Printed Report</li> </ol></li> </ul> <h3>POWERPOINT</h3> <ul> <li>Introducing Microsoft PowerPoint 2019</li> </ul> <ul> <li><strong>Chapter 1: Getting Started with Microsoft PowerPoint</strong> <ol> <li>Create a New Presentation</li> <li>Edit a Presentation in Normal View</li> <li>Add Pictures to a Presentation</li> <li>Print and View a Presentation</li> <li>Edit an Existing Presentation</li> <li>Format a Presentation</li> <li>Use Slide Sorter View</li> <li>Apply Slide Transitions</li> </ol></li> <li><strong>Chapter 2: Formatting PowerPoint Presentations</strong> <ol> <li>Format Numbered and Bulleted Lists</li> <li>Insert Online Pictures</li> <li>Insert Text Boxes and Shapes</li> <li>Format Objects</li> <li>Remove Picture Backgrounds and Insert WordArt</li> <li>Create and Format a SmartArt Graphic</li> </ol></li> <li><strong>Chapter 3: Enhancing a Presentation with Animation, Video, Tables, and Charts</strong> <ol> <li>Customize Slide Backgrounds and Themes</li> <li>Animate a Slide Show</li> <li>Insert a Video</li> <li>Create and Modify Tables</li> <li>Create and Modify Charts</li> </ol></li> </ul> <h3>INTEGRATED PROJECTS</h3> <ul> <li><strong>Chapter 1: Integrating Word, Excel, Access, and PowerPoint</strong></li> </ul> </div>