New Perspectives on Microsoft Office 2010, Second Course

  • AUTHORS: Ann Shaffer; Patrick Carey; Roy Ageloff; S. Scott Zimmerman; Beverly B. Zimmerman
  • ISBN-13: 9780538743099 
  • Grade(s): 9 | 10 | 11 | 12
  • 904 Pages  Paperback 
  • 1st Edition  |  Previous Editions: 2009, 2004
  • ©2011     Published
  • Prices are valid only in the respective region


About The Product

With the New Perspectives' critical-thinking, problem-solving approach, students will gain a comprehensive understanding of Microsoft Office 2010 and will learn how to take advantage of the flexibility it offers. Case-based tutorials challenge students to apply what they are learning to real-life tasks, preparing them to easily transfer skills to new situations. With New Perspectives, students understand why they're learning what they're learning and are better situated to retain skills beyond the classroom.


  • Business case scenarios keep students engaged throughout the tutorials, providing a real-world context in which they can apply the concepts and skills presented.
  • Visual Overview – a two-page spread at the start of each session – gives a preview of the topics and terms covered in the session and can be used as a study guide before quizzes and tests.
  • ProSkills Boxes tie Office 2010 concepts and skills with career relevancy by providing guidance for using the software in professional situations.
  • ProSkills exercises integrate the technology skills students learn with one or more of today's necessary professional skills, such as teamwork, written communication, verbal communication, problem solving and decision making.
  • Key Steps highlight important steps to help students pay close attention to completing the step correctly and avoid time-consuming rework.

About the Contributor

  • Ann Shaffer

    Ms. Ann Shaffer has contributed to several books about computers, including NEW PERSPECTIVES ON MICROSOFT® WORD. She began a career in textbook publishing as a Development Editor for William C. Brown and is now a freelance technical editor and writer. Ms. Shaffer holds a Master's degree in English from the University of Wisconsin-Madison.

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

  • Roy Ageloff

    Roy Ageloff has taught courses in computer programming, database design and development, accounting information systems, and office productivity software at the University of Rhode Island and has written textbooks in programming languages, database software, and spreadsheet applications. He is a business consultant and teacher at Paradise Valley Community College, Arizona.

  • S. Scott Zimmerman

    S. Scott Zimmerman obtained a Ph.D. from Florida State University and was a postdoctoral fellow at Cornell University. He is currently a professor at Brigham Young University in Provo, Utah and has published many scientific papers, computer articles, and computer programming and applications software books.

  • Beverly B. Zimmerman

    Beverly B. Zimmerman, an award-winning Associate Professor at Brigham Young University, holds a Ph.D. in instructional design. She has published several articles on the use of computer technology for teaching writing, co-authored over 30 books on computer applications software, and authored an oral presentations book.

Table of Contents

Word--Level II Tutorials.
Tutorial 5: Working with Templates and Outlines.
Tutorial 6: Using Mail Merge.
Tutorial 7: Collaborating with Others and Creating Web Pages.
Excel--Level II Tutorials.
Tutorial 5: Working with Excel Tables, PivotTables, and PivotCharts.
Tutorial 6: Managing Multiple Worksheets and Workbooks.
Tutorial 7: Using Advanced Functions, Conditional Formatting, and Filtering.
Tutorial 8: Developing an Excel Application.
Appendix A: Working with Text Functions and Creating Custom Format.
Appendix B: Integrating Excel with Other Windows Programs.
Access--Level II Tutorials.
Tutorial 5: Creating Advanced Queries and Enhancing Table Design.
Tutorial 6: Using Form Tools and Creating Custom Forms.
Tutorial 7: Creating Custom Reports.
Tutorial 8: Sharing, Integrating, and Analyzing Data.
Appendix A: Relational Databases and Database Design.
PowerPoint--Level II Tutorials.
Tutorial 3: Presenting a Slide Show with Special Effects.
Tutorial 4: Integrating PowerPoint with Other Programs and Collaborating with Workgroups .