Nelson Higher Education

Higher Education

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

  • Steven M. Freund
  • Joy L. Starks
  • Eric Schmieder
  • ISBN-10: 1305870719
  • ISBN-13: 9781305870710
  • 592 Pages | Paperback
  • COPYRIGHT: 2017 Published
Request a Copy for Review


About the Product

Introduce your students to the latest advancements that Microsoft® Excel 2016 have to offer with MICROSOFT® OFFICE 365 & EXCEL 2016: INTERMEDIATE -- the new edition in today’s generation of acclaimed Shelly Cashman Series® books. For more than three decades, the Shelly Cashman Series® has effectively introduced computer skills to millions of students. MICROSOFT® OFFICE 365 & EXCEL 2016: INTERMEDIATE continues the Series’ strong history of innovation with a hallmark learning approach now enhanced to address the varied learning styles of today’s students. A trademark step-by-step, screen-by-screen approach encourages students to expand their understanding of basic and more advanced Microsoft® Excel 2016 through experimentation, critical thought, and personalization. This new edition and accompanying resources deliver effective educational materials specifically designed to engage students, improve retention, and prepare today’s learners for future success.


  • STEP-BY-STEP, SCREEN-BY-SCREEN APPROACH EFFECTIVELY INTRODUCES KEY MICROSOFT® EXCEL 2016 SKILLS. This proven visual approach presents explanatory and navigational information as students need to know it. The book addresses the needs of all learning styles to help students retain and apply both basic and more advanced skills in their personal and professional lives.

  • PROVEN PEDAGOGY EMPHASIZES PROJECT PLANNING. This project planning approach frames the explanations within each module around a practical problem that students need to solve. This intermediate presentation encourages critical thinking as the learner determines how to proceed at various key points within the module.

  • EXTENSIVE END-OF-MODULE ACTIVITIES REINFORCE KEY INTERMEDIATE MICROSFOT® EXCEL SKILLS AND APPLICATIONS. These proven, class-tested activities provide a variety of reinforcement opportunities for students to apply and expand their basic and more advanced Microsoft® Excel 2016 skills.

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

Joy L. Starks

Joy Starks has taught at Indiana University Purdue University Indianapolis for 20 years. She has written chapters in several of the best-selling Shelly Cashman Series Office books and has authored the Photoshop, Java Programming, and Microsoft® Publisher series of books. She speaks and presents at various conferences, seminars and forums across the U.S.

Eric Schmieder

For over 15 years, Mr. Schmieder has served as a computer technology instructor in adjunct and full-time capacities in curriculum instruction, corporate training, continuing education, economic and workforce development, professional development, small business, and webmaster certificate programs throughout North Carolina. His classroom instruction has served students at NC State University and many schools in the NC Community College System. He is a member of the NC Computer Instructors Association (NCCIA), NC Community College Faculty Association (NCCCFA), Textbook and Academic Authors Association (TAA), and US Distance Learning Association (USDLA). He holds certifications as a Microsoft Certified Trainer and Microsoft Office Master Specialist and is a regular presenter at local and national conferences.

Table of Contents

Microsoft®’s New Productivity Tools for School and Work
Office 2016 and Windows 10: Essential Concepts and Skills.
1. Creating a Worksheet and a Chart.
2. Formulas, Functions, and Formatting.
3. Working with Large Worksheets, Charting, and What-If Analysis.
4. Financial Functions, Data Tables, and Amortization Schedules.
5. Working with Multiple Worksheets and Workbooks.
6. Creating, Sorting, and Querying a Table.
7. Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet.

New to this edition

  • UPDATED PROJECT IN MODULE 4 SHOWS HOW TO CREATE A MORTGAGE PAYMENT CALCULATOR. Students learn from rewritten step-by-step project instructions that clearly divide complex tasks into smaller, easy-to-understand steps.
  • MODULE 5 NOW INTRODUCES THE EXTENDED BAR AND PIE CHART FORMATTING. This module begins the discussion on extended bar and pie chart formatting, guiding students in the best methods for displaying data.
  • MODULE 6 HIGHLIGHTS ADVANCED USE OF THE QUICK ANALYSIS GALLERY. Analyzing data is now easier than ever in Microsoft® Excel 2016 as students learn how to best use this contextual tool and its single-click access.
  • MODULE 7 INTRODUCES TREEMAP CHARTS AND TEXT EFFECTS. Students learn to use this hierarchical view of data that makes it easy to spot patterns.
  • STUDENTS LEARN MORE ADVANCED SKILLS RELATED TO THE FORMATTING THE EXTENDED BAR AND PIE CHART. Module 8 takes your students’ skills to the next level as they learn to most effectively display data.


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's Website  (ISBN-10: 1305870735 | ISBN-13: 9781305870734)

Find everything you need for your course all in one place. All instructor resources 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.

MindTap Computing, 1 term (6 months) Instant Access for Freund/Starks/Schmieder's Shelly Cashman Series® Microsoft® Office 365 & Excel 2016: Comprehensive  (ISBN-10: 1305870751 | ISBN-13: 9781305870758)

MindTap Computing for Freund/Starks/Schmieder's Shelly Cashman Series® Microsoft® Office 365 & Excel 2016: Comprehensive is the digital learning solution that powers students from memorization to mastery. It gives you complete control of your course—to provide engaging content, to challenge every individual, and to build their confidence. Empower students to accelerate their progress with MindTap. MindTap: Powered by You. MindTap gives you complete ownership of your content and learning experience. Customize the interactive syllabi, emphasize the most important topics, and add your own material or notes in the eBook.

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

MindTap Computing, 1 term (6 months) Instant Access for Freund/Starks/Schmieder's Shelly Cashman Series® Microsoft® Office 365 & Excel 2016: Comprehensive  (ISBN-10: 1305870751 | ISBN-13: 9781305870758)

MindTap Computing for Freund/Starks/Schmieder's Shelly Cashman Series® Microsoft® Office 365 & Excel 2016: Comprehensive helps you learn on your terms. INSTANT ACCESS IN YOUR POCKET. Take advantage of the MindTap Mobile App. Read or listen to the text and study with the aid of instructor notifications, flashcards, and practice quizzes. MINDTAP HELPS YOU GEAR UP FOR ULTIMATE SUCCESS. Track your scores and stay motivated toward goals. Whether you have more work to do or are ahead of the curve, you’ll know where you need to focus your efforts. And the MindTap Green Dot will charge your confidence along the way. MINDTAP HELPS YOU OWN YOUR PROGRESS. MAKE YOUR TEXTBOOK YOURS. No one knows what works for you better than you. Highlight key text, add notes, and create custom flashcards. When it’s time to study, everything you’ve flagged or noted can be gathered into a guide you can organize.

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.