Shelly Cashman Series® Microsoft® Office 365 & Excel 2016: Comprehensive, Loose-leaf Version 1st Edition
Steven M. Freund | Joy L. Starks | Eric Schmieder
ISBN-13: 9781337251051 | ISBN-10: 1337251054
© 2017 | Published |  816  Pages

Binding Format:

Loose-leaf or Post Bound Item
US $118.95
Sign In to turn on 1-Click ordering
For quantity discount, Contact your Representative

Introduce your students to the latest advancements that Microsoft® Office and Excel 2016 have to offer with MICROSOFT® OFFICE 365 & EXCEL 2016: COMPREHENSIVE -- the new edition in the acclaimed Shelly Cashman Series®. For more than three decades, the Shelly Cashman Series® has effectively introduced computer skills to millions. MICROSOFT® OFFICE 365 & EXCEL 2016: COMPREHENSIVE continues the Series’ strong history of innovation with a hallmark learning approach now enhanced to address the varied learning styles of today’s students. A trademark, step-by-step, screen-by-screen approach provides a thorough understanding of Microsoft® Excel 2016 through experimentation, critical thought, and personalization. This new edition and accompanying resources deliver effective educational materials specifically designed to engage readers, improve retention, and prepare students for future success in working with all aspects of Excel 2016.

  • Front Matter.
    Microsoft’s New Productivity Tools for School and Work.
    Office 2016 and Windows 10: Essential Concepts and Skills.
    1. Creating a Worksheet and a Chart.
    2. Formulas, Functions, and Formatting.
    3. Working with Large Worksheets, Charting, and What-If Analysis.
    4. Financial Functions, Data Tables, and Amortization Schedules.
    5. Working with Multiple Worksheets and Workbooks.
    6. Creating, Sorting, and Querying a Table.
    7. Creating Templates, Importing Data, and Working with SmartArt, Images, and Screenshots.
    8. Working with Trendlines, Pivot Table Reports, PivotChart Reports, and Slicers.
    9. Formula Auditing, Data Validation, and Complex Problem Solving.
    10. Using Macros and Visual Basic for Applications (VBA) with Excel.
    11. Collaboration Features for Workbooks.

    • STEP-BY-STEP, SCREEN-BY-SCREEN APPROACH EFFECTIVELY INTRODUCES KEY EXCEL SKILLS. This proven visual approach presents students with explanatory and navigational information specifically when they need to know it in order to master Excel 2016. The book addresses the needs of all learning styles to help students retain and apply skills in their personal and professional lives.
    • PROVEN PEDAGOGY EMPHASIZES PROJECT PLANNING. This project planning approach frames the explanations within each module around a practical problem that students learn to solve. This effective introduction encourages critical thinking as students make decisions on how to proceed at various key points within the module.
    • EXTENSIVE END-OF-MODULE ACTIVITIES REINFORCE A QUANTITY OF EXCEL SKILLS AND APPLICATIONS. These proven, class-tested activities provide a variety of reinforcement opportunities for students to apply and expand their thorough understanding of Excel 2016 skills.
    • CONCISE, REORGANIZED CHAPTERS ENSURE COMPLETE COVERAGE OF SKILLS. The topics with this edition’s modules are presented in brief, understandable sections that have been carefully arranged to equip your students with thorough mastery of Excel 2016.
    • MODULE 1 HELPS STUDENTS PUT NEW EXCEL STRENGTHS INTO PRACTICE. An updated, practical project teaches students how to create a personal budget and covers chart types that are new to Excel 2016.
    • MODULE 2 PROVIDES ENHANCED COVERAGE OF NEW EXCEL FUNCTIONS. Your students learn to take advantage of the Flash Fill feature and additional Excel functions, including the PRODUCT function.
    • MODULE 3 COVERS ACCESSIBILITY AND OTHER KEY FEATURES IN EXCEL. Your students learn to use the new Smart Lookup feature with the Insights panel and become equipped to maximize other tools.
    • UPDATED PROJECT IN MODULE 4 SHOWS STUDENTS HOW TO CREATE A MORTGAGE PAYMENT CALCULATOR. Students learn from rewritten step-by-step project instructions that clearly divide complex tasks into smaller, easy-to-understand steps.
    • MODULE 5 NOW INTRODUCES THE EXTENDED BAR AND PIE CHART FORMATTING. This module begins the discussion on extended bar and pie chart formatting, guiding students in the best methods for displaying data.
    • MODULE 6 HIGHLIGHTS ADVANCED USE OF THE QUICK ANALYSIS GALLERY. Analyzing data is now easier than ever in Excel 2016 as students learn how to best use this contextual tool and its single-click access.
    • MODULE 7 INTRODUCES TREEMAP CHARTS AND TEXT EFFECTS. Students learn to use this hierarchical view of data that makes it easy to spot patterns.
    • STUDENTS LEARN MORE ADVANCED SKILLS RELATED TO FORMATTING THE EXTENDED BAR AND PIE CHART. Module 8 takes your students’ skills to the next level as they learn to most effectively display data.
    • EXPANDED MODULES 9-11 EMPHASIZE ADDITIONAL EXCEL 2016 FEATURES. These modules are thoroughly updated in this edition to emphasize advanced Excel features and new advantages that Excel 2016 offers to users.
For more information about these supplements, or to obtain them, contact your Learning Consultant

  • Instructor’s Website for Freund/Starks/Schmieder’s Shelly Cashman Series® Microsoft® Office 365 & Excel 2016: Comprehensive
    ISBN-10: 1305870735 | ISBN-13:9781305870734
    List Price = 151.95
    Find everything you need for your course all in one place. All instructor resources are available instantly through the password-protected Instructor Companion Website, including the Instructor’s Manual, Test Bank and PowerPoint® slides.
    LMS Integrated MindTap Computing, 1 term (6 months) Instant Access for Freund/Starks/Schmieder’s Shelly Cashman Series® Microsoft® Office 365 & Excel 2016: Comprehensive
    ISBN-10: 1305870778 | ISBN-13:9781305870772
    List Price = 118.00
    LMS Integrated MindTap® Computing, 1 term (6 months) Instant Access
    MindTap Computing, 1 term (6 months) Instant Access for Freund/Starks/Schmieder's Shelly Cashman Series® Microsoft® Office 365 & Excel 2016: Comprehensive
    ISBN-10: 1305870751 | ISBN-13:9781305870758
    List Price = 118.00
    MindTap Computing for Shelly Cashman Series® Microsoft® Office 365 & Excel 2016: Comprehensive
    MindTap Computing, 2 terms (12 months) Instant Access for Freund/Starks/Schmieder's Shelly Cashman Series® Microsoft® Office 365 & Excel 2016: Comprehensive
    ISBN-10: 1305882911 | ISBN-13:9781305882911
    List Price = 178.00
    MindTap Computing for Shelly Cashman Series® Microsoft® Office 365 & Excel 2016: Comprehensive
    SAM 365 & 2016 Assessment, Training, and Projects Instant Access with Access to 1 MindTap Reader for 6 months
    ISBN-10: 133711393X | ISBN-13:9781337113939
    List Price = 118.00
    SAM 365 & 2016 with Access to 1 MindTap Reader
    LMS Integrated SAM 365 & 2016 Assessments, Trainings, and Projects with 1 MindTap Reader, (6 months) Instant Access
    ISBN-10: 1337114014 | ISBN-13:9781337114011
    List Price = 118.00
    Cengage Learning has partnered with leading LMS providers to deliver seamless access to our premier learning solutions from the environment that is most comfortable and familiar to you and your students. This allows students get up and running quickly and for you to enhance and customize your course with learning activities that will elevate thinking and improve course outcomes.

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

    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.

    For over 15 years, Mr. Schmieder has served as a computer technology instructor in adjunct and full-time capacities in curriculum instruction, corporate training, continuing education, economic and workforce development, professional development, small business, and webmaster certificate programs throughout North Carolina. His classroom instruction has served students at NC State University and many schools in the NC Community College System. He is a member of the NC Computer Instructors Association (NCCIA), NC Community College Faculty Association (NCCCFA), Textbook and Academic Authors Association (TAA), and US Distance Learning Association (USDLA). He holds certifications as a Microsoft Certified Trainer and Microsoft Office Master Specialist and is a regular presenter at local and national conferences.