Nelson Higher Education

Higher Education

New Perspectives on Microsoft® Excel® 2013, Comprehensive Enhanced Edition, 1st Edition

  • Roy Ageloff
  • Patrick Carey
  • June Jamrich Parsons
  • Dan Oja
  • Carol DesJardins
  • ISBN-10: 1305501128
  • ISBN-13: 9781305501126
  • 1016 Pages | Paperback
  • Previous Editions: 2014, 2011, 2011
  • COPYRIGHT: 2016 Published
Request a Copy for Review

Overview

About the Product

Help your students develop the critical Microsoft® Excel 2013 skills they need for success in college and beyond with this latest edition from the leading New Perspectives Series. Updated with all-new case-based tutorials, NEW PERSPECTIVES MICROSOFT® EXCEL 2013, COMPREHENSIVE ENHANCED EDITION continues to engage students by applying MS Excel 2013 skills to real situations that fully demonstrate the relevance of concepts. Proven pedagogy emphasizes critical thinking, problem-solving, and in-depth coverage. A new Troubleshoot case problem enhances analytical skills, while a new tutorial on Managing Your Files helps students navigate Windows 8. A wealth of resources, including MindTap and SAM, provides opportunities for students to practice skills. Improve learning outcomes and ensure transference of skills as NEW PERSPECTIVES MICROSOFT® EXCEL 2013 helps students understand why what they’re learning is important.

Features

  • BUSINESS CASE SCENARIOS PROVIDE A REAL-WORLD CONTEXT FOR CONCEPTS. These intriguing scenarios keep students engaged throughout the tutorials as they provide a real-world context in which students can apply the Excel concepts and skills they are learning.

  • TWO-PAGE VISUAL OVERVIEWS INTRODUCE KEY ELEMENTS OF EACH TUTORIAL. This dynamic two-page graphic spread at the beginning of each tutorial previews the Excel tasks and elements the tutorial will address. These Overviews can serve as a useful study guide before quizzes and tests.

  • PROSKILLS BOXES DEMONSTRATE THE RELEVANCY OF EXCEL 2013 CONCEPTS TO CAREERS. These features provide guidance on how to most effectively use Excel software in professional situations.

  • PROSKILLS EXERCISES INTEGRATE TECHNOLOGY SKILLS WITH PROFESSIONAL SKILLS. These exercises further ground concepts in today’s business reality. ProSkills Exercises focus on relevant topics, such as teamwork, written communication, verbal communication, problem solving, and decision making.

  • KEY STEPS HIGHLIGHT IMPORTANT POINTS IN COMPLETING WORK CORRECTLY. This helpful feature guides students in paying close attention in order to accomplish each step the right way and avoid any time-consuming re-work.

About the Author

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.

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.

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

Student Success Guide.
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: Advanced Filters, Database Functions, and Summary IFS Functions.
Appendix C: Enhancing Excel with Visual Basic for Applications.
Appendix D: Working with Enhanced Formatting Tools.
Appendix E: SAM Projects.
Appendix F: Capstone Projects.
Appendix G: Microsoft Office Specialist Certification.

New to this edition

  • NEW STUDENT SUCCESS GUIDE PROVIDES HELPFUL INSIGHTS, TOOLS AND TECHNIQUES. This useful Guide offers content essential to your students’ success in the classroom with a special focus on effective planning, time management, and study tools. The Guide emphasizes Microsoft® OneNote, in particular, to increase students’ overall effectiveness.
  • NEW SAM PROJECTS APPENDIX HIGHLIGHTS INSTRUCTIONS FOR NEW PROJECTS THAT CORRESPOND WITH THIS EDITION. You’ll find printed instructions for a new instructor-authored SAM Project that corresponds to the new content in this edition.
  • NEW CAPSTONE PROJECTS APPENDIX PROVIDES THREE NEW PROJECTS TO CHALLENGE STUDENTS. These thought-provoking projects encourage students to apply the Excel concepts and skills they’ve learned with three levels of content: Introductory (Tutorials 1-4), Intermediate (Tutorials 5-8), and Advanced (Tutorials 9-12).
  • NEW MICROSOFT® OFFICE SPECIALIST CERTIFICATION APPENDIX PROVIDES AN INVALUABLE REFERENCE TOOL. This new appendix highlights key information about the certification program with a table that indicates where applicable certification skills are covered in this edition. This information is vital for students pursuing the Microsoft® Office Specialist Core and Expert Exams for Excel 2013.

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

Website  (ISBN-10: 130550559X | ISBN-13: 9781305505599)

Discover 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 helpful PowerPoint® presentations, the timesaving Solutions Manual and more.

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

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 Ageloff/Carey/Parsons/Oja/DesJardins' New Perspectives on Microsoft® Excel® 2013, Comprehensive Enhanced Edition  (ISBN-10: 1305574699 | ISBN-13: 9781305574694)

MindTap Computing for Ageloff/Carey/Parsons/Oja/DesJardins’ New Perspectives on Microsoft® Excel® 2013, Comprehensive Enhanced Edition is the digital learning solution that helps instructors engage and transform today’s students into critical thinkers. Through paths of dynamic assignments and applications that you can personalize, real-time course analytics, and an accessible reader, MindTap helps you turn cookie cutter into cutting edge, apathy into engagement, and memorizers into higher-level thinkers. As an instructor using MindTap you have at your fingertips the right content and unique set of tools curated specifically for your course, all in an interface designed to improve workflow and save time when planning lessons and course structure. The control to build and personalize your course is all yours’, focusing on the most relevant material while also lowering costs for your students. Stay connected and informed in your course through real time student tracking that provides the opportunity to adjust the course as needed based on analytics of interactivity in the course.

LMS Integrated for MindTap Computing, 1 term (6 months) Instant Access  (ISBN-10: 1305575903 | ISBN-13: 9781305575905)

This access code will provide your students with seamless access to their MindTap Computing resources from within your campus Learning Management System. Students will be prompted to enter this access code the first time that they click on a link in your course that includes Cengage content.

LMS Integrated for SAM 2013 Assessment, Training, and Projects with MindTap Reader, 1 term Instant Access  (ISBN-10: 1305673182 | ISBN-13: 9781305673182)

Student Supplements

MindTap Computing, 1 term (6 months) Instant Access for Ageloff/Carey/Parsons/Oja/DesJardins' New Perspectives on Microsoft® Excel® 2013, Comprehensive Enhanced Edition  (ISBN-10: 1305574699 | ISBN-13: 9781305574694)

As a student using MindTap Computing for Ageloff/Carey/Parsons/Oja/DesJardins’ New Perspectives on Microsoft® Excel® 2013, Comprehensive Enhanced Edition, you have the tools you need to better manage your limited time, with the ability to complete assignments whenever and wherever you are ready to learn. Course material that is specially customized for you by your instructor in a proven, easy-to-use interface, keeps you engaged and active in the course. MindTap helps you achieve better grades today by cultivating a true understanding of course concepts, and with a mobile app to keep you on track. With a wide array of course specific tools and apps – from note taking to flashcards – you can feel confident that MindTap is a worthwhile and valuable investment in your education. You will stay engaged with real world assignments and motivated by information that shows where you stand at all times--both individually and compared to the highest performers in class. MindTap eliminates the guesswork, focusing on what’s most important to your instructor with a learning path designed specifically by your instructor and for your course. Master the most important information with built-in study tools such as that help students stay organized and use their time efficiently.

LMS Integrated for MindTap Computing, 1 term (6 months) Instant Access  (ISBN-10: 1305575903 | ISBN-13: 9781305575905)

This access code will provide you with seamless access to your MindTap Computing resources from within your campus Learning Management System. You will be prompted to enter this access code the first time that you click on a link in your course that includes Cengage content.

LMS Integrated for SAM 2013 Assessment, Training, and Projects with MindTap Reader, 1 term Instant Access  (ISBN-10: 1305673182 | ISBN-13: 9781305673182)