GO! with Office 2019 Introductory, 1/e + MyLab IT w/ Pearson eText

Shelley Gaskin, Series Editor, is a professor in the Business and Computer Technology Division at Pasadena City College in Pasadena, California. She holds a bachelor’s degree in business administration from Robert Morris College (Pennsylvania), a master’s degree in business from Northern Illinois University, and a doctorate in adult and community education from Ball State University (Indiana). Before joining Pasadena City College, she spent 12 years in the computer industry, where she was a systems analyst, sales representative, and director of customer education with Unisys Corporation. She also worked for Ernst & Young on the development of large systems applications for their clients. She has written and developed training materials for custom systems applications in both the public and private sectors, and has also written and edited numerous computer application textbooks.Alicia Vargas is a faculty member in business information technology at Pasadena City College. She holds a master’s and a bachelor’s degree in business education from California State University, Los Angeles, and has authored several textbooks and training manuals on Microsoft® Word™, Microsoft Excel™, and Microsoft PowerPoint™.Debra Geoghan is a professor of computer science in the STEM department at Bucks County Community College, teaching computer classes ranging from basic computer literacy to cybercrime, computer forensics, and networking. She has certifications from Microsoft, CompTIA®, and Apple®. Deb has taught at the college level since 1996 and also spent 11 years in the high school classroom. She holds a BS in secondary science education from Temple University and an MA in computer science education from Arcadia University.Throughout her teaching career, Deb has worked with educators to integrate technology across the curriculum. At BCCC she serves on many technology committees, presents technology workshops for BCCC faculty, and heads the computer science area. Deb is an avid user of technology, which has earned her the nickname “gadget lady.”Nancy Graviett is a professor and department chair in business technology at St. Charles Community College in Cottleville, Missouri. She holds a bachelor’s degree in marketing and a master’s degree in business education from the University of Missouri and has completed a certificate in online education. Nancy has authored textbooks on WordPerfect™, Google®, Microsoft Outlook™, and Microsoft Access™.

• MICROSOFT OFFICEChapter 1: Microsoft Office Common Features and Windows 10 Features and File Management1. Explore Microsoft Office2. Create a Folder for File Storage3. Download and Extract Zipped Files and Enter, Edit, and Check the Spelling of Text in an Office Program4. Perform Office Commands and Apply Office Formatting5. Finalize an Office Document6. Use the Office Help Features7. Explore Windows 108. Prepare to Work with Folders and Files9. Use File Explorer to Extract Zipped Files and to Display Locations, Folders, and Files10. Start Programs and Open Data Files11. Create, Rename, and Copy Files and FoldersWORDIntroducing Microsoft Word 2019Chapter 1: Creating Documents with Microsoft Word1. Create a New Document and Insert Text2. Insert and Format Graphics3. Insert and Modify Text Boxes and Shapes4. Preview and Print a Document5. Change Document and Paragraph Layout6. Create and Modify Lists7. Set and Modify Tab Stops8. Insert a SmartArt Graphic and an IconChapter 2: Creating Cover Letters and Using Tables to Create Resumes1. Create a Table for a Resume2. Format a Table3. Present a Word Document Online4. Create a Letterhead for a Cover Letter5. Create a Cover Letter and Correct and Reorganize Text6. Use the Word Editor to Check Your Documents7. Print an Envelope, Change Style Sets, Create a Word Template and Use Learning ToolsChapter 3: Creating Research Papers, Newsletters, and Merged Mailing Labels1. Create a Research Paper2. Insert Footnotes in a Research Paper3. Create Citations and a Bibliography in a Research Paper4. Use Read Mode and PDF Reflow5. Format a Multiple-Column Newsletter6. Use Special Character and Paragraph Formatting7. Create Mailing Labels Using Mail MergeEXCELIntroducing Microsoft Excel 2019Chapter 1: Creating a Worksheet and Charting Data1. Create, Save, and Navigate an Excel Workbook2. Enter Data in a Worksheet3. Construct and Copy Formulas and Use the SUM Function4. Format Cells with Merge & Center, Cell Styles, and Themes5. Chart Data to Create a Column Chart and Insert Sparklines6. Print a Worksheet, Display Formulas, and Close Excels7. Check Spelling in a Worksheet8. Enter Data by Range9. Construct Formulas for Mathematical Operations10. Edit Values in a Worksheet11. Format a WorksheetChapter 2: Using Functions, Creating Tables, and Managing Large Workbooks1. Use Flash Fill and the SUM, AVERAGE, MEDIAN, MIN, and MAX Functions2. Move Data, Resolve Error Messages, and Rotate Text3. Use COUNTIF and IF Functions and Apply Conditional Formatting4. Use Date & Time Functions and Freeze Panes5. Create, Sort, and Filter an Excel Table6. View, Format, and Print a Large Worksheet7. Navigate a Workbook and Rename Worksheets8. Enter Dates, Clear Contents, and Clear Formats9. Copy and Paste by Using the Paste Options Gallery10. Edit and Format Multiple Worksheets at the Same Time11. Create a Summary Sheet with Column Sparklines12. Format and Print Multiple Worksheets in a WorkbookChapter 3: Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools1. Chart Data with a Pie Chart2. Format a Pie Chart3. Edit a Workbook and Update a Chart4. Use Goal Seek to Perform What-If Analysis5. Design a Worksheet for What-If Analysis6. Answer What-If Questions by Changing Values in a Worksheet7. Chart Data with a Line ChartACCESSIntroduction to Microsoft Access 2019Chapter 1: Getting Started with Microsoft Access 20191. Identify Good Database Design2. Create a Table and Define Fields in a Blank Desktop Database3. Change the Structure of Tables and Add a Second Table4. Create a Query, Form, and Report5. Close a Database and Close Access6. Use a Template to Create a Database7. Organize Objects in the Navigation Pane8. Create a New Table in a Database Created with a Template9. View a ReportChapter 2: Sort and Query a Database1. Open and Save an Existing Database2. Create Table Relationships3. Sort Records in a Table4. Create a Query in Design View5. Create a New Query From an Existing Query6. Sort Query Results7. Specify Criteria in a Query8. Specify Numeric Criteria in a Query9. Use Compound Criteria in a Query10. Create a Query Based on More Than One Table11. Use Wildcards in a Query12. Create Calculated Fields in a Query13. Calculate Statistics and Group Data in a Query14. Create a Crosstab Query15. Create a Parameter QueryChapter 3: Forms, Filters, and Reports1. Create and Use a Form to Add and Delete Records2. Filter Records3. Create a Form by Using the Form Wizard4. Modify a Form in Layout View and in Design View5. Create a Report by Using the Report Tool and Modify the Report in Layout View6. Create a Report by Using the Report Wizard7. Modify the Design of a Report8. Keep Grouped Data Together in a Printed ReportPOWERPOINTIntroducing Microsoft PowerPoint 2019Chapter 1: Getting Started with Microsoft PowerPoint1. Create a New Presentation2. Edit a Presentation in Normal View3. Add Pictures to a Presentation4. Print and View a Presentation5. Edit an Existing Presentation6. Format a Presentation7. Use Slide Sorter View8. Apply Slide TransitionsChapter 2: Formatting PowerPoint Presentations1. Format Numbered and Bulleted Lists2. Insert Online Pictures3. Insert Text Boxes and Shapes4. Format Objects5. Remove Picture Backgrounds and Insert WordArt6. Create and Format a SmartArt GraphicChapter 3: Enhancing a Presentation with Animation, Video, Tables, and Charts1. Customize Slide Backgrounds and Themes2. Animate a Slide Show3. Insert a Video4. Create and Modify Tables5. Create and Modify ChartsINTEGRATED PROJECTSChapter 1: Integrating Word, Excel, Access, and PowerPoint