Higher Education

Microsoft® Excel® 2010: Complete, 1st Edition

  • Gary B. Shelly
  • Jeffrey J. Quasney
  • ISBN-10: 0538750057  |  ISBN-13: 9780538750059
  • 632 Pages
  • Previous Editions: 2008
  • © 2011 | Published
  • College Bookstore Wholesale Price = $114.25
  • Newer Edition Available
  *Why an online review copy?
  • It's the greener, leaner way to review! An online copy cuts down on paper and on time. Reduce the wait (and the weight) of printed texts. Your online copy arrives instantly, and you can review it anytime from your computer or favorite mobile device.

If you prefer a print copy to review, please contact your representative.

About

Overview

Introduce your students to the new generation of Microsoft Office 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 Excel 2010, we're continuing our history of innovation by enhancing our proven pedagogy to reflect the learning styles of today's students. In MICROSOFT EXCEL 2010: COMPLETE 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 the Excel 2010 software through experimentation, exploration, and planning ahead. End of chapter exercises prepare students to become more capable software users by requiring them to use critical thinking and problem-solving skills to create real-life documents giving them skills to use in both their personal and professional lives.

Additional Product Information

Features and Benefits

  • Gives students an introductory presentation of Excel 2010, including new features of the software, using the highly-successful Shelly Cashman Series pedagogy.
  • A step-by-step, screen-by-screen approach allows students to successfully learn and retain information to be used in their personal and professional lives.
  • New opening chapter presents essential Office 2010 and Windows® 7 skills preventing repetitive coverage of basic skills in the applications chapters and providing students with a strong base for further learning.

Table of Contents

Office 2010 and Windows 7: Essential Concepts and Skills.
1. Creating a Worksheet and an Embedded Chart.
2. Formulas, Functions, and Formatting.
3. What-If Analysis, Charting, and Working with Large Worksheets.
4. Financial Functions, Data Tables, and Amortization Schedules.
5. Creating, Sorting, and Querying a Table.
6. Working with Multiple Worksheets and Workbooks.
7. Creating Templates, Importing Data, and Working with SmartArt, Images, and Screen Shots
Appendices.
A: Project Planning Guidelines.
B: Publishing Office 2010 Web Pages Online.
C: Saving to the Web Using Windows Live SkyDrive.
Index/Quick Reference.

What's New

  • Overviews new features including Slicers and Sparklines which are two features that are new to Excel 2010, and help users visualize data more clearly.
  • An enhanced layout including a brand new introduction to Windows 7 and Introduction to Office chapter provides students with presentation of the latest in the Windows operating system and the Office suite giving them a strong base for further learning.
  • New pedagogical elements enrich material and create an accessible and user-friendly approach allowing easy navigation through the skills in each chapter.
  • New opening chapter presents essential Office 2010 and Windows® 7 skills preventing repetitive coverage of basic skills in the applications chapters and providing students with a strong base for further learning.

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.

Bundle: Discovering Computers - Fundamentals 2011 Edition, 7th + Microsoft® Access 2010: Complete + Microsoft® Excel® 2010: Complete

ISBN-10: 0495962228  | ISBN-13: 9780495962229

List Price = $497.95  | College Bookstore Wholesale Price = $373.46

This Bundle Includes:

  • Microsoft® Access 2010: Complete
    List Price = $151.95  | College Bookstore Wholesale Price = $114.25
  • Microsoft® Excel® 2010: Complete
    List Price = $151.95  | CengageBrain Price = $151.95  | College Bookstore Wholesale Price = $114.25
  • Discovering Computers - Fundamentals 2011 Edition
    List Price = $233.95  | College Bookstore Wholesale Price = $175.50


ePack: Microsoft® Access 2010: Complete + Microsoft® Excel® 2010: Complete + Microsoft® Word 2010: Introductory + Microsoft® PowerPoint® 2010: Introductory + SAM 2010 Assessment, Training, and Projects 1.5 Instant Access Code

ISBN-10:  1133012620  | ISBN-13:  9781133012627

List Price = $418.95  | College Bookstore Wholesale Price = $314.21

This Bundle Includes:

  • Microsoft® Access 2010: Complete
    List Price = $151.95  | College Bookstore Wholesale Price = $114.25
  • Microsoft® Excel® 2010: Complete
    List Price = $151.95  | CengageBrain Price = $151.95  | College Bookstore Wholesale Price = $114.25
  • Microsoft® Word 2010: Introductory
    List Price = $91.95  | CengageBrain Price = $91.95  | College Bookstore Wholesale Price = $69.25
  • Microsoft® PowerPoint® 2010: Introductory
    List Price = $91.95  | CengageBrain Price = $91.95  | College Bookstore Wholesale Price = $69.25
  • SAM 2010 Assessment, Training, and Projects 1.5, 1 term (6 months) Instant Access
    List Price = $138.00  | College Bookstore Wholesale Price = $138.00


Bundle: Microsoft® Excel® 2010: Complete + Microsoft® Office 2010 180-day Subscription + SAM 2010 Assessment, Training, and Projects v2.0 Printed Access Card

ISBN-10:  1133073220  | ISBN-13:  9781133073222

List Price = $214.95  | College Bookstore Wholesale Price = $161.21

This Bundle Includes:

  • Microsoft® Excel® 2010: Complete
    List Price = $151.95  | CengageBrain Price = $151.95  | College Bookstore Wholesale Price = $114.25
  • Microsoft® Office 2010 180-day Subscription
    List Price = $17.75  | College Bookstore Wholesale Price = $17.75
  • SAM 2010 Assessment, Training, and Projects v2.0 Printed Access Card
    List Price = $138.00  | College Bookstore Wholesale Price = $103.50


ePack: Microsoft® Excel® 2010: Complete + SAM 2010 Assessment and Training V2.0 Instant Access Code

ISBN-10:  1133530281  | ISBN-13:  9781133530282

List Price = $185.95  | CengageBrain Price = $185.95  | College Bookstore Wholesale Price = $139.46

This Bundle Includes:

  • Microsoft® Excel® 2010: Complete
    List Price = $151.95  | CengageBrain Price = $151.95  | College Bookstore Wholesale Price = $114.25
  • SAM 2010 Assessment and Training v2.0 Instant Access
    List Price = $113.00  | CengageBrain Price = $113.00  | College Bookstore Wholesale Price = $113.00


Bundle: Microsoft® Access 2010: Complete + Microsoft® Excel® 2010: Complete + SAM 2010 Assessment, Training, and Projects v2.0 Printed Access Card + Computer Concepts CourseMate with eBook Printed Access Card

ISBN-10:  0495961795  | ISBN-13:  9780495961796

List Price = $374.95  | College Bookstore Wholesale Price = $281.21

This Bundle Includes:

  • Microsoft® Access 2010: Complete
    List Price = $151.95  | College Bookstore Wholesale Price = $114.25
  • Microsoft® Excel® 2010: Complete
    List Price = $151.95  | CengageBrain Price = $151.95  | College Bookstore Wholesale Price = $114.25
  • SAM 2010 Assessment, Training, and Projects v2.0 Printed Access Card
    List Price = $138.00  | College Bookstore Wholesale Price = $103.50
  • Computer Concepts CourseMate with eBook Printed Access Card, Brief
    List Price = $114.00  | College Bookstore Wholesale Price = $85.00


Bundle: Microsoft® Access 2010: Complete + Microsoft® Excel® 2010: Complete + Computer Concepts CourseMate with eBook Printed Access Card, Complete + SAM 2010 Assessment, Training, and Projects v2.0 Printed Access Card + HTML, XHTML, and CSS: Introductory, 6th

ISBN-10:  0495963445  | ISBN-13:  9780495963448

List Price = $471.95  | College Bookstore Wholesale Price = $353.96

This Bundle Includes:

  • Microsoft® Access 2010: Complete
    List Price = $151.95  | College Bookstore Wholesale Price = $114.25
  • Microsoft® Excel® 2010: Complete
    List Price = $151.95  | CengageBrain Price = $151.95  | College Bookstore Wholesale Price = $114.25
  • Computer Concepts CourseMate with eBook Printed Access Card, Complete
    List Price = $162.00  | College Bookstore Wholesale Price = $121.00
  • SAM 2010 Assessment, Training, and Projects v2.0 Printed Access Card
    List Price = $138.00  | College Bookstore Wholesale Price = $103.50
  • HTML, XHTML, and CSS: Introductory
    List Price = $99.95  | CengageBrain Price = $99.95  | College Bookstore Wholesale Price = $75.00


Bundle: Microsoft® Excel® 2010: Complete + Video DVD + Microsoft® Office 2010 180-day Subscription + SAM 2010 Assessment, Training, and Projects v2.0 Printed Access Card

ISBN-10:  1133538649  | ISBN-13:  9781133538646

List Price = $275.95  | CengageBrain Price = $275.95  | College Bookstore Wholesale Price = $206.96

This Bundle Includes:

  • Microsoft® Excel® 2010: Complete
    List Price = $151.95  | CengageBrain Price = $151.95  | College Bookstore Wholesale Price = $114.25
  • Video DVD
    List Price = $86.95  | CengageBrain Price = $86.95  | College Bookstore Wholesale Price = $65.50
  • Microsoft® Office 2010 180-day Subscription
    List Price = $17.75  | College Bookstore Wholesale Price = $17.75
  • SAM 2010 Assessment, Training, and Projects v2.0 Printed Access Card
    List Price = $138.00  | College Bookstore Wholesale Price = $103.50


Bundle: Microsoft® Excel® 2010: Complete + Microsoft® Access 2010: Introductory + SAM 2010 Assessment, Training, and Projects v2.0 Printed Access Card + Microsoft® Office 2010 180-day Subscription

ISBN-10:  1133265278  | ISBN-13:  9781133265276

List Price = $266.95  | College Bookstore Wholesale Price = $200.21

This Bundle Includes:

  • Microsoft® Excel® 2010: Complete
    List Price = $151.95  | CengageBrain Price = $151.95  | College Bookstore Wholesale Price = $114.25
  • SAM 2010 Assessment, Training, and Projects v2.0 Printed Access Card
    List Price = $138.00  | College Bookstore Wholesale Price = $103.50
  • Microsoft® Office 2010 180-day Subscription
    List Price = $17.75  | College Bookstore Wholesale Price = $17.75
  • Microsoft® Access 2010: Introductory
    List Price = $91.95  | College Bookstore Wholesale Price = $69.25


Bundle: Microsoft® Word 2010: Complete + Microsoft® Access 2010: Complete + Microsoft® Excel® 2010: Complete + Microsoft® PowerPoint® 2010: Complete

ISBN-10:  1111984697  | ISBN-13:  9781111984694

List Price = $550.95  | College Bookstore Wholesale Price = $413.21

This Bundle Includes:

  • Microsoft® Word 2010: Complete
    List Price = $151.95  | CengageBrain Price = $151.95  | College Bookstore Wholesale Price = $114.25
  • Microsoft® Excel® 2010: Complete
    List Price = $151.95  | CengageBrain Price = $151.95  | College Bookstore Wholesale Price = $114.25
  • Microsoft® PowerPoint® 2010: Complete
    List Price = $144.95  | College Bookstore Wholesale Price = $108.75
  • Microsoft® Access 2010: Complete
    List Price = $151.95  | College Bookstore Wholesale Price = $114.25


Bundle: Microsoft® Excel® 2010: Complete + SAM 2010 for Microsoft Office 2010 CourseNotes + SAM 2010 Assessment, Training, and Projects v2.0 Printed Access Card

ISBN-10:  1285339746  | ISBN-13:  9781285339740

List Price = $210.95  | College Bookstore Wholesale Price = $158.21

This Bundle Includes:

  • Microsoft® Excel® 2010: Complete
    List Price = $151.95  | CengageBrain Price = $151.95  | College Bookstore Wholesale Price = $114.25
  • SAM 2010 for Microsoft Office 2010 CourseNotes
    List Price = $11.95  | CengageBrain Price = $11.95  | College Bookstore Wholesale Price = $8.75
  • SAM 2010 Assessment, Training, and Projects v2.0 Printed Access Card
    List Price = $138.00  | College Bookstore Wholesale Price = $103.50


ePack: Microsoft® Excel® 2010: Complete + SAM 2010 Assessment, Training, and Projects v2.0 Instant Access Code

ISBN-10:  1285335309  | ISBN-13:  9781285335308

List Price = $202.95  | CengageBrain Price = $202.95  | College Bookstore Wholesale Price = $152.21

This Bundle Includes:

  • Microsoft® Excel® 2010: Complete
    List Price = $151.95  | CengageBrain Price = $151.95  | College Bookstore Wholesale Price = $114.25
  • SAM 2010 Assessment, Training, and Projects v2.0 Instant Access
    List Price = $138.00  | CengageBrain Price = $138.00  | College Bookstore Wholesale Price = $138.00


ePack: Text + SAM 2010 Assessment, Training, and Projects v2.0 Instant Access + Microsoft® Office 2010 180-day Subscription

ISBN-10:  1285924622  | ISBN-13:  9781285924625

List Price = $214.95  | CengageBrain Price = $214.95  | College Bookstore Wholesale Price = $161.21

This Bundle Includes:

  • Microsoft® Excel® 2010: Complete
    List Price = $151.95  | CengageBrain Price = $151.95  | College Bookstore Wholesale Price = $114.25
  • SAM 2010 Assessment, Training, and Projects v2.0 Instant Access
    List Price = $138.00  | CengageBrain Price = $138.00  | College Bookstore Wholesale Price = $138.00
  • Microsoft® Office 2010 180-day Subscription
    List Price = $17.75  | College Bookstore Wholesale Price = $17.75


Bundle: Microsoft® Access 2010: Complete + Microsoft® Excel® 2010: Complete

ISBN-10:  1133219624  | ISBN-13:  9781133219620

List Price = $274.95  | College Bookstore Wholesale Price = $206.21

This Bundle Includes:

  • Microsoft® Access 2010: Complete
    List Price = $151.95  | College Bookstore Wholesale Price = $114.25
  • Microsoft® Excel® 2010: Complete
    List Price = $151.95  | CengageBrain Price = $151.95  | College Bookstore Wholesale Price = $114.25


ePack: Microsoft® Excel® 2010, Complete + SAM 2010 Assessment, Training, and Projects v2.0 Instant Access 1 term (6 months) + Microsoft® Office 2010 180-day Subscription

ISBN-10:  1305604687  | ISBN-13:  9781305604681

List Price = $214.95  | College Bookstore Wholesale Price = $161.21

This Bundle Includes:

  • Microsoft® Excel® 2010: Complete
    List Price = $151.95  | CengageBrain Price = $151.95  | College Bookstore Wholesale Price = $114.25
  • Microsoft® Office 2010 180-day Subscription
    List Price = $17.75  | College Bookstore Wholesale Price = $17.75
  • SAM 2010 Assessment, Training, and Projects v2.0 Instant Access
    List Price = $138.00  | CengageBrain Price = $138.00  | College Bookstore Wholesale Price = $138.00


Microsoft® Excel® 2010, Complete + Microsoft® Access 2010, Introductory + SAM 2010 Assessment, Training, and Projects v2.0 Instant Access 1 term (6 months) + Microsoft® Office 2010 180-day Subscription

ISBN-10:  1305605071  | ISBN-13:  9781305605077

List Price = $251.95  | College Bookstore Wholesale Price = $188.96

This Bundle Includes:

  • Microsoft® Excel® 2010: Complete
    List Price = $151.95  | CengageBrain Price = $151.95  | College Bookstore Wholesale Price = $114.25
  • Microsoft® Office 2010 180-day Subscription
    List Price = $17.75  | College Bookstore Wholesale Price = $17.75
  • Microsoft® Access 2010: Introductory
    List Price = $91.95  | College Bookstore Wholesale Price = $69.25
  • SAM 2010 Assessment, Training, and Projects v2.0 Instant Access
    List Price = $138.00  | CengageBrain Price = $138.00  | College Bookstore Wholesale Price = $138.00


Microsoft® Excel® 2010: Complete + SAM 2010 for Microsoft Office 2010 CourseNotes + SAM 2010 Assessment, Training, and Projects v2.0 Instant Access 1 term (6 months)

ISBN-10:  1305605810 | ISBN-13:  9781305605817

List Price = $210.95  | CengageBrain Price = $210.95  | College Bookstore Wholesale Price = $158.21

This Bundle Includes:

  • Microsoft® Excel® 2010: Complete
    List Price = $151.95  | CengageBrain Price = $151.95  | College Bookstore Wholesale Price = $114.25
  • SAM 2010 for Microsoft Office 2010 CourseNotes
    List Price = $11.95  | CengageBrain Price = $11.95  | College Bookstore Wholesale Price = $8.75
  • SAM 2010 Assessment, Training, and Projects v2.0 Instant Access
    List Price = $138.00  | CengageBrain Price = $138.00  | College Bookstore Wholesale Price = $138.00


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 Resource CD-ROM  (ISBN-10: 1439078505 | ISBN-13: 9781439078501)

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.

Microsoft® Office 2010 180-day Subscription  (ISBN-10: 1111747970 | ISBN-13: 9781111747978)

If you teach Microsoft Office 2010, consider bundling your order with this trial software! If your students haven't upgraded from Office 2007 or don't have Microsoft Office at all, this CD allows students to use Office 2010 on their personal computers for up to 180 days! This trial software can only be purchased in a bundle (it cannot be purchased alone). Contact your sales representative for more information.

List Price = $17.75  | College Bookstore Wholesale Price = $17.75

Microsoft® Excel 2010: Introductory  (ISBN-10: 1439078467 | ISBN-13: 9781439078464)

Introduce your students to the new generation of Microsoft Office 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 Excel 2010, we're continuing our history of innovation by enhancing our proven pedagogy to reflect the learning styles of today's students. In Microsoft Excel 2010: Introductory 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 the Excel 2010 software through experimentation, exploration, and planning ahead. End of chapter exercises prepare students to become more capable software users by requiring them to use critical thinking and problem-solving skills to create real-life documents giving them skills to use in both their personal and professional lives.

List Price = $91.95  | CengageBrain Price = $91.95  | College Bookstore Wholesale Price = $69.25

Student Supplements

Microsoft® Office 2010 180-day Subscription  (ISBN-10: 1111747970 | ISBN-13: 9781111747978)

If you are taking a Microsoft Office 2010 course, ask your instructor to bundle their textbook order with this trial software! If you haven't upgraded from Office 2007 or don't have Microsoft Office at all, this CD allows you to use Office 2010 on your personal computer for up to 180 days! This trial software can only be purchased in a bundle (it cannot be purchased alone). Ask your instructor to contact their sales representative for more information.

List Price = $17.75  | College Bookstore Wholesale Price = $17.75

Microsoft® Excel 2010: Introductory  (ISBN-10: 1439078467 | ISBN-13: 9781439078464)

With Excel 2010, we're continuing our history of innovation by enhancing our proven pedagogy to reflect the learning styles of today's students. In Microsoft Excel 2010: Introductory you'll find features that are specifically designed to engage you, improve retention, and prepare you for future success. Our trademark step-by-step, screen-by-screen approach now encourages you to expand your understanding of the Excel 2010 software through experimentation, exploration, and planning ahead. End of chapter exercises prepare you to become more capable software users by requiring you to use critical thinking and problem-solving skills to create real-life documents giving you skills to use in both your personal and professional lives.

List Price = $91.95  | CengageBrain Price = $91.95  | College Bookstore Wholesale Price = $69.25

Meet the Author

Author Bio

Gary B. Shelly

Gary B. Shelly wrote and published his first computer education textbook in 1969. More than twenty million copies of Shelly Cashman Series' textbooks have been sold. Gary and a talented group of contributing authors have produced books on computer programming, computer concepts, and application software that are the leading textbooks in the computer technology market today. Gary has hosted the annual Shelly Cashman Institute, a week-long training event focusing on the latest topics in technology, for the past 34 years.

Jeffrey J. Quasney

Jeffrey J. Quasney has worked with the Shelly Cashman Series for more than 9 years in various capacities, including as a developer of teaching tools associated with the Series' textbooks. He has authored several textbooks, including Visual Basic .NET, Microsoft Office FrontPage 2003, several editions of Microsoft Office Excel, and is a contributing author for Discovering Computers and Discovering Computers: Fundamentals Edition.