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

Single

$9.99 / mo

4-month minimum term for $39.96

  • Access this eTextbook title
  • Up to 2 devices
  • Discounted tutor access
  • Exclusive offers

Multi

$14.99 / mo

4-month minimum term for $59.96

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

Learn more, spend less

  • Learn anytime, anywhere

    Get the app to access your eTextbook whenever you need it

  • Make it your own

    Your notes. Your highlights. Your eTextbook

  • Find it fast

    Quickly navigate your eTextbook with search

  • Stay organized

    Access all your eTextbooks in one place

  • Access all your eTextbooks in one place

    Keep learning with auto-renew

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

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 eTextbook or over 1,500 eTextbooks 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 eTextbook 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. 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.

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 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.