New Perspectives Microsoft® 365® Excel® Comprehensive, First Edition,
1st Edition

Modules.
1. Getting Started with Excel: Tracking Miscellaneous Expenses for a Conference.
2. Formatting Workbook Text and Data: Creating a Sales Report.
3. Performing Calculations with Formulas and Functions: Staffing a Call Center.
4. Analyzing and Charting Financial Data: Preparing an Investment Report.
5. Generating Reports from Multiple Worksheets and Workbooks: Summarizing Profit and Loss Statements.
6. Managing Data with Data Tools: Analyzing Employment Data.
7. Summarizing Data with PivotTables: Developing a Customer Relationship Management Workbook.
8. Performing What-If Analyses: Maximizing Profits with the Right Product Mix.
9. Exploring Financial Tools and Functions: Analyzing a Business Plan.
10. Managing Data with Business Intelligence Tools.
11. Exploring PivotTable Design: Summarizing Sales and Revenue Data.
12. Developing an Excel Application: Creating a Data Entry App.

• 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. He has taught and written about a wide range of topics, including website design, JavaScript programming, Microsoft Office and Excel, statistics, data analysis and mathematics. Mr. Carey received his M.S. in biostatistics from the University of Wisconsin, where he worked as a researcher designing and analyzing clinical studies. Today, he splits his time between Wisconsin and Colorado, and when he is not writing, he can be found hiking and cycling.

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

• Using an in-depth, case-based approach, the NEW PERSPECTIVES COLLECTION 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.

• Part of the NEW PERSPECTIVES MICROSOFT® 365® COLLECTION, this title provides access to a complete digital library of content spanning computer concepts, operating systems (for Windows and Mac) and the Microsoft® Office® Suite -- all for one price including low-cost rental options. Learn more about Cengage Unlimited at cengage.com/unlimited.

• Module Learning Objectives are mapped to the Microsoft Office Specialist (MOS) exam. Users of MindTap Collections and SAM will have access to exam preparation materials and the option to purchase a discounted MOS exam voucher.

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

Cengage provides a range of supplements that are updated in coordination with the main title selection. For more information about these supplements, contact your Learning Consultant.

Cengage Testing, powered by Cognero® for Campbell/Carey/Shaffer/Shellman's New Perspectives Collection, Microsoft® 365® & Office®
9780357882375

Cengage Testing, powered by Cognero® for Cengage's New Perspectives Collection, Microsoft® 365® & Office®, First Edition, Instant Access
9780357882382

Instructor Companion Website for Cengage's New Perspectives Collection, Microsoft® 365® & Office®
9780357882061