New Perspectives Microsoft 365 Excel Comprehensive, First Edition

A Comprehensive Course in Microsoft 365 Excel

New Perspectives Microsoft 365 Excel Comprehensive, First Edition gives instructors and independent learners a structured, module-by-module path through Excel. Patrick Carey’s text begins with the workbook essentials and steadily builds toward the advanced analytical tools used in business, finance, and data-heavy roles. It is designed as a full-course resource, not a quick-reference skim, with each module pairing visual overviews and step-by-step work with practice assignments and case problems.

What the Comprehensive Edition Covers 📊

The twelve Excel modules in this first edition move through a broad skill sequence:

• Getting started with Excel workbooks, navigation, cell entry, and worksheet organization
• Formatting workbooks, numbers, themes, cell styles, and print layouts
• Calculating with formulas and functions, including cell references, dynamic arrays, and logical operations
• Analyzing and charting financial data with pie, column, line, scatter, combination, and other chart types
• Generating reports from multiple worksheets and workbooks using 3-D references, external links, and templates
• Managing data with Excel data tools, filters, tables, subtotals, slicers, and dashboards
• Summarizing data with PivotTables, PivotCharts, and timeline slicers
• Performing what-if analyses with data tables, scenarios, Goal Seek, and Solver
• Exploring financial tools and functions, including loan, investment, depreciation, NPV, IRR, and auditing tools
• Analyzing data with business intelligence tools
• Exploring PivotTable design and data
• Developing an Excel application

From Guided Practice to Independent Problem Solving 💡

The New Perspectives approach is built around doing. Review assignments reinforce core techniques, while Apply and Challenge case problems ask learners to carry those skills into less scripted scenarios. SAM Projects and Textbook Projects provide additional structured practice. That progression helps readers move from following steps to making their own spreadsheet decisions—a useful shift for anyone preparing for coursework, certification-style study, or workplace Excel tasks.

Who This Edition Is For

This comprehensive first edition is aimed at college and university courses, instructor-led training, and self-directed learners who want broad Microsoft 365 Excel coverage in one volume. Because the material spans introductory workbook skills through advanced financial, PivotTable, what-if, and application-development topics, it can serve a multi-term sequence or a single intensive course. A basic familiarity with Windows and file management is helpful, but the early modules establish the Excel foundations.

A Note About the Electronic Edition

As an electronic version of the print textbook, this edition may have some third-party content suppressed due to electronic rights restrictions, and media content referenced in the print product may not be available. The core instructional text and Excel module content remain the focus of the ebook.

Current Excel Skills, Built Around Microsoft 365

Microsoft 365 Excel changes faster than most textbooks can track, which makes edition and software coverage important. This first edition is written for the Microsoft 365 environment and notes that Mac users may see some steps vary, with additional Mac information included in the Data files. For courses and training programs using Microsoft 365, it offers a current, comprehensive foundation in spreadsheet work, data analysis, and Excel-based decision-making.