My Account
Log in Registration
All
Cart
Highlights
Fiction Books
Non-Fiction Books
Children's Books
Rare Books
Music
DVD & Blu-Ray
Video Games
Category
Wishlists
Cart
All
Free US shipping over $10
Trustpilot
Proud to be B-Corp

GO! with Microsoft Office 365, Excel 2019 Comprehensive Shelley Gaskin

GO! with Microsoft Office 365, Excel 2019 Comprehensive By Shelley Gaskin

GO! with Microsoft Office 365, Excel 2019 Comprehensive by Shelley Gaskin

Reviews:
$150.61
Condition - Very Good
Only 2 left
Very Good

Faster Shipping

Get this product faster from our US warehouse

GO! with Microsoft Office 365, Excel 2019 Comprehensive Summary

GO! with Microsoft Office 365, Excel 2019 Comprehensive by Shelley Gaskin

Now live! SUMMER 2020 DIGITAL UPDATE for digital content
Microsoft Office 365 updates are reflected in the eText and associated MyLab for this title. Instructors, to learn more, contact your Pearson representative.

For introductory courses in Microsoft (R) Excel (TM).

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 (R) Office 365 (R), Excel 2019 Comprehensive adds tips for Mac users, revised instructional projects, and improved coverage of the what, why, and how of skills application.

Also available with MyLab IT
By combining trusted author content with digital tools and a flexible platform, MyLab personalizes the learning experience and improves results for each student. MyLab IT 2019 delivers trusted content and resources through an expansive course materials library, including new easy-to-use Prebuilt Learning Modules that promote student success. Through an authentic learning experience, students become sharp critical thinkers and proficient in Microsoft Office, developing essential skills employers seek.

Note: You are purchasing a standalone product; MyLab IT does not come packaged with this content. Students, if interested in purchasing this title with MyLab IT, ask your instructor to confirm the correct package ISBN and Course ID. Instructors, contact your Pearson representative for more information.

If you would like to purchase both the physical text and MyLab IT, search for:

0135768950 / 9780135768952 GO! with Microsoft Excel 2019 Comprehensive, 1/e + MyLab IT w/ Pearson eText, 1/e
Package consists of:

  • 0135442680 / 9780135442685 GO! with Microsoft Office 365, Excel 2019 Comprehensive, 1/e
  • 0135651263 / 9780135651261 MyLab IT with Pearson eText -- Access Card -- for GO! with Microsoft Office 365, 2019 Edition Introductory, 1/e

About Shelley Gaskin

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.

Table of Contents

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

Additional information

CIN0135442680VG
9780135442685
0135442680
GO! with Microsoft Office 365, Excel 2019 Comprehensive by Shelley Gaskin
Shelley Gaskin
Used - Very Good
Paperback
Pearson Education (US)
20190311
784
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in very good condition, but if you are not entirely satisfied please get in touch with us

Customer Reviews - GO! with Microsoft Office 365, Excel 2019 Comprehensive