Higher Education

Microsoft® Excel® 2013: Comprehensive, 1st Edition

  • Steven M. Freund University of Central Florida
  • Mali Jones
  • Joy L. Starks Indiana University, Purdue University at Indianapolis
  • ISBN-10: 1285168437  |  ISBN-13: 9781285168432
  • 888 Pages
  • Previous Editions: 2011, 2008, 2004
  • © 2014 | Published
  • College Bookstore Wholesale Price = $144.75
  • Newer Edition Available

About

Overview

Introduce your students to the latest that Microsoft Office has to offer with the new generation of Shelly Cashman Series® books! For the past three decades, the Shelly Cashman Series® has effectively introduced computer skills to millions of students. With Microsoft Excel 2013, we're continuing our history of innovation by enhancing our proven pedagogy to reflect the learning styles of today's students. In this text you'll find features that are specifically designed to engage students, improve retention, and prepare them for future success. Our trademark step-by-step, screen-by-screen approach now encourages students to expand their understanding of Microsoft Excel 2013 through experimentation, critical thought, and personalization. With these enhancements and more, the Shelly Cashman Series® continues to deliver the most effective educational materials for you and your students.

Additional Product Information

Features and Benefits

  • Step-by-step, screen by screen approach presents students with explanatory and navigational information when they need to know it, and addresses all learning styles to help students retain and apply skills in their personal and professional lives.
  • Proven pedagogy with an emphasis on project planning frames each chapter around a practical problem to be solved, and encourages critical thinking about how to proceed at various points in the chapter.
  • Extensive end-of-chapter activities provide a variety of reinforcement opportunities for students to apply and expand their skills.

Table of Contents

Office 2013 and Windows 8: Essential Concepts and Skills.
Office 365 Essentials.
1. Creating a Worksheet and a Chart.
2. Formulas, Functions, and Formatting.
3. Working with Large Worksheets, Charting, and What-If Analysis.
4. Working with Multiple Worksheets and Workbooks.
5. Financial Functions, Data Tables, and Amortization Schedules.
6. Creating, Sorting, and Querying a Table.
7. Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet.
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.
Certification Appendix.
Index.
Quick Reference.
Important Notes for Windows 7 Users.

What's New

  • Now, when students complete projects they are told WHY each step in the process is necessary, in addition to being told what they will be doing and how to accomplish each task.
  • New mini-roadmaps are provided throughout each chapter, visually showing students where they are in the process of completing the chapter project.
  • Critical thinking has been expanded throughout the text. Consider This boxes throughout 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 to create their own solutions. Plus, every student assignment ends with a question that requires students' thoughts and opinions.
  • New emphasis on personalization asks students to include a personal detail in their solutions to every chapter project and assignment, ensuring that each student solution will be unique.
  • New lab on integrating Cloud and Web technologies with Microsoft Excel challenges students to use general guidelines to learn and investigate independently.
  • New Analyze, Correct, Improve assignment requires students to analyze an Excel workbook, correct errors, and make improvements based on knowledge acquired from the chapter content.
  • Chapter topic redistribution offers concise chapters that ensure complete skill coverage.

Learning Resource Bundles

Choose the textbook packaged with the resources that best meet your course and student needs. Contact your Learning Consultant for more information.

ePack: Text + SAM 2013 Assessment, Training and Projects with MindTap Reader + Microsoft Office 365 180-Day Trial Instant Access

ISBN-10: 1305136101  | ISBN-13: 9781305136106

List Price = $249.95  | CengageBrain Price = $249.95  | College Bookstore Wholesale Price = $187.46

This Bundle Includes:

  • Microsoft® Excel® 2013: Comprehensive
    List Price = $192.95  | CengageBrain Price = $192.95  | College Bookstore Wholesale Price = $144.75
  • SAM 2013 Assessment, Training and Projects with MindTap Reader
    List Price = $146.00  | CengageBrain Price = $146.00  | College Bookstore Wholesale Price = $146.00
  • Microsoft Office 365 180-Day Trial, 1 term (6 months) Instant Access
    List Price = $18.00  | College Bookstore Wholesale Price = $18.00


Bundle: Microsoft® Excel® 2013: Comprehensive + SAM 2013 Assessment, Training, and Projects v1.0 Printed Access Card + Microsoft Office 365 180-Day Trial Printed Access Card

ISBN-10:  128593041X  | ISBN-13:  9781285930411

List Price = $239.95  | College Bookstore Wholesale Price = $179.96

This Bundle Includes:

  • Microsoft® Excel® 2013: Comprehensive
    List Price = $192.95  | CengageBrain Price = $192.95  | College Bookstore Wholesale Price = $144.75
  • SAM 2013 Assessment, Training, and Projects v1.0 Multi-Term Printed Access Card
    List Price = $132.00  | College Bookstore Wholesale Price = $99.00
  • Microsoft Office 365 180-Day Trial, 1 term (6 months) Printed Access Card
    List Price = $18.00  | College Bookstore Wholesale Price = $18.00


ePack: Text + SAM 2013 Assessment, Training, and Projects v1.0 Instant Access Code + Microsoft Office 365 180-Day Trial Instant Access

ISBN-10:  1305249925  | ISBN-13:  9781305249929

List Price = $239.95  | CengageBrain Price = $239.95  | College Bookstore Wholesale Price = $179.96

This Bundle Includes:

  • Microsoft® Excel® 2013: Comprehensive
    List Price = $192.95  | CengageBrain Price = $192.95  | College Bookstore Wholesale Price = $144.75
  • SAM 2013 Assessment, Training, and Projects v1.0 Multi-Term Instant Access
    List Price = $132.00  | CengageBrain Price = $132.00  | College Bookstore Wholesale Price = $132.00
  • Microsoft Office 365 180-Day Trial, 1 term (6 months) Instant Access
    List Price = $18.00  | College Bookstore Wholesale Price = $18.00


ePack: Text + SAM 2013 Assessment, Training, and Projects v1.0 Instant Access Code

ISBN-10:  1305249240  | ISBN-13:  9781305249240

List Price = $227.95  | CengageBrain Price = $227.95  | College Bookstore Wholesale Price = $170.96

This Bundle Includes:

  • Microsoft® Excel® 2013: Comprehensive
    List Price = $192.95  | CengageBrain Price = $192.95  | College Bookstore Wholesale Price = $144.75
  • SAM 2013 Assessment, Training, and Projects v1.0 Multi-Term Instant Access
    List Price = $132.00  | CengageBrain Price = $132.00  | College Bookstore Wholesale Price = $132.00


ePack: Text + MindLink for SAM 2013 Assessment, Training, and Projects with MindTap Reader Instant Access

ISBN-10:  1305427092  | ISBN-13:  9781305427099

List Price = $236.95  | CengageBrain Price = $236.95  | College Bookstore Wholesale Price = $177.71

This Bundle Includes:

  • Microsoft® Excel® 2013: Comprehensive
    List Price = $192.95  | CengageBrain Price = $192.95  | College Bookstore Wholesale Price = $144.75
  • LMS Integrated for SAM 2013 Assessment, Training, and Projects with MindTap Reader, 1 term Instant Access
    List Price = $146.00  | CengageBrain Price = $146.00  | College Bookstore Wholesale Price = $146.00


ePack: Text + SAM 2013 Assessment, Training and Projects with MindTap Reader Instant Access

ISBN-10:  130541733X  | ISBN-13:  9781305417335

List Price = $236.95  | CengageBrain Price = $236.95  | College Bookstore Wholesale Price = $177.71

This Bundle Includes:

  • Microsoft® Excel® 2013: Comprehensive
    List Price = $192.95  | CengageBrain Price = $192.95  | College Bookstore Wholesale Price = $144.75
  • SAM 2013 Assessment, Training and Projects with MindTap Reader
    List Price = $146.00  | CengageBrain Price = $146.00  | College Bookstore Wholesale Price = $146.00


ePack: Text + SAM 2013 Assessment, Training, and Projects v1.0 Instant Access Code

ISBN-10:  1305587421  | ISBN-13:  9781305587427

List Price = $227.95  | CengageBrain Price = $227.95  | College Bookstore Wholesale Price = $170.96

This Bundle Includes:

  • Microsoft® Excel® 2013: Comprehensive
    List Price = $192.95  | CengageBrain Price = $192.95  | College Bookstore Wholesale Price = $144.75
  • SAM 2013 Assessment, Training, and Projects v1.0 Multi-Term Instant Access
    List Price = $132.00  | CengageBrain Price = $132.00  | College Bookstore Wholesale Price = $132.00


ePack: Microsoft® Excel® 2013: Comprehensive + SAM 2013 Assessment, Training, and Projects v1.0 Instant Access Code + Microsoft Office 365 180-Day Trial Instant Access

ISBN-10:  1305587774  | ISBN-13:  9781305587779

List Price = $239.95  | CengageBrain Price = $239.95  | College Bookstore Wholesale Price = $179.96

This Bundle Includes:

  • Microsoft® Excel® 2013: Comprehensive
    List Price = $192.95  | CengageBrain Price = $192.95  | College Bookstore Wholesale Price = $144.75
  • SAM 2013 Assessment, Training, and Projects v1.0 Multi-Term Instant Access
    List Price = $132.00  | CengageBrain Price = $132.00  | College Bookstore Wholesale Price = $132.00
  • Microsoft Office 365 180-Day Trial, 1 term (6 months) Instant Access
    List Price = $18.00  | College Bookstore Wholesale Price = $18.00


ePack: Microsoft® Excel® 2013: Comprehensive + SAM 2013 Assessment, Training, and Projects v1.0 Instant Access Code + Microsoft Office 365 180-Day Trial Instant Access + Microsoft® Windows 7: Essential

ISBN-10:  1305625714  | ISBN-13:  9781305625716

List Price = $264.95  | CengageBrain Price = $264.95  | College Bookstore Wholesale Price = $198.71

This Bundle Includes:

  • Microsoft® Excel® 2013: Comprehensive
    List Price = $192.95  | CengageBrain Price = $192.95  | College Bookstore Wholesale Price = $144.75
  • SAM 2013 Assessment, Training, and Projects v1.0 Multi-Term Instant Access
    List Price = $132.00  | CengageBrain Price = $132.00  | College Bookstore Wholesale Price = $132.00
  • Microsoft Office 365 180-Day Trial, 1 term (6 months) Instant Access
    List Price = $18.00  | College Bookstore Wholesale Price = $18.00
  • Microsoft® Windows 7: Essential
    List Price = $35.95  | CengageBrain Price = $35.95  | College Bookstore Wholesale Price = $27.00


Bundle: Microsoft® Excel® 2013: Comprehensive + SAM 2013 Projects v1.0 Printed Access Card + MOS 2007/2010 Paper Exam Voucher

ISBN-10:  1305140672  | ISBN-13:  9781305140677

List Price = $245.95  | CengageBrain Price = $245.95  | College Bookstore Wholesale Price = $184.46

This Bundle Includes:

  • Microsoft® Excel® 2013: Comprehensive
    List Price = $192.95  | CengageBrain Price = $192.95  | College Bookstore Wholesale Price = $144.75
  • SAM 2013 Projects v1.0 Multi-Term Printed Access Card
    List Price = $73.00  | College Bookstore Wholesale Price = $54.75
  • MOS 2007/2010 Paper Exam Voucher
    List Price = $84.95  | CengageBrain Price = $84.95  | College Bookstore Wholesale Price = $67.50


Bundle: Text + SAM with MindTap Reader Printed Access Card

ISBN-10:  1305130391 | ISBN-13:  9781305130395

List Price = $236.95  | CengageBrain Price = $236.95  | College Bookstore Wholesale Price = $177.71

This Bundle Includes:

  • Microsoft® Excel® 2013: Comprehensive
    List Price = $192.95  | CengageBrain Price = $192.95  | College Bookstore Wholesale Price = $144.75
  • SAM 2013 with MindTap Reader Printed Access Card
    List Price = $146.00  | College Bookstore Wholesale Price = $109.50


Supplements

All supplements have been updated in coordination with the main title. Select the main title's "About" tab, then select "What's New" for updates specific to title's edition.

For more information about these supplements, or to obtain them, contact your Learning Consultant.

Instructor Supplements

Instructor's Resource CD-ROM  (ISBN-10: 128516685X | ISBN-13: 9781285166858)

Go beyond the book with Instructor Resources to help you make the most of your classroom and lessons. Here you will find additional information on how to use our text as well as teaching and testing aids.

Review Pack  (ISBN-10: 1285166663 | ISBN-13: 9781285166667)

CD containing all Microsoft Office 2013 student data files.

List Price = $17.95  | CengageBrain Price = $17.95  | College Bookstore Wholesale Price = $13.25

Student Supplements

Review Pack  (ISBN-10: 1285166663 | ISBN-13: 9781285166667)

CD containing all Microsoft Office 2013 student data files.

List Price = $17.95  | CengageBrain Price = $17.95  | College Bookstore Wholesale Price = $13.25

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

List Price = $146.00  | CengageBrain Price = $146.00  | College Bookstore Wholesale Price = $146.00

SAM 2013 Assessment, Training and Projects with MindTap Reader  (ISBN-10: 1285752082 | ISBN-13: 9781285752082)

Go from Office user to Office expert SAM –Skills Assessment Manager – is the top online training resource for Microsoft Office suites. No matter what your skill level, SAM helps you learn with confidence so you have a better chance to make better grades. Navigate easily from day one SAM has all your course content in one easy location, offering an intuitive homepage which ensures you always get where you need to go. See how Office is used in the real world SAM training and assessments simulate the real MS Office environment, which will prepare you for more workplace success. Set yourself up for better grades Automatic feedback on assignments and a personalized study plan help you stay on track for improved grades. Student Testimonials: “My course experience using SAM has been great. It has actually helped me more in class because it lets us do an unlimited amount of training. If we do need help with something, we can just log onto SAM and do it.” - Student Westchester Community College “[SAM] told me all of the mistakes I made, and when I saw the mistakes, it allowed me to use critical thinking of what I could do to make that problem 100% correct.” - Student Hutchinson Community College CTA: Ask your instructor about SAM for this course. Visit us online: sam.cengage.com

List Price = $146.00  | CengageBrain Price = $146.00  | College Bookstore Wholesale Price = $146.00

SAM 2013 with MindTap Reader Printed Access Card  (ISBN-10: 1285752074 | ISBN-13: 9781285752075)

Go from Office user to Office expert SAM –Skills Assessment Manager – is the top online training resource for Microsoft Office suites. No matter what your skill level, SAM helps you learn with confidence so you have a better chance to make better grades. Navigate easily from day one SAM has all your course content in one easy location, offering an intuitive homepage which ensures you always get where you need to go. See how Office is used in the real world SAM training and assessments simulate the real MS Office environment, which will prepare you for more workplace success. Set yourself up for better grades Automatic feedback on assignments and a personalized study plan help you stay on track for improved grades. Student Testimonials: “My course experience using SAM has been great. It has actually helped me more in class because it lets us do an unlimited amount of training. If we do need help with something, we can just log onto SAM and do it.” - Student Westchester Community College “[SAM] told me all of the mistakes I made, and when I saw the mistakes, it allowed me to use critical thinking of what I could do to make that problem 100% correct.” - Student Hutchinson Community College CTA: Ask your instructor about SAM for this course. Visit us online: sam.cengage.com

List Price = $146.00  | College Bookstore Wholesale Price = $109.50

Meet the Author

Author Bio

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.