Nelson Higher Education

Higher Education

New Perspectives Microsoft® Office 365 & Excel 2016: Comprehensive, 1st Edition

  • June Jamrich Parsons
  • Dan Oja
  • Patrick Carey
  • Carol DesJardins
  • ISBN-10: 1305880404
  • ISBN-13: 9781305880405
  • 888 Pages | Paperback
  • Previous Editions: 2014, 2011, 2011
  • COPYRIGHT: 2017 Published
Request a Copy for Review

Overview

About the Product

Help your students develop the complete set of Microsoft® Excel 2016 skills they need to be successful in college and beyond with the emphasis on critical-thinking, problem-solving, and in-depth coverage found in NEW PERSPECTIVES MICROSOFT® OFFICE 365 & EXCEL 2016: COMPREHENSIVE. Updated to provide all-new case scenarios, this dynamic introduction applies the skills students are learning to real-world situations to ensure that concepts remain highly relevant. New Productivity Apps provide a visual introduction to Microsoft® OneNote, Sway, Office Mix and Edge with fun, hands-on activities. Companion Sways provide videos and step-by-step instructions to help students learn to use each app. With an unmatched emphasis on learning outcomes and transference of skills, NEW PERSPECTIVES MICROSOFT® OFFICE 365 & EXCEL 2016: COMPREHENSIVE engages students by clearly demonstrating the importance of the complete Microsoft® Excel 2016 skills that they are learning.

Features

  • PROSKILLS BOXES CONNECT MICROSOFT® EXCEL 2016 CONCEPTS TO CAREER SUCCESS. These helpful features emphasize the relevance of all of the Microsoft® Excel skills your students are learning by providing guidance on how to use the software most effectively in professional situations.

  • VISUAL OVERVIEWS PROVIDE A GRAPHIC PREVIEW OF EACH MODULE’S CONTENT. These two-page spreads at the start of each module session visually examine the tasks and elements covered in the module. Students can use these as helpful study guides before taking quizzes or tests.

  • KEY STEPS DRAW STUDENTS’ ATTENTION TO CRITICAL POINTS. These Key Steps help students pay close attention to completing each step correctly and help them avoid time-consuming rework.

About the Author

June Jamrich Parsons

June Parsons purchased her first computer, an Apple II+, in 1981 and quickly became fluent in BASIC, dBASE II, Lotus 123, WordStar, and a variety of accounting programs. The next year she opened a successful small computer retail store with Dan Oja that also offered software instruction to children and adults. Dr. Parsons taught at the university level for more than 20 years. She holds a doctorate in Educational Technology and was certified by the ICCP in 1995. Dr. Parsons began writing and creating educational software for Course Technology in 1992. She contributed to the Windows for Business and Illustrated Series and developed the New Perspectives, e-Course, and Practical series. She works via the Internet with a team of highly skilled media specialists and desktop publishers located in various states and provinces.

Dan Oja

An esteemed professional and respected author, Dan Oja, along with June Parsons, purchased an Apple II+ in 1981 and quickly became fluent in BASIC, dBASE II, Lotus 123, WordStar, and a variety of accounting programs. The next year, he and Dr. Parsons opened a successful small computer retail store that offered software instruction to children and adults. With Dr. Parsons, Mr. Oja began writing and creating educational software for Course Technology in 1992. Together, they contributed to the leading success of the Windows for Business and Illustrated Series. They also developed the New Perspectives, e-Course, and Practical series. Today, Mr. Oja's and Dr. Parson's team of highly skilled media specialists and desktop publishers located in various states and provinces work together via the Internet to deliver exceptional texts.

Patrick Carey

Mr. Patrick Carey received his M.S. in biostatistics from the University of Wisconsin where he worked as a researcher designing and analyzing clinical studies. He co-authored his first textbook on using Excel as a statistical tool. Today, Mr. Carey has authored or co-authored more than 20 leading academic and trade texts for the software industry.

Carol DesJardins

Ms. Carol DesJardins spent 25 years in the private sector as a programmer, systems analyst and eventually Chief Information Officer. During that time, she honed her skills with Excel as an analysis tool. She transitioned her knowledge to the classroom and has taught several applications and programming courses. Ms. DesJardins co-authored her first textbook on Excel. In addition to writing, she continues to teach at St. Clair County Community College.

Table of Contents

Productivity Apps for School and Work.
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. Working with Excel Tables, PivotTables, and PivotCharts.
6. Managing Multiple Worksheets and Workbooks.
7. Developing an Excel Application.
8. Working with Advanced Functions.
9. Exploring Financial Tools and Functions.
10. Performing What-If Analyses.
11. Analyzing Data with Business Intelligence.
12. Collaborating on a Shared Workbook.
Appendix A: Working with Text Functions and Creating Custom Formats.
Appendix B: Advanced Filters, Database Functions, and Summary IFS Functions.
Appendix C: Working with Enhanced Formatting Tools.

New to this edition

  • NEW PRODUCTIVITY APPS FOR SCHOOL AND WORK MODULE PROVIDE A VISUAL INTRODUCTION. These helpful, easy-to-use apps by well-known technology author Corinne Hoisington visually guide students through using Microsoft® OneNote, Sway, Office Mix and Edge. Companion Sways provide videos and step-by-step instructions to help students learn to master each app.
  • ALL-NEW BUSINESS CASE SCENARIOS KEEP STUDENTS ENGAGED. These practical case scenarios throughout each module provide a real-world context that allows students to apply the complete Microsoft® Excel 2016 concepts and skills they are learning.
  • CONTENT HIGHLIGHTS NEW FUNCTIONALITIES IN MICROSOFT® EXCEL 2016. New coverage introduces the ROUND and MROUND functions. Students also study new Excel chart types, including histogram, waterfall, and sunburst charts. This edition also offers new content on power BI features, including power query, power view, and power map.

Supplements

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: 1305880447 | ISBN-13: 9781305880443)

Find everything you need for your course in one place. This collection of book-specific lecture and class tools is available online via www.cengage.com/login. Access and download PowerPoint® presentations, images, instructor’s manual, videos, and more.

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

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 Carey/DesJardins’ New Perspectives Microsoft® Office 365 & Excel 2016: Comprehensive  (ISBN-10: 1305880749 | ISBN-13: 9781305880740)

MindTap Computing for Carey/DesJardins’ New Perspectives 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.

MindTap Computing, 2 terms (12 months) Instant Access for Carey/DesJardins’ New Perspectives Microsoft® Office 365 & Excel 2016: Comprehensive  (ISBN-10: 1305882601 | ISBN-13: 9781305882607)

MindTap Computing for Carey/DesJardins’ New Perspectives 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 Carey/DesJardins’ New Perspectives Microsoft® Office 365 & Excel 2016: Comprehensive  (ISBN-10: 1305880749 | ISBN-13: 9781305880740)

MindTap Computing for Carey/DesJardins’ New Perspectives Microsoft® Office 365 & Excel 2016: Comprehensive helps you learn on your terms. INSTANT ACCESS IN YOUR POCKET. Take advantage of the MindTap Mobile App to learn on your terms. Read or listen to textbooks and study with the aid of instructor notifications, flashcards, and practice quizzes. MINDTAP HELPS YOU CREATE YOUR OWN POTENTIAL. 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 to focus 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, gather everything you’ve flagged into a guide you organize.

MindTap Computing, 2 terms (12 months) Instant Access for Carey/DesJardins’ New Perspectives Microsoft® Office 365 & Excel 2016: Comprehensive  (ISBN-10: 1305882601 | ISBN-13: 9781305882607)

MindTap Computing for Carey/DesJardins’ New Perspectives Microsoft® Office 365 & Excel 2016: Comprehensive helps you learn on your terms. INSTANT ACCESS IN YOUR POCKET. Take advantage of the MindTap Mobile App to learn on your terms. Read or listen to textbooks and study with the aid of instructor notifications, flashcards, and practice quizzes. MINDTAP HELPS YOU CREATE YOUR OWN POTENTIAL. 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 to focus 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, gather everything you’ve flagged into a guide you 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.

SAM 365 & 2016 Assessments, Trainings, And Projects With MindTap™ Reader ebook Access (1-year)  (ISBN-10: 1337114103 | ISBN-13: 9781337114103)

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.