Your Office: Microsoft Office 365, Excel 2019 Comprehensive eBook : 9780135394694

Your Office: Microsoft Office 365, Excel 2019 Comprehensive eBook

Kinser,A et al
Published by
Pearson Higher Ed USA
Title type
NZ/Pacific customers only
This eText can only be purchased by people residing in New Zealand, Fiji, Samoa, Tonga or Cook Islands with a credit card from the same country. Click here to find the Pearson website for your region.

Digital Access Code: When you buy an eBook you will receive an email with your unique redemption code code. Simply go to VitalSource Bookshelf to download the FREE Bookshelf software. After installation, enter your redemption code for your eBook.

Please note: eBooks are available for download immediately and cannot be returned once purchased.

About the book: 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 VitalSource eBooks you can:

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

The eBook is downloaded to your computer and accessible either offline through the VitalSource Bookshelf, available online and also via the iPad/Android app.

Time Limit: This VitalSource eBook does not have an expiry date. You will continue to access your eBook whilst you have your VitalSource Bookshelf installed

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.
Access Code info.

To get the most out of your eBook you need to download the VitalSource Bookshelf software. This software is free to download and use. View the VitalSource Bookshelf system requirements here.

Download Information: Once purchased, you can view and/or download your eBook instantly, either via the download link which you will receive as soon as you complete your online order or by viewing the download link against the order in the My Account area of this website.

Please note: eBooks are available for download immediately and cannot be returned once purchased.