Now with the AI-powered study tool

GO! Microsoft 365: Excel 2021, 1st edition

Published by Pearson (April 15, 2022) © 2023

  • Shelley Gaskin Pasadena City College
  • Nancy Graviett St. Charles Community College
  • Debra Geoghan Bucks County Community College
  • Alicia Vargas Pasadena City College
per month
monthly payments or
pay undefined one-time
Buy nowOpens in a new tab
Instant access

In this eTextbook — More ways to learn

  • More flexible. Start learning right away, on any device.
  • More supportive. Get AI explanations and practice questions (select titles).
  • More interactive. Bring learning to life with audio, videos, and diagrams.
  • More memorable. Make concepts stick with highlights, search, notes, and flashcards.
  • More understandable. Translate text into 100+ languages with one tap.
due today
Buy nowOpens in a new tab

In this eTextbook — More ways to learn

  • More flexible. Start learning right away, on any device.
  • More supportive. Get AI explanations and practice questions (select titles).
  • More interactive. Bring learning to life with audio, videos, and diagrams.
  • More memorable. Make concepts stick with highlights, search, notes, and flashcards.
  • More understandable. Translate text into 100+ languages with one tap.
$59.94
monthly payments or
pay undefined one-time
Instant access

In this eTextbook — More ways to learn

  • More flexible. Start learning right away, on any device.
  • More supportive. Get AI explanations and practice questions (select titles).
  • More interactive. Bring learning to life with audio, videos, and diagrams.
  • More memorable. Make concepts stick with highlights, search, notes, and flashcards.
  • More understandable. Translate text into 100+ languages with one tap.
$59.94
monthly payments or
pay undefined one-time
Instant access

In this eTextbook — More ways to learn

  • More flexible. Start learning right away, on any device.
  • More supportive. Get AI explanations and practice questions (select titles).
  • More interactive. Bring learning to life with audio, videos, and diagrams.
  • More memorable. Make concepts stick with highlights, search, notes, and flashcards.
  • More understandable. Translate text into 100+ languages with one tap.

Title 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 Microsoft Excel 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.

The 2021 Edition has been completely updated with Microsoft 365 and Office 2021 features; includes file management instruction for both Windows and macOS; and integrates Microsoft Teams to prep you for remote collaboration.

Table of contents

Microsoft Office and Windows 10

  1. Office Features
  2. File Management
  3. Microsoft Teams

Excel

  1. Creating a Worksheet and Charting Data
  2. Using Functions, Creating Tables, and Managing Large Workbooks
  3. Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools
  4. Creating Pivot Tables and PivotCharts
  5. Managing Large Workbooks and Using Advanced Sorting and Filtering
  6. Creating Charts, Diagrams, and Templates
  7. Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets
  8. Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas
  9. Using Macros and Visual Basic for Applications
  10. External Data, Database Functions, Side-by-Side Tables, and Workbook Distribution and Collaboration

Author bios

This publication contains markup to enable structural navigation and compatibility with assistive technologies. Images in the publication are fully described. The publication supports text reflow, is screen-reader friendly, and contains no content hazards known to cause adverse physical reactions.

Need help?Get in touch