Secure Checkout

Your Office: Microsoft Office 365, Excel 2019 Comprehensive, 1st edition

  • Amy S. Kinser, 
  • Kristyn Jacobson, 
  • Eric Kinser, 
  • Brant Moriarity, 
  • Jennifer Paige Nightingale

Choose the option that's right for you

$9.99 / mo

4-month term, pay monthly or pay $39.96

Enjoy these features

  • Up to 2 devices
  • Exclusive offers

$14.99 / mo

4-month term, pay monthly or pay $59.96

Enjoy these features

  • Up to 2 devices
  • Exclusive offers

Looking for your MyLab or Mastering eTextbook? Find it hereOpens in an new tab

Learn more, spend less

  • Study smarter, not harder

    Save time with 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

  • Learn anytime, anywhere

    Get the app to access your eTextbook whenever you need it

  • Make it your own

    Your notes. Your highlights. Your eTextbook

Overview

Your Office: Microsoft® Office 365®, Excel™ 2019 Comprehensive combines technical content with business cases to help you use Excel as a decision-making tool at work.

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

ISBN-13: 9780136874867

Subject: Microsoft Office Applications

Category: Your Office: Microsoft Office 365, Excel 2019 Comprehensive

Table of contents

Table of Contents

COMMON FEATURES

  1. Understanding the Common Features of Microsoft Office

EXCEL

EXCEL BUSINESS UNIT 1: UNDERSTANDING THE FUNDAMENTALS

  1. Create, Navigate, Work with, and Print Worksheets
  2. Formats, Functions, and Formulas
    • Excel Business Unit 1 Capstone

EXCEL BUSINESS UNIT 2: CONDUCTING BUSINESS ANALYSIS

  1. Cell References, Named Ranges, and Functions
  2. Effective Charts
    • Excel Business Unit 2 Capstone

EXCEL BUSINESS UNIT 3: INTEGRATING COMPLEX FUNCTIONS INTO BUSINESS ANALYSIS

  1. Complex Logical and Retrieval Functions
  2. Integrating Complex Functions into Business Analysis
    • Excel Business Unit 3 Capstone

EXCEL BUSINESS UNIT 4: BUILD AN APPLICATION WITH MULTIPLE WORKSHEETS AND WORKBOOKS

  1. Multiple Worksheets, Workbooks, and Templates
  2. Building an Application with Multiple Worksheets and Workbooks
    • Excel Business Unit 4 Capstone

EXCEL BUSINESS UNIT 5: MANIPULATING DATA SETS FOR DECISION MAKING

  1. Organize, Import, Export, and Cleanse Data Sets
  2. Data Tables, Scenario Manager, and Solver
    • Excel Business Unit 5 Capstone

EXCEL BUSINESS UNIT 6: BUILDING FINANCIAL AND STATISTICAL MODELS

  1. Loan Amortization, Investment Analysis, and Asset Depreciation
  2. Business Statistics and Regression Analysis
    • Excel Business Unit 6 Capstone

EXCEL BUSINESS UNIT 7

  1. The Excel Data Model and Business Intelligence
  2. Visual Basic for Applications--VBA
    • Excel Business Unit 7 Capstone

Appendices

  1. Leveraging Microsoft’s Power Business Intelligence (‘BI’) Desktop Suite
  2. Mac Appendix
  3. MOS Core
  4. MOS Expert

Your questions answered

Choose from one eTextbook or over 1,500 eTextbooks and study tools, all in one place, for one low monthly subscription. A Single plan includes the use of 1 eTextbook title and study tools. A Multi plan gives you access to more than 1,500 eTextbook titles and study tools. Plus, with the app, put textbooks in your pocket and learn wherever.

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.

A Pearson eTextbook is an easy-to-use digital version of the book. You can add notes and highlights, plus learn on the go with the Pearson+ mobile app. Listen on the go with the audiobook feature, available for most titles.

When you choose a plan, you're signing up for a 4-month 'term'. You can opt to 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 has ended. You can turn on auto-renew in My account at any time to continue your subscription before your 4-month term has ended.

When you purchase a Pearson+ subscription, it will last 4 months. Before your initial 4-month term ends, you can extend your subscription by turning auto-renew on in My account.

If you turn auto-renew on, we’ll automatically renew your subscription and charge you every month until you turn off auto-renew. If you made a one-time payment for your initial 4-month term, you’ll now pay monthly.

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 10 titles from your library on each of your authorized smartphone and tablet 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.