# Excel 2010 eLearning Kit For Dummies

ISBN: 978-1-118-11079-9

Jan 2012

368 pages

Select type: Paperback

Product not available for purchase

## Description

A complete package for learning Excel 2010!

Publisher's Note- The online training portion of this product is no longer available.

As the leading spreadsheet application, Excel is an essential data analysis and business tool. With this dynamic combination of a full-color printed book and a Dummies interactive eLearning course on CD, you'll find a wealth of information on the latest release of Excel. Featuring both written and animated step-by-step how-tos, practice labs, helpful videos, numerous examples, and a host of Dummies hints and tips, this package makes your learning process easier.

Follow the material sequentially or jump in and out as you wish?it's set up so you can learn at your own pace. Throughout, you will benefit from illustrations, animations, voiceover explanations, and the option of closed captioning if you find you learn better when you can read the instructions.

• Helps self-motivated learners master Excel 2010, the leading spreadsheet application used today
• Includes an easy-to-follow, full-color book and an interactive Dummies eLearning Course that corresponds with the book on CD
• Allows you to follow the material sequentially or choose separate sections at your own time and pace
• Offers chapter summaries, practice exercises, discussions of concepts and essential terms, and much more

Excel 2010 eLearning Kit For Dummies helps you maximize the potential of this data analysis tool so you can work more efficiently.

NOTE: CD-ROM/DVD and other supplementary materials are not included as part of the e-book file, but are available for download after purchase.

Dedication iii

Author's Acknowledgments iii

Introduction 1

Lesson 1: Creating Basic Worksheets 5

Lesson 2: Creating Formulas and Functions 31

Lesson 3: Formatting and Printing Worksheets 57

Lesson 4: Formatting Data 89

Lesson 5: Storing and Managing Tables and Lists 137

Lesson 6: Exploring Financial Functions and Scenarios 161

Lesson 7: Working with Math, Statistical, and Text Functions 193

Lesson 8: Creating and Formatting Charts 219

Lesson 9: Working with PivotTables 253

Lesson 10: Correcting and Validating Data 285

Lesson 11: Protecting and Sharing Data 307