GO! Microsoft 365: Excel 2019, 1st edition

  • Shelley Gaskin, 
  • Alicia Vargas, 
  • Debra Geoghan, 
  • Nancy Graviett

Your access includes:

  • Search, highlight, notes, and more
  • Easily create flashcards
  • Use the app for access anywhere
  • 14-day refund guarantee

$10.99per month

Minimum 4-month term, pay monthly or pay $43.96 upfront

Learn more, spend less

  • Study simpler and faster

    Use flashcards and other study tools in your eTextbook

  • Watch and learn

    Videos & animations bring concepts to life

  • Listen on the go

    Learn how you like with full eTextbook audio

  • Find it fast

    Quickly navigate your eTextbook with search

  • Stay organized

    Access all your eTextbooks in one place

Overview

A trusted source for over 20 years, the GO!  series will help you master Microsoft 365. You'll gain workplace skills by completing instructional projects that offer a learn-by-doing approach. With the additional outcomes-based and critical thinking projects provided, you'll practice using Office 365 apps to solve real-world business problems. The text's easy-to-follow instructions will keep you on track, and author Shelley Gaskin will guide you with tips and instruction, right when they're needed most.

Updated to Office 365, GO! with Microsoft® Office 365®, Excel 2019, Comprehensive adds tips for Mac users, revised instructional projects and improved coverage to help you grasp the what, why, and how of skills application. The text is compatible with Access 2019.

Published by Pearson (September 18th 2020) - Copyright © 2020

ISBN-13: 9780136874607

Subject: Microsoft Office Applications

Category: GO! with Microsoft Office 365, Excel 2019 Comprehensive

Overview

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

Your questions answered

Pearson+ is your 1-stop shop with eTextbooks, study tools and exam prep features designed to help students get better grades in college. eTextbooks come with built-in tools that simplify studying, like flashcards, audiobook and search. Pearson+ also features Channels, which includes practice problems, study guides, Q&A with experts, video lessons that help you understand tricky topics and more—all in one place. Channels can be purchased separately or added on to your eTextbook at the time of purchase as part of the Study & Exam Prep Pack.

A Pearson eTextbook is an easy-to-use digital version of your book for class that includes upgraded study tools to help you learn how you learn best. Use enhanced search to find what you need within your eTextbook, highlight and make notes to mark important info, generate flashcards to test your knowledge, and use audio to listen to the text. Every feature is designed to help you learn more efficiently and get results. Plus, you can learn on the go with the Pearson+ app. Find this and more in your eTextbook, available in Pearson+.

The Study & Exam Prep Pack includes practice problems, study guides, Q&A with experts, Channels video lessons that help you understand tricky topics and more. It can be added on to your eTextbook or your MyLab and Mastering learning platform at the time of purchase.

Your eTextbook subscription gives you access for 4 months. You can make a one‑time payment for the initial 4‑month term or pay monthly. If you opt for monthly payments, we will charge your payment method each month until your 4‑month term ends. You can turn on auto‑renew in My account at any time to continue your subscription before your 4‑month term ends.

When you purchase an eTextbook subscription, it will last 4 months. You can renew your subscription by selecting Extend subscription on the Manage subscription page in My account before your initial term ends.

If you extend your subscription, we'll automatically charge you every month. If you made a one‑time payment for your initial 4‑month term, you'll now pay monthly. To make sure your learning is uninterrupted, please check your card details.

To avoid the next payment charge, select Cancel subscription on the Manage subscription page in My account before the renewal date. You can subscribe again in the future by purchasing another eTextbook subscription.

Channels is a video platform with thousands of explanations, solutions and practice problems to help you do homework and prep for exams. Videos are personalized to your course, and tutors walk you through solutions. Plus, interactive AI‑powered summaries and a social community help you better understand lessons from class.

Channels is an additional tool to help you with your studies. This means you can use Channels even if your course uses a non‑Pearson textbook.

When you choose a Channels subscription, you're signing up for a 1‑month, 3‑month or 12‑month term and you make an upfront payment for your subscription. By default, these subscriptions auto‑renew at the frequency you select during checkout.

When you purchase a Channels subscription it will last 1 month, 3 months or 12 months, depending on the plan you chose. Your subscription will automatically renew at the end of your term unless you cancel it.

We use your credit card to renew your subscription automatically. To make sure your learning is uninterrupted, please check your card details.