Using a unique in-depth, case-based approach, Cengage's NEW PERSPECTIVES COLLECTION, MICROSOFT® 365® & EXCEL® 2021 COMPREHENSIVE helps you prepare 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 Burning Glass market insights, you will sharpen your critical-thinking and problem-solving skills. Professional tips and insights incorporated throughout provide context and relevancy to real-world practice, while ProSkills Boxes help strengthen your employability skills, including written and verbal communication. 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) online resources provide interactive study tools to help maximize your study time -- and results.
Module 1: Getting Started With Excel: Tracking Miscellaneous Expenses
for a Conference.
Module 2: Formatting Workbook Text and Data: Creating a Sales Report.
Module 3: Performing Calculations With Formulas and Functions: Staffing a
Call Center.
Module 4: Analyzing and Charting Financial Data: Preparing an Investment
Report.
Module 5: Generating Reports From Multiple Worksheets and Workbooks:
Summarizing Profit and Loss Statements.
Module 6: Managing Data With Data Tools: Analyzing Employment Data.
Module 7: Summarizing Data With PivotTables: Preparing A Social Media
Marketing Report.
Module 8: Performing What-If Analyses: Maximizing Profits With the Right
Product Mix.
Module 9: Exploring Financial Tools and Functions: Analyzing.
Module 10: Analyzing Data With Business Intelligence Tools: Presenting Sales
and Revenue Data.
Module 11: Exploring PivotTable Design: Summarizing Sales and Revenue Data.
Module 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.
