Enhanced Microsoft® Excel® 2013: Comprehensive

  • AUTHORS: Steven M. Freund; Mali Jones; Joy L. Starks
  • ISBN-13: 9781305501171 
  • Grade(s): 9 | 10 | 11 | 12
  • 952 Pages  Paperback 
  • 1st Edition
  • ©2016     Published
  • Prices are valid only in the respective region

Overview

About The Product

Introduce students to the latest advantages that Microsoft® Excel has to offer with this new book in the next generation of the Shelly Cashman Series®. For three decades, the Shelly Cashman Series® has effectively introduced essential computer skills to millions of students. ENHANCED MICROSOFT® EXCEL 2013: COMPREHENSIVE continues this history of innovation with enhanced pedagogy to accommodate the varied learning styles of today’s students. New features are specifically designed to engage students, improve retention, and prepare them for future success. A trademark step-by-step, screen-by-screen approach now encourages students to expand their understanding of Excel 2013 through experimentation, critical thought, and personalization. New labs integrate cloud and web technologies with Excel while other enhancements ensure this Shelly Cashman Series® book delivers the most effective Excel introduction for your students.

Features

  • STEP-BY-STEP, SCREEN-BY-SCREEN APPROACH HELPS STUDENTS RETAIN AND APPLY SKILLS. Your students have the explanatory and navigational information they need when they need to know it. This proven approach addresses all learning styles to help students recall and practice these skills in their personal and professional lives.
  • EMPHASIS ON PROJECT PLANNING FRAMES EACH CHAPTER. Each chapter centers around a practical problem that readers need to solve. This highly successful approach encourages critical thinking and problem solving as students determine how to proceed at various points in the chapter.
  • EXTENSIVE END-OF-CHAPTER ACTIVITIES REINFORCE CONCEPTS AND STRENGTHEN PRACTICAL EXCEL SKILLS. You’ll find a variety of class-tested reinforcement opportunities for students at the end of each chapter. Activities are specifically developed to encourage students to apply and expand their understanding of today’s most important Excel skills.

About the Contributor

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

  • Mali Jones

    Mali B. Jones has more than 20 years of editorial, instructional and support experience in the field of computer and information technology. She has been associated with the Shelly Cashman Series for nearly 10 years, providing editorial, authoring, and product management services.

  • Joy L. Starks

    Joy L. Starks is a Professor of Computer and Information Technology at Indiana University Purdue University Indianapolis. She has written chapters in several of the Shelly Cashman Series Office books and authored the Photoshop, Java Programming, and Microsoft Publisher series of books. As well as speaking engagements, she also hosts the nationally-renowned Tech Camp for Teachers on the IUPUI campus each summer.

Table of Contents

Student Success Guide.
Office 2013 and Windows 8: Essential Concepts and Skills.
Office 365 Essentials.
Excel Chapter 1: Creating a Worksheet and a Chart.
Excel Chapter 2: Formulas, Functions, and Formatting.
Excel Chapter 3: Working with Large Worksheets, Charting, and What-If Analysis.
Excel Chapter 4: Financial Functions, Data Tables, and Amortization Schedules.
Excel Chapter 5: Working with Multiple Worksheets and Workbooks.
Excel Chapter 6: Creating, Sorting, and Querying a Table.
Excel Chapter 7: Creating Templates, Importing Data, and Working with SmartArt, Images, and Screen Shots.
Excel Chapter 8: Working with Trendlines, PivotTable Reports, PivotChart Reports, and Slicers.
Excel Chapter 9: Formula Auditing, Data Validation, and Complex Problem Solving.
Excel Chapter 10: Using Macros, Controls, and Visual Basic for Applications (VBA) with Excel.
Excel Chapter 11: Collaboration Features for Workbooks.
Appendix A: SAM Projects.
Appendix B: Capstone Projects.
Appendix C: MOS Certification.
Index.
Quick Reference.

New to this Edition

  • NEW EMPHASIS HIGHLIGHTS “WHY“ EACH STEP IS NECESSARY. When students complete projects, they learn WHY each step in the process is necessary. In addition to providing this important rationale, this edition clearly explains what the students will be doing and how they can most effectively accomplish each task.
  • NEW MINI-ROADMAPS KEEP STUDENTS FOCUSED ON THEIR PROGRESS THROUGH CHAPTER ASSIGNMENTS. These helpful Mini Roadmaps in each chapter visually show students where they are in the process of completing the chapter’s project.
  • EXPANDED EMPHASIS ON CRITICAL THINKING PREPARES STUDENTS TO SOLVE PROBLEMS. Consider This boxes in each chapter provide thought-provoking questions and problem-solving activities. Chapter-ending Consider This: Plan Ahead boxes and Consider This: Your Turn assignments engage students in critical thinking and problem-solving skills and prompt readers to create their own solutions. In addition, every student assignment ends with a question that requires students’ personal thoughts and opinions.
  • NEW EMPHASIS ON PERSONALIZATION ASKS STUDENTS TO INCLUDE PERSONAL DETAIL IN SOLUTIONS. This personal addition to every chapter project and assignment ensures that each student’s solution is unique.
  • NEW LABS FOCUS ON INTEGRATING CLOUD AND WEB TECHNOLOGIES WITH MICROSOFT® EXCEL. These meaningful hands-on labs highlight important aspects of maximizing Excel and challenge students to use general guidelines to learn and investigate independently.
  • NEW ANALYZE, CORRECT, IMPROVE ASSIGNMENTS DIRECT STUDENTS IN REFINING THEIR SKILLS. In these practical assignments that simulate actual business challenges, students analyze an Excel workbook, correct errors, and make improvements based on the knowledge that they have acquired from the chapter content.
  • NEW APPENDICES OFFER FLEXIBILITY IN MORE ADVANCED ASSIGNMENTS. Now you have the option to include SAM Projects, Capstone Projects, and MOS Certification tasks as part of your course, depending on your students’ interests and needs.

Components

Teacher Components

  • MindTap® Computing, 1 term (6 months) Instant Access for Freund/Jones/Starks' Microsoft® Excel® 2013, Enhanced: Comprehensive  (ISBN-10: 1305578724 | ISBN-13: 9781305578722)
    MindTap™ Computing for Freund/Jones/Starks’ Microsoft® Excel® 2013, Enhanced: Comprehensive 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.
    Price = 153.00
  • LMS Integrated for MindTap® Computing, 1 term (6 months) Instant Access  (ISBN-10: 1305578740 | ISBN-13: 9781305578746)
    A unique access code provides your students with seamless access to their MindTap™ Computing resources from within your campus Learning Management System. Students are prompted to enter the access code the first time that they click on a link in your course that includes Cengage content.
    Price = 153.00
  • LMS Integrated for MindTap® Computing, 2 terms (12 months) Instant Access  (ISBN-10: 1305869206 | ISBN-13: 9781305869202)
    Introduce students to the latest advantages that Microsoft® Excel has to offer with this new book in the next generation of the Shelly Cashman Series®. For three decades, the Shelly Cashman Series® has effectively introduced essential computer skills to millions of students. ENHANCED MICROSOFT® EXCEL 2013: COMPREHENSIVE continues this history of innovation with enhanced pedagogy to accommodate the varied learning styles of today’s students. New features are specifically designed to engage students, improve retention, and prepare them for future success. A trademark step-by-step, screen-by-screen approach now encourages students to expand their understanding of Excel 2013 through experimentation, critical thought, and personalization. New labs integrate cloud and web technologies with Excel while other enhancements ensure this Shelly Cashman Series® book delivers the most effective Excel introduction for your students.
    Price = 229.00
  • SAM 2013 Assessment, Training and Projects with MindTap Reader for Enhanced Microsoft® Excel® 2013: Comprehensive v3.0 Multi-Term Instant Access  (ISBN-10: 1305675622 | ISBN-13: 9781305675629)
    Skills Assessment Manager (SAM) trains and tests essential Microsoft® Office and computer concepts skills. Students engage in a hands-on environment, then apply their skills to real-world applications. SAM’s auto-graded assignments and flexible reporting tools saves you time and energy.
    Price = 153.00
  • LMS Integrated for SAM 2013 Assessment, Training, and Projects with MindTap Reader, 1 term Instant Access  (ISBN-10: 1305675630 | ISBN-13: 9781305675636)
    Price = 153.00

Student Supplements

  • MindTap® Computing, 1 term (6 months) Instant Access for Freund/Jones/Starks' Microsoft® Excel® 2013, Enhanced: Comprehensive  (ISBN-10: 1305578724 | ISBN-13: 9781305578722)
    As a student using MindTap Computing for Freund/Jones/Starks’ Microsoft® Excel® 2013, Enhanced: Comprehensive 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 Microsoft Excel 2013 course. Master the most important information with built-in study tools such as SAM Projects that help students stay organized and use their time efficiently.
    Price = 153.00
  • LMS Integrated for MindTap® Computing, 1 term (6 months) Instant Access  (ISBN-10: 1305578740 | ISBN-13: 9781305578746)
    A unique access code provides you with seamless access to your MindTap™ Computing resources from within your campus Learning Management System. You are prompted to enter the access code the first time that you click on a link in your course that includes Cengage content.
    Price = 153.00
  • LMS Integrated for MindTap® Computing, 2 terms (12 months) Instant Access  (ISBN-10: 1305869206 | ISBN-13: 9781305869202)
    Discover the latest advantages that Microsoft® Excel has to offer with this new book in the next generation of the Shelly Cashman Series®. For three decades, the Shelly Cashman Series® has effectively introduced essential computer skills to millions of students like you. ENHANCED MICROSOFT® EXCEL 2013: COMPREHENSIVE continues the history of innovation with new features that accommodate your learning style. Specially refined learning tools help improve your retention and prepare you for future success while new labs integrate cloud and web technologies with Excel. This book’s trademark step-by-step, screen-by-screen approach now guides you in expanding your understanding of Microsoft® Excel 2013through experimentation, critical thought, and personalization. Trust ENHANCED MICROSOFT® EXCEL 2013: COMPREHENSIVE to help you succeed with today’s most effective educational approach.
    Price = 229.00
  • SAM 2013 Assessment, Training and Projects with MindTap Reader for Enhanced Microsoft® Excel® 2013: Comprehensive v3.0 Multi-Term Instant Access  (ISBN-10: 1305675622 | ISBN-13: 9781305675629)
    Skills Assessment Manager (SAM) is the top online training resource for Microsoft® Office suites. With automatic feedback on assignments and a personalized study plan, SAM helps you stay on track for improved grades. SAM has all your course content in one easy location, offering an intuitive homepage which ensures you always get where you need to go. SAM training and assessments simulate the real MS Office environment preparing you for more workplace success.
    Price = 153.00
  • LMS Integrated for SAM 2013 Assessment, Training, and Projects with MindTap Reader, 1 term Instant Access  (ISBN-10: 1305675630 | ISBN-13: 9781305675636)
    Price = 153.00