New Perspectives on Microsoft® Excel® 2013, Comprehensive

  • AUTHORS: June Jamrich Parsons; Dan Oja; Roy Ageloff; Patrick Carey; Carol DesJardins
  • ISBN-13: 9781285169330 
  • Grade(s): 9 | 10 | 11 | 12
  • 992 Pages  Paperback 
  • 1st Edition  |  Previous Editions: 2011
  • ©2014     Published
  • Prices are valid only in the respective region

Overview

About The Product

With proven pedagogy that emphasizes critical-thinking, problem-solving, and in-depth coverage, New Perspectives helps students develop the Microsoft Office 2013 skills they need to be successful in college and beyond. Updated with all new case-based tutorials, New Perspectives Microsoft Excel 2013 continues to engage students in applying skills to real-world situations, making concepts relevant. A new Troubleshoot case problem enhances critical thinking, and a new tutorial on Managing Your Files helps students navigate Windows 8. As always, New Perspectives improves learning outcomes and transference of skills by helping students understand why what they're learning is important.

Features

  • 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 tutorial – gives a visual look at the tasks and elements covered in the tutorial and can be used as a study guide before quizzes and tests.
  • ProSkills boxes tie Excel 2013 concepts with career relevancy by providing guidance on how to use the software in professional situations.
  • ProSkills Exercises integrate technology skills with professional skills, further grounding concepts in reality. ProSkills exercises include topics such as teamwork, written communication, verbal communication, problem solving, and decision making.
  • Key Steps highlight important points to help students pay close attention to completing the step correctly and avoiding time-consuming rework.

About the Contributor

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

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

  • 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

Managing Your Files.
Tutorial 1: Getting Started with Excel.
Tutorial 2: Formatting Workbook Text and Data.
Tutorial 3: Calculating Data with Formulas and Functions.
Tutorial 4: Analyzing and Charting Financial Data.
Tutorial 5: Working with Excel Tables, PivotTables, and PivotCharts.
Tutorial 6: Managing Multiple Worksheets and Workbooks.
Tutorial 7: Developing an Excel Application.
Tutorial 8: Working with Advanced Functions.
Tutorial 9: Exploring Financial Tools and Functions.
Tutorial 10: Performing What-If Analyses.
Tutorial 11: Connecting to External Data.
Tutorial 12: Collaborating on a Shared Workbook.
Additional Cases.
Appendix A: Working with Text Functions and Creating Custom Formats.
Appendix B: Using Advanced Filters, Database, and Summary IFS Functions.
Appendix C: Enhancing Excel with Visual Basic for Applications.
Appendix D: Working with Enhanced Formatting Tools.

New to this Edition

  • Fully updated to reflect the new features and enhancements in Microsoft Office 2013.
  • New case scenarios for all tutorials and end-of-tutorial exercises, including Review Assignments and Case Problems, engage students in applying skills and concepts to real-world situations.
  • New Troubleshoot case problems engage students in locating, analyzing, and correcting existing errors to enhance critical-thinking skills.
  • New Managing Your Files tutorial covers file management in Windows 8, the differences between Windows 7 and Windows 8, as well as some of the new touch features in Windows 8 and Office 2013.

Downloads