Illustrated Microsoft® Office 365® & Excel® 2019 Comprehensive,
1st Edition

Lynn Wermers

ISBN-13: 9780357025703
Copyright 2020 | Published
448 pages | List Price: USD $225.95

Now students can master the nuances of Microsoft® Office quickly with ILLUSTRATED MICROSOFT® OFFICE 365 & EXCEL 2019 COMPREHENSIVE, part of today's popular Illustrated Series. This focused, user-friendly approach uses a proven two-page layout that allows students to work through an entire task without turning the page. Clear Learning Outcomes outline the skills for each lesson, while large full-color screen images reflect exactly what students see on their own computers. Each module begins with a brief overview of the principles covered in the lesson and introduces a real-world case scenario to engage students and reinforce critical skills to make them successful in their educational and professional careers. In addition, MindTap and updated SAM (Skills Assessment Manager) online resources are available to guide additional study and ensure successful results.


1. Getting Started with Excel.
2. Formatting a Worksheet.
3. Analyzing Data Using Formulas.
4. Working with Charts.
5. Working with Tables.
6. Managing Workbook Data.
7. Working with Images and Integrating with Other Programs.
8. Analyzing Data with PivotTables.
9. Automating Worksheet tasks.
10. Advanced Worksheet Management.
11. Advanced Formulas and Functions.
12. Performing What-if Analysis.

  • Lynn Wermers

    Lynn Wermers is a professor in the computer science department at North Shore Community College in Massachusetts, where she teaches IT, data management, data analysis and web development courses. She also teaches part time in the math department for the College of Professional Studies at Northeastern University. Wermers has authored numerous leading books focusing on Excel for Cengage.

  • Quality Learning! This series goes beyond learning Office 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. In addition, the Illustrated Series pedagogy offers a unique, two-page, easy to follow design. With a skill-based approach presenting tasks in an intuitive and easy to reference format, this product suite is an ideal learning tool for a wide range of learners. For those new to Excel, they will find the clean design easy to follow and focused with only essential information presented, and the experts will appreciate being able to move quickly through the lessons to find the information they need without reading a lot of text.

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

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

  • Trusted Partner! This product suite was developed to cover the most critical features of the Office applications 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.

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 Beskeen/Cram/Duffy/Friedrichsen/Wermers' The Illustrated Collection, Microsoft Office 365 & Office 2019

Cengage Testing, powered by Cognero® for Beskeen/Cram/Duffy/Friedrichsen/Wermers' The Illustrated Collection, Microsoft Office 365 & Office 2019, Instant Access

Instructor's Companion Website for Beskeen/Cram/Duffy/Friedrichsen/Wermers' The Illustrated Collection

Cengage eBook: Illustrated Microsoft® Office 365® & Excel® 2019 Comprehensive 12 Months