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

Your Office: Microsoft Office 365, Excel 2019 Comprehensive

Kinser,A et al
Published by
Pearson Higher Ed USA
Available on demand
Title type
Title type
For courses covering Microsoft® Excel™. Ideal for business courses.

Real-world problem-solving for business and beyond

Your Office: Microsoft Office 365, Excel 2019 Comprehensive prepares students to apply both technical and soft skills in real business settings. Hands-­on technical content together with realistic business cases help students 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. Updated for Office 365, the 2019 edition includes 2019 MOS objectives, new resources for Mac users, and improved links between cases within the text and MyLab IT Grader projects.
Table of contents
  • 1. Create, Navigate, Work with, and Print Worksheets
  • 2. Formats, Functions, and Formulas
  • 3. Cell References, Named Ranges, and Functions
  • 4. Effective Charts
  • 5. Complex Logical and Retrieval Functions
  • 6. Integrating Complex Functions into Business Analysis
  • 7. Multiple Worksheets, Workbooks, and Templates
  • 8. Building an Application with Multiple Worksheets and Workbooks
  • 9. Organize, Import, Export, and Cleanse Data Sets
  • 10. Data Tables, Scenario Manager, and Solver
  • 11. Loan Amortization, Investment Analysis, and Asset Depreciation
  • 12. Business Statistics and Regression Analysis
  • 13. The Excel Data Model and Business Intelligence
  • 14. Visual Basic for Applications—VBA
Features & benefits
  • A recurring Global Business Scenario (Prepare Case) appears in each chapter, along with blue boxes walking students through the steps needed to complete each case. MyLab IT includes supplementary videos.
  • A Practice, Problem Solve, and Perform Case at the end of each chapter and in Business Capstones at the end of each business unit require students to synthesise the information they’ve just read.
  • Consider This critical-thinking questions and discussion topics ask learners to analyse the skills they’re applying to Prepare Cases and to consider how those skills can be useful later on.
  • For this edition, the authors have improved the one-to-one link between cases within the text and MyLab IT Grader projects, adding a Grader Heads Up feature highlighting differences between the two.
  • Real World Success feature in chapter-openers shares anecdotes from former students describing how their Office skills have helped them get ahead in their careers.
  • Real World Advice box offers best practices for applying key Office skills, simulating the way a manager might advise students in a future job. Icons placing content in context include Business Application icons signifying the business areas represented in cases and Soft Skills icons identifying content addressing the soft skills employers look for, such as critical thinking.
  • Content updates for Office 365 (Excel) include a new Appendix that covers the desktop Power BI suite, expanded coverage of Get & Transform, guidance on new functions such as IFS, FORECAST.ETS, TEXTJOIN, CONCAT, and SWITCH, and detailed information on the updated ribbon and new chart types.
  • A Mac Appendix provides a quick reference to information Mac students need to use Office effectively.
  • A Mac Troubleshooting feature helps Mac users overcome obstacles while working in Office applications.
  • The MOS Certification Guide now reflects 2019 MOS objectives. A MOS Objective Appendix shows where each objective is covered in the text to help students prepare for the MOS exam.
  • Chapter review includes a visual summary of chapter learning objectives and Concept Check questions at the end of each chapter gauging students’ grasp of those objectives.
  • A more accessible design helps learners use the text more efficiently and effectively.
Student supplements