About our authors 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 sector and has also written and edited numerous computer application textbooks.Alicia Vargas (Word and Excel author) 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 (PowerPoint author) 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 B.S. in Secondary Science Education from Temple University and an M.A. 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 (Access author) 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 OFFICE Chapter 1: Microsoft Office Common Features and Windows 10 Features and File Management Explore Microsoft OfficeCreate a Folder for File StorageDownload and Extract Zipped Files and Enter, Edit, and Check the Spelling of Text in an Office ProgramPerform Office Commands and Apply Office FormattingFinalize an Office DocumentUse the Office Help FeaturesExplore Windows 10Prepare to Work with Folders and FilesUse File Explorer to Extract Zipped Files and to Display Locations, Folders, and FilesStart Programs and Open Data FilesCreate, Rename, and Copy Files and FoldersWORD Introducing Microsoft Word 2019 Chapter 1: Creating Documents with Microsoft Word Create a New Document and Insert TextInsert and Format GraphicsInsert and Modify Text Boxes and ShapesPreview and Print a DocumentChange Document and Paragraph LayoutCreate and Modify ListsSet and Modify Tab StopsInsert a SmartArt Graphic and an IconChapter 2: Creating Cover Letters and Using Tables to Create Resumes Create a Table for a ResumeFormat a TablePresent a Word Document OnlineCreate a Letterhead for a Cover LetterCreate a Cover Letter and Correct and Reorganize TextUse the Word Editor to Check Your DocumentsPrint an Envelope, Change Style Sets, Create a Word Template and Use Learning ToolsChapter 3: Creating Research Papers, Newsletters, and Merged Mailing Labels Create a Research PaperInsert Footnotes in a Research PaperCreate Citations and a Bibliography in a Research PaperUse Read Mode and PDF ReflowFormat a Multiple-Column NewsletterUse Special Character and Paragraph FormattingCreate Mailing Labels Using Mail MergeEXCEL Introducing Microsoft Excel 2019 Chapter 1: Creating a Worksheet and Charting Data Create, Save, and Navigate an Excel WorkbookEnter Data in a WorksheetConstruct and Copy Formulas and Use the SUM FunctionFormat Cells with Merge & Center, Cell Styles, and ThemesChart Data to Create a Column Chart and Insert SparklinesPrint a Worksheet, Display Formulas, and Close ExcelsCheck Spelling in a WorksheetEnter Data by RangeConstruct Formulas for Mathematical OperationsEdit Values in a WorksheetFormat a WorksheetChapter 2: Using Functions, Creating Tables, and Managing Large Workbooks Use Flash Fill and the SUM, AVERAGE, MEDIAN, MIN, and MAX FunctionsMove Data, Resolve Error Messages, and Rotate TextUse COUNTIF and IF Functions and Apply Conditional FormattingUse Date & Time Functions and Freeze PanesCreate, Sort, and Filter an Excel TableView, Format, and Print a Large WorksheetNavigate a Workbook and Rename WorksheetsEnter Dates, Clear Contents, and Clear FormatsCopy and Paste by Using the Paste Options GalleryEdit and Format Multiple Worksheets at the Same TimeCreate a Summary Sheet with Column SparklinesFormat and Print Multiple Worksheets in a WorkbookChapter 3: Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools Chart Data with a Pie ChartFormat a Pie ChartEdit a Workbook and Update a ChartUse Goal Seek to Perform What-If AnalysisDesign a Worksheet for What-If AnalysisAnswer What-If Questions by Changing Values in a WorksheetChart Data with a Line ChartACCESS Introduction to Microsoft Access 2019Chapter 1: Getting Started with Microsoft Access 2019 Identify Good Database DesignCreate a Table and Define Fields in a Blank Desktop DatabaseChange the Structure of Tables and Add a Second TableCreate a Query, Form, and ReportClose a Database and Close AccessUse a Template to Create a DatabaseOrganize Objects in the Navigation PaneCreate a New Table in a Database Created with a TemplateView a ReportChapter 2: Sort and Query a Database Open and Save an Existing DatabaseCreate Table RelationshipsSort Records in a TableCreate a Query in Design ViewCreate a New Query From an Existing QuerySort Query ResultsSpecify Criteria in a QuerySpecify Numeric Criteria in a QueryUse Compound Criteria in a QueryCreate a Query Based on More Than One TableUse Wildcards in a QueryCreate Calculated Fields in a QueryCalculate Statistics and Group Data in a QueryCreate a Crosstab QueryCreate a Parameter QueryChapter 3: Forms, Filters, and Reports Create and Use a Form to Add and Delete RecordsFilter RecordsCreate a Form by Using the Form WizardModify a Form in Layout View and in Design ViewCreate a Report by Using the Report Tool and Modify the Report in Layout ViewCreate a Report by Using the Report WizardModify the Design of a ReportKeep Grouped Data Together in a Printed ReportPOWERPOINT Introducing Microsoft PowerPoint 2019 Chapter 1: Getting Started with Microsoft PowerPoint Create a New PresentationEdit a Presentation in Normal ViewAdd Pictures to a PresentationPrint and View a PresentationEdit an Existing PresentationFormat a PresentationUse Slide Sorter ViewApply Slide TransitionsChapter 2: Formatting PowerPoint Presentations Format Numbered and Bulleted ListsInsert Online PicturesInsert Text Boxes and ShapesFormat ObjectsRemove Picture Backgrounds and Insert WordArtCreate and Format a SmartArt GraphicChapter 3: Enhancing a Presentation with Animation, Video, Tables, and Charts Customize Slide Backgrounds and ThemesAnimate a Slide ShowInsert a VideoCreate and Modify TablesCreate and Modify ChartsINTEGRATED PROJECTS Chapter 1: Integrating Word, Excel, Access, and PowerPoint

About our authors 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 sector and has also written and edited numerous computer application textbooks.Alicia Vargas (Word and Excel author) 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 (PowerPoint author) 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 B.S. in Secondary Science Education from Temple University and an M.A. 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 (Access author) 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 OFFICE Chapter 1: Microsoft Office Common Features and Windows 10 Features and File Management Explore Microsoft OfficeCreate a Folder for File StorageDownload and Extract Zipped Files and Enter, Edit, and Check the Spelling of Text in an Office ProgramPerform Office Commands and Apply Office FormattingFinalize an Office DocumentUse the Office Help FeaturesExplore Windows 10Prepare to Work with Folders and FilesUse File Explorer to Extract Zipped Files and to Display Locations, Folders, and FilesStart Programs and Open Data FilesCreate, Rename, and Copy Files and FoldersWORD Introducing Microsoft Word 2019 Chapter 1: Creating Documents with Microsoft Word Create a New Document and Insert TextInsert and Format GraphicsInsert and Modify Text Boxes and ShapesPreview and Print a DocumentChange Document and Paragraph LayoutCreate and Modify ListsSet and Modify Tab StopsInsert a SmartArt Graphic and an IconChapter 2: Creating Cover Letters and Using Tables to Create Resumes Create a Table for a ResumeFormat a TablePresent a Word Document OnlineCreate a Letterhead for a Cover LetterCreate a Cover Letter and Correct and Reorganize TextUse the Word Editor to Check Your DocumentsPrint an Envelope, Change Style Sets, Create a Word Template and Use Learning ToolsChapter 3: Creating Research Papers, Newsletters, and Merged Mailing Labels Create a Research PaperInsert Footnotes in a Research PaperCreate Citations and a Bibliography in a Research PaperUse Read Mode and PDF ReflowFormat a Multiple-Column NewsletterUse Special Character and Paragraph FormattingCreate Mailing Labels Using Mail MergeEXCEL Introducing Microsoft Excel 2019 Chapter 1: Creating a Worksheet and Charting Data Create, Save, and Navigate an Excel WorkbookEnter Data in a WorksheetConstruct and Copy Formulas and Use the SUM FunctionFormat Cells with Merge & Center, Cell Styles, and ThemesChart Data to Create a Column Chart and Insert SparklinesPrint a Worksheet, Display Formulas, and Close ExcelsCheck Spelling in a WorksheetEnter Data by RangeConstruct Formulas for Mathematical OperationsEdit Values in a WorksheetFormat a WorksheetChapter 2: Using Functions, Creating Tables, and Managing Large Workbooks Use Flash Fill and the SUM, AVERAGE, MEDIAN, MIN, and MAX FunctionsMove Data, Resolve Error Messages, and Rotate TextUse COUNTIF and IF Functions and Apply Conditional FormattingUse Date & Time Functions and Freeze PanesCreate, Sort, and Filter an Excel TableView, Format, and Print a Large WorksheetNavigate a Workbook and Rename WorksheetsEnter Dates, Clear Contents, and Clear FormatsCopy and Paste by Using the Paste Options GalleryEdit and Format Multiple Worksheets at the Same TimeCreate a Summary Sheet with Column SparklinesFormat and Print Multiple Worksheets in a WorkbookChapter 3: Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools Chart Data with a Pie ChartFormat a Pie ChartEdit a Workbook and Update a ChartUse Goal Seek to Perform What-If AnalysisDesign a Worksheet for What-If AnalysisAnswer What-If Questions by Changing Values in a WorksheetChart Data with a Line ChartACCESS Introduction to Microsoft Access 2019Chapter 1: Getting Started with Microsoft Access 2019 Identify Good Database DesignCreate a Table and Define Fields in a Blank Desktop DatabaseChange the Structure of Tables and Add a Second TableCreate a Query, Form, and ReportClose a Database and Close AccessUse a Template to Create a DatabaseOrganize Objects in the Navigation PaneCreate a New Table in a Database Created with a TemplateView a ReportChapter 2: Sort and Query a Database Open and Save an Existing DatabaseCreate Table RelationshipsSort Records in a TableCreate a Query in Design ViewCreate a New Query From an Existing QuerySort Query ResultsSpecify Criteria in a QuerySpecify Numeric Criteria in a QueryUse Compound Criteria in a QueryCreate a Query Based on More Than One TableUse Wildcards in a QueryCreate Calculated Fields in a QueryCalculate Statistics and Group Data in a QueryCreate a Crosstab QueryCreate a Parameter QueryChapter 3: Forms, Filters, and Reports Create and Use a Form to Add and Delete RecordsFilter RecordsCreate a Form by Using the Form WizardModify a Form in Layout View and in Design ViewCreate a Report by Using the Report Tool and Modify the Report in Layout ViewCreate a Report by Using the Report WizardModify the Design of a ReportKeep Grouped Data Together in a Printed ReportPOWERPOINT Introducing Microsoft PowerPoint 2019 Chapter 1: Getting Started with Microsoft PowerPoint Create a New PresentationEdit a Presentation in Normal ViewAdd Pictures to a PresentationPrint and View a PresentationEdit an Existing PresentationFormat a PresentationUse Slide Sorter ViewApply Slide TransitionsChapter 2: Formatting PowerPoint Presentations Format Numbered and Bulleted ListsInsert Online PicturesInsert Text Boxes and ShapesFormat ObjectsRemove Picture Backgrounds and Insert WordArtCreate and Format a SmartArt GraphicChapter 3: Enhancing a Presentation with Animation, Video, Tables, and Charts Customize Slide Backgrounds and ThemesAnimate a Slide ShowInsert a VideoCreate and Modify TablesCreate and Modify ChartsINTEGRATED PROJECTS Chapter 1: Integrating Word, Excel, Access, and PowerPoint

About our authors 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 sector and has also written and edited numerous computer application textbooks.Alicia Vargas (Word and Excel author) 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 (PowerPoint author) 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 B.S. in Secondary Science Education from Temple University and an M.A. 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 (Access author) 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 OFFICE Chapter 1: Microsoft Office Common Features and Windows 10 Features and File Management Explore Microsoft OfficeCreate a Folder for File StorageDownload and Extract Zipped Files and Enter, Edit, and Check the Spelling of Text in an Office ProgramPerform Office Commands and Apply Office FormattingFinalize an Office DocumentUse the Office Help FeaturesExplore Windows 10Prepare to Work with Folders and FilesUse File Explorer to Extract Zipped Files and to Display Locations, Folders, and FilesStart Programs and Open Data FilesCreate, Rename, and Copy Files and FoldersWORD Introducing Microsoft Word 2019 Chapter 1: Creating Documents with Microsoft Word Create a New Document and Insert TextInsert and Format GraphicsInsert and Modify Text Boxes and ShapesPreview and Print a DocumentChange Document and Paragraph LayoutCreate and Modify ListsSet and Modify Tab StopsInsert a SmartArt Graphic and an IconChapter 2: Creating Cover Letters and Using Tables to Create Resumes Create a Table for a ResumeFormat a TablePresent a Word Document OnlineCreate a Letterhead for a Cover LetterCreate a Cover Letter and Correct and Reorganize TextUse the Word Editor to Check Your DocumentsPrint an Envelope, Change Style Sets, Create a Word Template and Use Learning ToolsChapter 3: Creating Research Papers, Newsletters, and Merged Mailing Labels Create a Research PaperInsert Footnotes in a Research PaperCreate Citations and a Bibliography in a Research PaperUse Read Mode and PDF ReflowFormat a Multiple-Column NewsletterUse Special Character and Paragraph FormattingCreate Mailing Labels Using Mail MergeEXCEL Introducing Microsoft Excel 2019 Chapter 1: Creating a Worksheet and Charting Data Create, Save, and Navigate an Excel WorkbookEnter Data in a WorksheetConstruct and Copy Formulas and Use the SUM FunctionFormat Cells with Merge & Center, Cell Styles, and ThemesChart Data to Create a Column Chart and Insert SparklinesPrint a Worksheet, Display Formulas, and Close ExcelsCheck Spelling in a WorksheetEnter Data by RangeConstruct Formulas for Mathematical OperationsEdit Values in a WorksheetFormat a WorksheetChapter 2: Using Functions, Creating Tables, and Managing Large Workbooks Use Flash Fill and the SUM, AVERAGE, MEDIAN, MIN, and MAX FunctionsMove Data, Resolve Error Messages, and Rotate TextUse COUNTIF and IF Functions and Apply Conditional FormattingUse Date & Time Functions and Freeze PanesCreate, Sort, and Filter an Excel TableView, Format, and Print a Large WorksheetNavigate a Workbook and Rename WorksheetsEnter Dates, Clear Contents, and Clear FormatsCopy and Paste by Using the Paste Options GalleryEdit and Format Multiple Worksheets at the Same TimeCreate a Summary Sheet with Column SparklinesFormat and Print Multiple Worksheets in a WorkbookChapter 3: Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools Chart Data with a Pie ChartFormat a Pie ChartEdit a Workbook and Update a ChartUse Goal Seek to Perform What-If AnalysisDesign a Worksheet for What-If AnalysisAnswer What-If Questions by Changing Values in a WorksheetChart Data with a Line ChartACCESS Introduction to Microsoft Access 2019Chapter 1: Getting Started with Microsoft Access 2019 Identify Good Database DesignCreate a Table and Define Fields in a Blank Desktop DatabaseChange the Structure of Tables and Add a Second TableCreate a Query, Form, and ReportClose a Database and Close AccessUse a Template to Create a DatabaseOrganize Objects in the Navigation PaneCreate a New Table in a Database Created with a TemplateView a ReportChapter 2: Sort and Query a Database Open and Save an Existing DatabaseCreate Table RelationshipsSort Records in a TableCreate a Query in Design ViewCreate a New Query From an Existing QuerySort Query ResultsSpecify Criteria in a QuerySpecify Numeric Criteria in a QueryUse Compound Criteria in a QueryCreate a Query Based on More Than One TableUse Wildcards in a QueryCreate Calculated Fields in a QueryCalculate Statistics and Group Data in a QueryCreate a Crosstab QueryCreate a Parameter QueryChapter 3: Forms, Filters, and Reports Create and Use a Form to Add and Delete RecordsFilter RecordsCreate a Form by Using the Form WizardModify a Form in Layout View and in Design ViewCreate a Report by Using the Report Tool and Modify the Report in Layout ViewCreate a Report by Using the Report WizardModify the Design of a ReportKeep Grouped Data Together in a Printed ReportPOWERPOINT Introducing Microsoft PowerPoint 2019 Chapter 1: Getting Started with Microsoft PowerPoint Create a New PresentationEdit a Presentation in Normal ViewAdd Pictures to a PresentationPrint and View a PresentationEdit an Existing PresentationFormat a PresentationUse Slide Sorter ViewApply Slide TransitionsChapter 2: Formatting PowerPoint Presentations Format Numbered and Bulleted ListsInsert Online PicturesInsert Text Boxes and ShapesFormat ObjectsRemove Picture Backgrounds and Insert WordArtCreate and Format a SmartArt GraphicChapter 3: Enhancing a Presentation with Animation, Video, Tables, and Charts Customize Slide Backgrounds and ThemesAnimate a Slide ShowInsert a VideoCreate and Modify TablesCreate and Modify ChartsINTEGRATED PROJECTS Chapter 1: Integrating Word, Excel, Access, and PowerPoint