Overview

Seamless digital instruction, practice, and assessment For over 17 years, instructors have relied upon the GO! series to teach Microsoft Office successfully. The series uses a project-­based approach that clusters learning objectives around projects, rather than software features, so students can practice solving real business problems. Gaskin uses easy-to-follow Microsoft Procedural Syntax so students always know where to go on the ribbon; she combines this with a Teachable Moment approach that offers learners tips and instructions at the precise moment they're needed. Updated to Office 365, GO! with Microsoft Office 365, Excel 2019 Comprehensive adds tips for Mac users, revised instructional projects, and improved coverage of the what, why, and how of skills application.

Full Product Details

Author:   Shelley Gaskin ,  Alicia Vargas ,  Debra Geoghan ,  Nancy Graviett
Publisher:   Pearson Education (US)
Imprint:   Pearson
Dimensions:   Width: 20.00cm , Height: 2.80cm , Length: 27.60cm
Weight:   1.400kg
ISBN:  

9780135442685

ISBN 10:   0135442680
Pages:   784
Publication Date:   18 March 2019
Audience:   College/higher education ,  Professional and scholarly ,  Tertiary & Higher Education ,  Professional & Vocational
Replaced By:   9780137602292
Format:   Paperback
Publisher's Status:   Active
Availability:   In Print  
This item will be ordered in for you from one of our suppliers. Upon receipt, we will promptly dispatch it out to you. For in store availability, please contact us.

Table of Contents

Table of Contents MICROSOFT OFFICE Chapter 1: Microsoft Office Common Features and Windows 10 Features and File Management Explore Microsoft Office Create a Folder for File Storage Download and Extract Zipped Files and Enter, Edit, and Check the Spelling of Text in an Office Program Perform Office Commands and Apply Office Formatting Finalize an Office Document Use the Office Help Features Explore Windows 10 Prepare to Work with Folders and Files Use File Explorer to Extract Zipped Files and to Display Locations, Folders, and Files Start Programs and Open Data Files Create, Rename, and Copy Files and Folders EXCEL Introducing Microsoft Excel 2019 Chapter 1: Creating a Worksheet and Charting Data Create, Save, and Navigate an Excel Workbook Enter Data in a Worksheet Construct and Copy Formulas and Use the SUM Function Format Cells with Merge & Center, Cell Styles, and Themes Chart Data to Create a Column Chart and Insert Sparklines Print a Worksheet, Display Formulas, and Close Excels Check Spelling in a Worksheet Enter Data by Range Construct Formulas for Mathematical Operations Edit Values in a Worksheet Format a Worksheet Chapter 2: Using Functions, Creating Tables, and Managing Large Workbooks Use Flash Fill and the SUM, AVERAGE, MEDIAN, MIN, and MAX Functions Move Data, Resolve Error Messages, and Rotate Text Use COUNTIF and IF Functions and Apply Conditional Formatting Use Date & Time Functions and Freeze Panes Create, Sort, and Filter an Excel Table View, Format, and Print a Large Worksheet Navigate a Workbook and Rename Worksheets Enter Dates, Clear Contents, and Clear Formats Copy and Paste by Using the Paste Options Gallery Edit and Format Multiple Worksheets at the Same Time Create a Summary Sheet with Column Sparklines Format and Print Multiple Worksheets in a Workbook Chapter 3: Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools Chart Data with a Pie Chart Format a Pie Chart Edit a Workbook and Update a Chart Use Goal Seek to Perform What-If Analysis Design a Worksheet for What-If Analysis Answer What-If Questions by Changing Values in a Worksheet Chart Data with a Line Chart Chapter 4: Creating PivotTables and PivotCharts Create a PivotTable Report Use Slicers and Search Filters Modify a PivotTable Create a PivotChart Create a PivotTable from a Data Model Create and Format a 3-D Pie PivotChart Chapter 5: Managing Large Workbooks and Using Advanced Sorting and Filtering Navigate and Manage Large Worksheets Enhance Worksheets with Themes and Styles Format a Worksheet to Share with Others Save Excel Data in Other File Formats Use Advanced Sort Techniques Use Custom and Advanced Filters Subtotal, Outline, and Group a List of Data Chapter 6: Creating Charts, Diagrams, and Templates Create and Format Sparklines and a Column Chart Create and Format a Line Chart Create and Modify a SmartArt Graphic Create and Modify a Funnel Chart Create an Excel Template Protect a Worksheet Create a Worksheet Based on a Template Chapter 7: Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets Use Financial Functions Use Goal Seek Create a Data Table Use Defined Names in a Formula Use Lookup Functions Validate Data Audit Worksheet Formulas Use the Watch Window to Monitor Cell Values Use the INDEX and MATCH Functions Chapter 8: Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas Calculate a Moving Average Project Income and Expenses Determine a Break-Even Point Use Solver Create Scenarios Use Logical Functions Create Complex Formulas Chapter 9: Using Macros and Visual Basic for Applications Record a Macro Assign a Macro to a Button on the Quick Access Toolbar Modify a Macro Write a VBA Procedure to Use an ActiveX Control Restore Initial Settings Chapter 10: External Data, Database Functions, and Side-by-Side Tables, and Workbook Distribution and Collaboration Get External Data into Excel Clean Up and Manage Imported Data Use Database Functions Insert a Second Table into a Worksheet Apply Conditional Formatting to Side-by-Side Tables Create Custom Headers and Footers Inspect a Workbook Use Co-Authoring and Prepare a Final Workbook for Distribution

Reviews

Author Information

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.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions