GO! with Microsoft Office 365, Excel 2019 Comprehensive

GO! with Microsoft Office 365, Excel 2019 Comprehensive, 1st edition

  • Shelley Gaskin, 
  • Alicia Vargas

Choose the option that's right for you

Single

$9.99 / mo

4-month minimum term for $39.96

  • Access this eText title
  • Up to 2 devices

Multi

$14.99 / mo

4-month minimum term for $59.96

  • Access over 1,500 titles
  • Up to 2 devices
  • Discounted tutor access

Learn more, spend less

  • Icon

    Study smarter, not harder

    Save time with study tools in your eText

  • Icon

    Watch and learn

    Videos & animations bring concepts to life

  • Icon

    Listen on the go

    Learn how you like with full eText audio

  • Icon

    Learn anytime, anywhere

    Get the app to access your eText whenever you need it

  • Icon

    Make it your own

    Your notes. Your highlights. Your eText

Overview

GO! with Microsoft® Office 365®, Excel 2019, Comprehensive uses a project-­based approach to teach the basic-to-advanced features and functions of Microsoft Excel.

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

ISBN-13: 9780136874607

Subject: Information Technology

Category: Microsoft Office Applications

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

Your questions answered

Introducing Pearson+. Reimagined learning, designed for you. Choose from one eText or over 1,500 eTexts and study tools, all in one place, for one low monthly subscription. A new way to buy books that fits your budget. Make the most of your study time with offline access, enhanced search, notes and flashcards — to get organized, get the work done quicker and get results. Plus, with the app, put textbooks in your pocket and learn wherever. It's time to upgrade the textbook and simplify learning, so you can have time to live too.

Pearson eText is an easy-to-use digital textbook available from Pearson+. Make it your own by adding notes and highlights. Download the Pearson+ mobile app to learn on the go, even offline. Listen on the go with our new audiobook feature, available for most titles.

When you choose a plan, you're signing up for a 4-month term. We will charge your payment method each month until your 4-month term has ended. After that, we'll automatically renew your subscription and charge you on a month-to-month basis unless you turn off auto-renewal in My account.

When you purchase a Pearson+ subscription, it will last a minimum of 4 months, and then automatically renew each month thereafter unless you turn off auto-renew in My account.

If you want to stop your subscription at the end of your 4-month term, simply turn off auto-renew from My account. To avoid the next payment charge, make sure you turn auto renewal off 1 day before the auto renewal date.

You can subscribe again after auto-renew has been turned off by purchasing another Pearson+ subscription.

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

With a Multi Pearson+ subscription plan, you can download up to 5 titles on the Pearson+ app from My list on each of your authorized devices every month.

When you're using your Multi Pearson+ subscription plan in a browser, you can select and read from as many titles as you like.