GO! with Microsoft Office 365, Excel 2019 Comprehensive

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.

• 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 FoldersEXCEL 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 ChartChapter 4: Creating PivotTables and PivotCharts Create a PivotTable ReportUse Slicers and Search FiltersModify a PivotTableCreate a PivotChartCreate a PivotTable from a Data ModelCreate and Format a 3-D Pie PivotChartChapter 5: Managing Large Workbooks and Using Advanced Sorting and Filtering Navigate and Manage Large WorksheetsEnhance Worksheets with Themes and StylesFormat a Worksheet to Share with OthersSave Excel Data in Other File FormatsUse Advanced Sort TechniquesUse Custom and Advanced FiltersSubtotal, Outline, and Group a List of DataChapter 6: Creating Charts, Diagrams, and Templates Create and Format Sparklines and a Column ChartCreate and Format a Line ChartCreate and Modify a SmartArt GraphicCreate and Modify a Funnel ChartCreate an Excel TemplateProtect a WorksheetCreate a Worksheet Based on a TemplateChapter 7: Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets Use Financial FunctionsUse Goal SeekCreate a Data TableUse Defined Names in a FormulaUse Lookup FunctionsValidate DataAudit Worksheet FormulasUse the Watch Window to Monitor Cell ValuesUse the INDEX and MATCH FunctionsChapter 8: Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas Calculate a Moving AverageProject Income and ExpensesDetermine a Break-Even PointUse SolverCreate ScenariosUse Logical FunctionsCreate Complex FormulasChapter 9: Using Macros and Visual Basic for Applications Record a MacroAssign a Macro to a Button on the Quick Access ToolbarModify a MacroWrite a VBA Procedure to Use an ActiveX ControlRestore Initial SettingsChapter 10: External Data, Database Functions, and Side-by-Side Tables, and Workbook Distribution and Collaboration Get External Data into ExcelClean Up and Manage Imported DataUse Database FunctionsInsert a Second Table into a WorksheetApply Conditional Formatting to Side-by-Side TablesCreate Custom Headers and FootersInspect a WorkbookUse Co-Authoring and Prepare a Final Workbook for Distribution