Microsoft® Excel® 2010: Comprehensive, 1st Edition

  • Gary B. Shelly
  • Jeffrey J. Quasney
  • ISBN-10: 1439079013
  • ISBN-13: 9781439079010
  • 888 Pages Paperback 
  • Previous Editions: 2008, 2004, 2004
  • © 2011 | Published
Request a Copy
 

About The Solution

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: Comprehensive 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 2007 software through experimentation, exploration, and planning ahead. Brand new 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.


Additional Product Information

Features/Benefits

  • 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.
  • Increases students' retention with brand new end-of-chapter exercises, including Make It Right, Extend Your Knowledge, and Make It Personal, which emphasize problem-solving and experimentation.

What's New

  • Updated to include coverage of the newest features of Excel 2010.
  • Chapter topic redistribution offers concise chapters that ensure complete skill coverage and lead to more manageable chapters.
  • 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.

Best Buy Packages

Other Popular Packages

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


Bundle: Text + Microsoft® Office 2010 180-day Subscription
ISBN-10: 1111879559  | ISBN-13: 9781111879556


Bundle: Microsoft® Excel® 2010: Comprehensive + SAM 2010 Assessment, Training, and Projects v2.0 Printed Access Card
ISBN-10:  0495963534  | ISBN-13:  9780495963530


Bundle: Microsoft® Excel® 2010: Comprehensive + SAM 2010 Assessment, Training, and Projects v2.0 Printed Access Card + Microsoft® Office 2010 180-day Subscription
ISBN-10:  1133165400  | ISBN-13:  9781133165408


Bundle: Principles of Information Systems, 10th + Online Content Printed Access Card + Microsoft® Excel® 2010: Comprehensive
ISBN-10:  1285254376  | ISBN-13:  9781285254371


ePack: Microsoft® Excel® 2010: Comprehensive + WebTutor™ on Angel Instant Access Code + SAM 2010 Assessment, Training, and Projects v2.0 Instant Access Code + Microsoft® Office 2010 180-day Subscription
ISBN-10:  1285570162  | ISBN-13:  9781285570167


ePack: Microsoft® Excel® 2010: Comprehensive + SAM 2010 Assessment, Training, and Projects v2.0 Instant Access Code
ISBN-10:  1285586379  | ISBN-13:  9781285586373


Bundle: Text + SAM 2010 Assessment and Training v2.0 Printed Access Card + Microsoft® Office 2010 180-day Subscription
ISBN-10:  1133165419  | ISBN-13:  9781133165415


ePack: Microsoft® Excel® 2010: Comprehensive + Microsoft® Access 2010: Complete + SAM 2010 Assessment, Training, and Projects v2.0 Instant Access
ISBN-10:  1285932951  | ISBN-13:  9781285932958


ePack: Text + Microsoft® Office 2010 180-day Subscription + SAM 2010 Assessment, Training, and Projects v2.0 Instant Access
ISBN-10:  128572772X  | ISBN-13:  9781285727721


ePack: Text + SAM 2010 Assessment, Training, and Projects with MindTap Reader for Microsoft Excel 2010: Comprehensive + Microsoft® Office 2010 180-day Subscription
ISBN-10:  1305247965 | ISBN-13:  9781305247963


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.
8. PivotTables, PivotCharts, and Trendlines.
9. Formula Auditing, Data Validation, and Complex Problem Solving.
10. Using Macros and Visual Basic for Applications in Excel.
11. External Data, Web Queries, and Collaboration
Appendices.
A: Project Planning Guidelines.
B: Publishing Office 2010 Web Pages Online.
C: Saving to the Web Using Windows Live SkyDrive.
Index/Quick Reference.

Supplements

Instructor Supplements

Instructor Supplements

All supplements have been updated in coordination with the main title. Select the main title’s "About the Solution" 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.

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.


Microsoft® Excel® 2010: Complete  (ISBN-10: 0538750057 | ISBN-13: 9780538750059)

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.


WebTutor™ on Blackboard® Instant Access Code  (ISBN-10: 111142909X | ISBN-13: 9781111429096)

Electronic code allowing access to WebTutor Blackboard Cartridge.


WebTutor™ on WebCT™ Instant Access Code  (ISBN-10: 1111429111 | ISBN-13: 9781111429119)

Electronic code allowing access to WebTutor WebCT Cartridge.


WebTutor™ on Angel Instant Access Code  (ISBN-10: 1111429073 | ISBN-13: 9781111429072)

Electronic code allowing access to WebTutor Angel Cartridge.


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.


Review Pack  (ISBN-10: 1439078513 | ISBN-13: 9781439078518)

CD containing all Microsoft Office 2010 student data files.


SAM 2010 Assessment, Training, and Projects with MindTap Reader for Microsoft Excel 2010: Comprehensive  (ISBN-10: 1285195507 | ISBN-13: 9781285195506)

Prepare for today’s workplace with SAM 2010, the premier testing and training tool for Microsoft® Office 2010. Build your skill and confidence with a variety of real-life simulations and engaging SAM projects’ assignments. This product also gives you access to the MindTap Reader eBook for MICROSOFT EXCEL 2010: COMPREHENSIVE, which helps you master computer concepts and introductory Office 2010 skills through video, audio, annotations, activities, and applications.


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.


Student Supplements

Student Supplements

All supplements have been updated in coordination with the main title. Select the main title’s "About the Solution" 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.

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.


Microsoft® Excel® 2010: Complete  (ISBN-10: 0538750057 | ISBN-13: 9780538750059)

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


WebTutor™ on Blackboard® Instant Access Code  (ISBN-10: 111142909X | ISBN-13: 9781111429096)

Electronic code allowing access to WebTutor Blackboard Cartridge.


WebTutor™ on WebCT™ Instant Access Code  (ISBN-10: 1111429111 | ISBN-13: 9781111429119)

Electronic code allowing access to WebTutor WebCT Cartridge.


MindTap™ Reader Add-On Instant Access  (ISBN-10: 1305088204 | ISBN-13: 9781305088207)


WebTutor™ on Angel Instant Access Code  (ISBN-10: 1111429073 | ISBN-13: 9781111429072)

Electronic code allowing access to WebTutor Angel Cartridge.


Review Pack  (ISBN-10: 1439078513 | ISBN-13: 9781439078518)

CD containing all Microsoft Office 2010 student data files.


SAM 2010 Assessment, Training, and Projects with MindTap Reader for Microsoft Excel 2010: Comprehensive  (ISBN-10: 1285195507 | ISBN-13: 9781285195506)

Prepare for today’s workplace with SAM 2010, the premier testing and training tool for Microsoft® Office 2010. Build your skill and confidence with a variety of real-life simulations and engaging SAM projects’ assignments. This product also gives you access to the MindTap Reader eBook for MICROSOFT EXCEL 2010: COMPREHENSIVE, which helps you master computer concepts and introductory Office 2010 skills through video, audio, annotations, activities, and applications.


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.


Meet the Author

About the Author

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.