Your Office: Microsoft Office 365, Excel 2019 Comprehensive eBook

Amy S. Kinser all

Your Office: Microsoft Office 365, Excel 2019 Comprehensive eBook

By Amy S. Kinser, Kristyn Jacobson, Eric Kinser, Brant Moriarity, Jennifer Paige Nightingale
In stock
Add to cart
Amy S. Kinser all
Published Date
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.

The full text downloaded to your computer

With eBooks you can:

  • search for key concepts, words and phrases
  • make highlights and notes as you study
  • share your notes with friends

eBooks are downloaded to your computer and accessible either offline through the Bookshelf (available as a free download), available online and also via the iPad and Android apps.

Upon purchase, you'll gain instant access to this eBook.

Time limit

The eBooks products do not have an expiry date. You will continue to access your digital ebook products whilst you have your Bookshelf installed.

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