Your Office: Microsoft Office 365, Excel 2019 Comprehensive

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

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

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

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: Information Technology

Category: Microsoft Office Applications

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
3. Cell References, Named Ranges, and Functions
4. Effective Charts
Excel Business Unit 2 Capstone

EXCEL BUSINESS UNIT 3: INTEGRATING COMPLEX FUNCTIONS INTO BUSINESS ANALYSIS
5. Complex Logical and Retrieval Functions
6. Integrating Complex Functions into Business Analysis
Excel Business Unit 3 Capstone

EXCEL BUSINESS UNIT 4: BUILD AN APPLICATION WITH MULTIPLE WORKSHEETS AND WORKBOOKS
7. Multiple Worksheets, Workbooks, and Templates
8. Building an Application with Multiple Worksheets and Workbooks
Excel Business Unit 4 Capstone

EXCEL BUSINESS UNIT 5: MANIPULATING DATA SETS FOR DECISION MAKING
9. Organize, Import, Export, and Cleanse Data Sets
10. Data Tables, Scenario Manager, and Solver
Excel Business Unit 5 Capstone

EXCEL BUSINESS UNIT 6: BUILDING FINANCIAL AND STATISTICAL MODELS
11. Loan Amortization, Investment Analysis, and Asset Depreciation
12. Business Statistics and Regression Analysis
Excel Business Unit 6 Capstone

EXCEL BUSINESS UNIT 7
13. The Excel Data Model and Business Intelligence
14. Visual Basic for Applications--VBA
Excel Business Unit 7 Capstone

Appendices
A. Leveraging Microsoft's Power Business Intelligence (‘BI') Desktop Suite
B. Mac Appendix
C. MOS Core
D. MOS Expert

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.