I'm a studentI'm an educator

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

Published by Pearson (September 18, 2020) © 2020

  • Amy S. Kinser Indiana University
  • Kristyn Jacobson
  • Eric Kinser Indiana University
  • Brant Moriarity
  • Jennifer Paige Nightingale
Products list
per month
-month term, pay monthly or pay
Buy nowOpens in a new tab
Instant access

eTextbook features

  • Instant access to eTextbook
  • Search, highlight, and notes
  • Create flashcards
Products list
$149.32

Price Reduced From: $186.65

Details

  • A print text
Products list
$119.99
Buy accessOpens in a new tab
14 day temporary access available

Access details

  • Pearson+ eTextbook with study tools
  • Instant access once purchased
  • Register with a Course ID, a link from your instructor or an LMS link (Blackboardâ„¢, Canvasâ„¢, Moodle or D2L®)

Features

  • Interactive digital learning experience
  • Help when and where you need it
  • Instant feedback on assignments
  • Apps and study tools

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.

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

Need help? Get in touch