• Trusted Partner! This product suite was developed to cover the most critical features of the Excel to drive student engagement and comprehension. By implementing feedback from partners in the Cengage Computing Community and beyond, as well as incorporating the 2019 Microsoft Office Skills (MOS), students will learn and apply key skills they need for success not just on their educational and professional journeys, but also in their day-to-day usage of Excel. With Cengage’s dedication to providing meaningful and engaging solutions for students, our team is available to connect and assist with onboarding and training in the classroom to further support students on their Microsoft Office journey.
• Affordable! The product suite is available in a variety of purchase options to give students the best value for the tools and resources that they need and to allow students to choose how to learn. With the launch of Cengage Unlimited, student can access all of the Microsoft Office content for just one price, plus thousands of other resources, plus opt for a low-cost rental or purchase of a bound book or loose-leaf text. Students benefit from access to the full Office Collections in MindTap.
• Quality Learning! This series goes beyond learning Excel applications by providing contextual relevance with a trusted and proven pedagogy combined with real world scenarios and assessments. With a deeper focus on employability, this new edition demonstrates real world relevance and professionalism with all-new case scenarios written to reflect the top industries hiring for Microsoft Excel skills.The New Perspectives Series’ critical-thinking, problem-solving approach has a case-based pedagogy built around realistic business scenarios. This is the ideal way to prepare students to transcend point-and-click skills and take advantage of all that Microsoft Excel 2019 has to offer. The new edition gives students the software concepts and practical skills they need to succeed beyond the classroom. With the New Perspectives Series, students understand why they are learning what they are learning and are prepared to apply their skills and solve problems in real-life situations.
• Easy! As part of our new intuitive design, the updated readings are now closely aligned with SAM (Skills Assessment Manager) Trainings, Exams, and Projects to reflect the latest and greatest Office 365 and Excel 2019 features. With a focus on more practice opportunities, SAM Projects have expanded Textbook Projects to all module levels (Introduction, Intermediate, and Advanced). To help students utilize Textbook Projects fully, a new SAM icon is now embedded in the readings. The icon indicates when a student should download their files from SAM or MindTap to start a Textbook Project, and when they should upload their completed Textbook Project for instantaneous grading and feedback. There are also new SAM End-of-Module Projects, which are based on the Case Problems found in each module and offer full auto grading. With a variety of easy-to-use assessments, students will be able to quickly and efficiently demonstrate their understanding of Excel.

1. Getting Started with Excel.

2. Formatting Workbook Text and Data.

3. Performing Calculations with Formulas and Functions.

4. Analyzing and Charting Financial Data.

5. Generating Reports from Multiple Worksheets and Workbooks.

6. Managing Data with Data Tools.

7. Summarizing Data with PivotTables. 

8. Performing What-If Analyses.

9. Exploring Financial Tools and Functions.

10. Analyzing Data with Business Intelligence Tools.

11. Exploring PivotTable Design.

12. Developing an Excel Application.

Excel Appendix A: Customizing Your Workspace Text and Graphics. (Digital Only).

Excel Appendix B: Introducing Power BI (Digital Only).

Excel Appendix C: Collaborating with Your Team. (Digital Only).

Index.

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.