I'm a student
I'm an educator
Request full copy

GO! Microsoft 365: Excel 2019, 1st edition

Published by Pearson (March 11, 2019) © 2020

  • Shelley Gaskin Pasadena City College
  • Alicia Vargas Pasadena City College
  • Debra Geoghan Bucks County Community College
  • Nancy Graviett St. Charles Community College

eTextbook

per month

  • Anytime, anywhere learning with the Pearson+ app
  • Easy-to-use search, navigation and notebook
  • Simpler studying with flashcards
$154.66

  • Hardcover, paperback or looseleaf edition
  • Affordable rental option for select titles
  • Free shipping on looseleafs and traditional textbooks

MyLab

from$119.99

  • Reach every student with personalized support
  • Customize courses with ease
  • Optimize learning with dynamic study tools

For advanced courses in Microsoft® Excel.

Seamless digital instruction, practice, and assessment

For over 20 years, the GO! series has helped students master Microsoft 365 with a learn-by-doing approach, teaching workplace skills through instructional projects. Outcomes-based and critical thinking projects offer practice using Office 365 apps to solve real-world business problems. Easy-to-follow steps keep students on track and instruction and tips appear precisely when needed.

Updated to Office 365, GO! with Microsoft® Office 365®, Excel 2019, Comprehensive, adds tips for Mac users, revised instructional projects, and is compatible with 2019.

Hallmark features of this title

Built for the real world

  • Chapter projects based on learning outcomes and objectives teach workplace skills in the context of real-world tasks.
  • MOS objectives noted by icons throughout help students prep for MOS certification exams.

Project-based learning

  • Skills developed in outcome-based, problem-solving,  and critical-thinking projects are applied and reinforced by end-of-chapter projects.
  • GO! Collaborate with Google® projects practice applying skills to an environment popular in the workplace.

Strategic guidance throughout

  • Confusion-free, color-coded instructions lead step-by-step through projects, with screenshots of essential steps.
  • Learning is enhanced by visuals, like Office icons and boxes that highlight key concepts and Mac Tips.

New and updated features of this title

In-step with technology as it evolves

  • REVISED: Coverage of Microsoft Office 365, 2019 Edition keeps students current with up-to-date skills.
  • NEW: A combined Office Features and Windows chapter provides a concise overview of key features, reinforcing knowledge needed to complete projects.

Training for today's workplace

  • EXPANDED: New critical thinking quizzes accompany Instructional A & B Grader Projects, requiring students to use problem-solving and analysis (soft skills employers look for) to demonstrate their understanding.
  • ENHANCED: Connections between business cases and instruction have been strengthened to reinforce the what, why, and how of skills application.
  • REVISED: All projects have been updated to provide meaningful hands-on experience.
  • NEW: Mac tips are now included within the text so that all students can learn effectively.

Features of MyLab IT GO! 2019

  • ENHANCED: With Microsoft Office  Grader projects students work live in Excel, Word, Access, or PowerPoint supported by immediate, autograded feedback. Learning aids are now included in A & B Grader project reports for instant remediation.
  • NEW: Grader projects are built for PC and Mac users (excluding Access and any project features Mac does not support).
  • REVISED: Microsoft Office Simulations align 1:1 with activities in the text. Students can walk through simulations to reinforce software navigation with the support of learning aids. They can even retrace their steps using Student Action Visualization (video) to play back and correct any missteps.
  • NEW: Office App Digital Badges verify proficiency to potential employers. Earned for completing Capstone Grader projects with a 90%+ score, badges can be displayed to strengthen student resumes on platforms like LinkedIn and elsewhere.
  • EXPANDED: Additional videos come with the collection of GO! Learn How training videos, GO! to Work videos (showing Microsoft Office uses in various jobs), GO! for Job Success videos (teaching employability skills), and Where We're Going videos (providing instructional project overviews).
  • NEW: Semester Updates within the eText, Grader projects, and other resources within MyLab IT keep you current with Office 365 updates.

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

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.

Need help? Get in touch

MyLab

Customize your course to teach your way. MyLab® is a flexible platform merging world-class content with dynamic study tools. It takes a personalized approach designed to ignite each student's unique potential. And, with the freedom it affords to adapt your pedagogy, you can reinforce select concepts and guide students to real results.

Pearson+

All in one place. Pearson+ offers instant access to eTextbooks, videos and study tools in one intuitive interface. Students choose how they learn best with enhanced search, audio and flashcards. The Pearson+ app lets them read where life takes them, no wi-fi needed. Students can access Pearson+ through a subscription or their MyLab or Mastering course.

Video
Play
Privacy and cookies
By watching, you agree Pearson can share your viewership data for marketing and analytics for one year, revocable by deleting your cookies.

Video transcript (PDF | 25KB) 

Empower your students, in class and beyond

Meet students where they are with MyLab®, and capture their attention in every lecture, activity, and assignment using immersive content, customized tools, and interactive learning experiences in your discipline.

Digital Learning NOW

Extend your professional development and meet your students where they are with free weekly Digital Learning NOW webinars. Attend live, watch on-demand, or listen at your leisure to expand your teaching strategies. Earn digital professional development badges for attending a live session.

Explore webinars