Using a unique in-depth, case-based approach, Carey's NEW PERSPECTIVES MICROSOFT® 365® EXCEL® COMPREHENSIVE, FIRST EDITION, 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.
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.
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.
