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

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 Master of Science 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.

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