Nelson Higher Education

Higher Education

Shelly Cashman Series® Microsoft® Office 365 & Office 2016: Advanced, 1st Edition

  • Steven M. Freund
  • Mary Z. Last
  • Philip J. Pratt
  • Susan L. Sebok
  • Misty E. Vermaat
  • ISBN-10: 1305870409
  • ISBN-13: 9781305870406
  • 1152 Pages | Paperback
  • Previous Editions: 2014, 2011, 2008
  • COPYRIGHT: 2017 Published
Request a Copy for Review


About the Product

Introduce your students to the most advanced new features within the latest version of Microsoft® Office with the focused approach found in Shelly Cashman Series® MICROSOFT® OFFICE 365 & OFFICE 2016: ADVANCED. This new edition is part of the acclaimed Shelly Cashman Series® that has effectively introduced computer skills to millions. Shelly Cashman Series® MICROSOFT® OFFICE 365 & OFFICE 2016: ADVANCED continues the Series’ strong history of innovation with an enhanced learning approach that addresses the varied learning styles of today’s students. A trademark step-by-step, screen-by-screen approach encourages students to expand their understanding of Microsoft® Office 2016’s higher-level features through experimentation, critical thought, and personalization. This new edition delivers some of today’s most effective educational materials specifically designed to engage readers, improve retention, and prepare students for success in using the most advanced features within Microsoft® Office 2016.


  • BOOK OFFERS UNIQUE EMPHASIS ON THE REASONING BEHIND EACH PROCESS. Students go well beyond simply following instructions as they accomplish each task. They explore the context for their complete projects as they learn the “why” behind each step in the process.

  • ROADMAPS FOR EACH MODULE DETAIL PROGRESS. Helpful Roadmaps within each module visually emphasize for students where they are in the process of completing the module project and guide them in tackling more advanced skills and concepts.

  • CONTENT EMPHASIZES CRITICAL THINKING SKILLS. Opportunities to refine critical thinking appear throughout the text within Consider This sections, thought-provoking questions, and problem-solving activities. Numerous end-of-module activities engage students in critical thinking and highlight problem-solving skills as students learn to create their own solutions.

  • BOOK ENCOURAGES PERSONALIZATION. This edition asks students to incorporate personal details in their solutions for every module project and assignment. This not only emphasizes the practicality of what they are learning, but also ensures that each student’s solution will be unique.

About the Author

Steven M. Freund

Steven M. Freund attended the University of Central Florida and serves as a leader instructor of various Microsoft® Office, computer concepts, programming, and Internet technology courses throughout Central Florida. An integral author for the successful Shelly Cashman Series since 2001, he has presented at the annual customer conference, the Shelly Cashman Series Institute, as well as other customer events. Mr. Freund has co-authored multiple editions of DISCOVERING COMPUTERS, Mozilla Firefox, Windows® Internet Explorer, Windows®, Office, and Dreamweaver books. He has also written numerous successful instructor supplements..

Mary Z. Last

Mary Z. Last has taught computer information systems since 1984. She retired from the University of Mary Hardin-Baylor, Belton, Texas, where she was an associate professor and the Director of the Center for Effectiveness in Learning and Teaching. Ms. Last is actively involved in the Computing Educator's Oral History Project that encourages young women to pursue careers in math and science. She has been a contributing author to the Shelly Cashman Series since 1992. She also authors many instructor resources for leading database texts.

Philip J. Pratt

Philip J. Pratt is Professor Emeritus of Mathematics and Computer Science at Grand Valley State University, where he taught for 33 years. His teaching interests include database management, systems analysis, complex analysis and discrete mathematics. He has authored more than 75 textbooks and has co-authored three levels of Microsoft® Office Access books for the popular Shelly Cashman Series, in addition to the popular A GUIDE TO SQL.

Susan L. Sebok

Susan L. Sebok is a retired professor at South Suburban College in South Holland, Illinois. She is also a licensed attorney. Ms. Sebok has co-authored several successful textbooks for the leading Shelly Cashman Series, including multiple versions of Microsoft® PowerPoint® and DISCOVERING COMPUTERS.

Misty E. Vermaat

Misty E. Vermaat has more than 25 years of experience in the field of computer and information technology. In addition to consulting in the field, she was an Associate Professor at Purdue University Calumet, teaching or developing Microsoft® Office, computer concepts, database management, systems analysis and design, and programming courses. Since 1990, Ms. Vermaat has led the development of the Shelly Cashman Series and has written or co-authored numerous Series textbooks, including many editions of DISCOVERING COMPUTERS, DISCOVERING COMPUTERS FUNDAMENTALS and Microsoft® Word books.

Table of Contents

Microsoft’s New Productivity Tools for School and Work.
Word 8. Using Document Collaboration, Integration, and Charting Tools.
Word 9. Creating a Reference Document with a Table of Contents and an Index.
Word 10. Creating a Template for an Online Form.
Word 11. Enhancing an Online Form and Using Macros.
PPT 8. Customizing a Template and Handouts Using Masters.
PPT 9. Modifying a Presentation Using Graphical Elements.
PPT 10. Developing a Presentation with Content from Outside Sources.
PPT 11. Organizing Slides and Creating a Photo Album.
Excel 8. Working with Trendlines, Pivot Table Reports, PivotChart Reports, and Slicers.
Excel 9. Formula Auditing, Data Validation, and Complex Problem Solving.
Excel 10. Using Macros and Visual Basic for Applications (VBA) with Excel.
Excel 11. Collaboration Features for Workbooks.
Access 8. Macros, Navigation Forms, and Data Macros.
Access 9. Administering a Database System.
Access 10. Using SQL.
Access 11. Database Design.
Outlook 4. Creating and Managing Tasks.
Outlook 5. Customizing Outlook.

New to this edition

  • NEW MICROSOFT® WORD MODULES INTRODUCE THE STRENGTHS OF THE LATEST VERSION. This edition provides new, advanced hands-on module projects and effective introductions that ensure students know how to use the more sophisticated features new to Microsoft® Word 2016, including SmartArt and the new Share button and pane.
  • NEW MICROSOFT® POWERPOINT® MODULES HIGHLIGHT THE MOST IMPORTANT FEATURES IN THE 2016 VERSION. Your students work with new projects and exercises that emphasize the higher-level topics and PowerPoint® skills that are most relevant in their lives. This edition emphasizes information about the new transition types, coauthoring and Smart Art. The module also expands the book’s explanation of using, inserting and formatting shapes.
  • NEW MICROSOFT® EXCEL® MODULES EMPHASIZE PRATICAL USES FOR NEW FEATURES. An updated project teaches students how to create a personal budget. Updates also provide additional details on extended bar and pie chart formatting and introduce Treemap charts that are new to Microsoft® Excel 2016.
  • NEW PRODUCTIVITY APPS FOR THE SCHOOL AND WORK MODULE PROVIDES A STRONG VISUAL INTRODUCTION. These helpful, easy-to-use apps by technology author Corinne Hoisington visually guide students through using Microsoft® OneNote, Sway, Office Mix and Edge. Fun, hands-on activities ensure active learning. Companion Sways provide videos and step-by-step instructions to help students learn to master each app.


All supplements have been updated in coordination with the Main title.
Please see Main title page for new to this edition information.

Instructor Supplements

Instructor Website  (ISBN-10: 1305870417 | ISBN-13: 9781305870413)

Find everything you need for your course all in one place. All instructor resources for this book are available instantly through the password-protected Instructor Companion Website, including the Instructor’s Manual, Test Bank and PowerPoint® slides.

Cengage Testing, powered by Cognero® Instant Access  (ISBN-10: 1305881516 | ISBN-13: 9781305881518)

Cengage Learning Testing, powered by Cognero®, is a flexible, online system that allows you to import, edit, and manipulate content from the text’s test bank or elsewhere, including your own favorite test questions. Create multiple test versions in an instant and deliver tests from your LMS, your classroom, or wherever you want.

SAM 365 & 2016 Assessment, Training, and Projects Instant Access with 1 MindTap Reader, (6 months) Instant Access  (ISBN-10: 133711393X | ISBN-13: 9781337113939)

SAM trains and assesses essential Microsoft Office and computer concepts skills. Students engage in a hands-on simulated environment, then apply their skills live in the applications with real world scenarios. SAM’s auto-graded assignments and flexible reporting tools saves instructors time and energy.

Student Supplements

SAM 365 & 2016 Assessment, Training, and Projects Instant Access with 1 MindTap Reader, (6 months) Instant Access  (ISBN-10: 133711393X | ISBN-13: 9781337113939)

This access code is available to you for as long as your institution uses SAM 365 & 2016. MindTap Reader access length is dependent upon how it was setup by your instructor. SAM – Skills Assessment Manager – is the top online training resource for Microsoft Office and computer concepts skills. With automatic feedback on assignments and personalized study guides, SAM helps you stay on track for improved grades. SAM has all your course content in one easy location. SAM training and assessments simulate the real Microsoft Office environment and SAM projects let you apply the skills live in the application using real-world scenarios, preparing you for more workplace success.