Pearson+

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

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

  • Study simpler and faster
    Study simpler and faster

    Use flashcards and other study tools in your eTextbook

  • Watch and learn
    Watch and learn

    Videos & animations bring concepts to life

  • Listen on the go
    Listen on the go

    Learn how you like with full eTextbook audio

  • Find it fast
    Find it fast

    Quickly navigate your eTextbook with search

  • Stay organized
    Stay organized

    Access all your eTextbooks in one place

Your Office: Microsoft Office 365, Excel 2019 Comprehensive prepares you to apply technical and soft skills in real business settings. Hands-on technical content and realistic cases will teach you to use Microsoft Excel as a decision-making tool for business areas such as finance and accounting, production and operations, and sales and marketing. Chapters are grouped by business units to align the text with AACSB requirements.

The 2019 Edition has been updated for Office 365 and offers visual features designed to help you navigate the text more efficiently. This edition covers 2019 MOS objectives and includes a MOS Certification Guide so those who seek certification can quickly locate the MOS objectives covered in each chapter. A Mac Appendix and Mac Troubleshooting guide have been added to provide a more seamless learning experience for Mac users.

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

ISBN-13: 9780136874867

Subject: Computer Concepts

Category:

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