Higher Education

New Perspectives Microsoft® 365® Excel® Comprehensive with MindTap

Author(s): Patrick Carey

ISBN: 9789366602394

1st Edition

Copyright: 2025

India Release: 2026

₹1295

Binding: Paperback

Pages: 864

Trim Size: 279 x 216 mm

Refer Book

Order Inspection Copy

Using a unique in-depth, case-based approach, Carey's NEW PERSPECTIVES MICROSOFT® 365® EXCEL® COMPREHENSIVE, thoroughly prepares you for the Microsoft Office Specialist (MOS) certification exam and success in your future career. As you apply Microsoft Office skills to real-world business scenarios based on data from market insights, you will sharpen your critical-thinking and problem-solving skills. Professional skills, tips and insights incorporated throughout provide context and relevancy to real-world practice. The text also offers updated coverage of Microsoft 365 features as well as enhanced support for Mac users. In addition, MindTap and up-to-date SAM (Skills Assessment Manager) digital resources provide interactive study tools to help maximize your study time -- and results.

  • Using an in-depth, case-based approach, the book helps students apply Microsoft Office skills to real-world business scenarios based on data from market insights while reinforcing their critical-thinking and problem-solving skills.
  • Introductory Textbook Projects are designed to ensure successful completion by Mac users for Word, Excel and PowerPoint.
  • Module Learning Objectives are mapped to the Microsoft Office Specialist (MOS) exam.
  • Students carefully examine the context for their projects, which increases the motivation to learn as students understand the “why” behind each step in the process.
  • ProSkills Boxes help students strengthen their employability skills, including written and verbal communication, problem-solving, decision-making and teamwork.
  • Trouble call-outs offer practical tips and insight to help readers avoid common errors.
  • Application of dynamic arrays and dynamic array functions such as the FILTER, SORT, SORTBY and UNIQUE functions.
  • LAMBDA and LET function for generating custom functions and function variables, along with coverage of Excel’s data types and the Analyze Data button used to spot trends and gain insight into data.

1. Getting Started with Excel
2. Formatting a Workbook
3. Calculating with Formulas and Functions
4. Analyzing and Charting Financial Data
5. Generating Reports from Multiple Worksheets and Workbooks
6. Managing Data with\the Excel Data Tools
7. Summarizing Data with PivotTables
8. Performing What-If Analyses
9. Exploring Financial Tools and Functions
10. Analyzing Data with Business Intelligence Tools
11. Exploring PivotTable Design
12. Developing an Excel Application

Patrick Carey

A leading textbook author, lecturer and instructor, Patrick Carey has authored or co-authored more than 40 popular academic and trade texts for the academic market. 

Related Books