Excel 2010 eLearning Kit For Dummies

內容簡介

A complete package for learning Excel 2010!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 todayIncludes 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 paceOffers chapter summaries, practice exercises, discussions of concepts and essential terms, and much moreExcel 2010 eLearning Kit For Dummies helps you maximize the potential of this data analysis tool so you can work more efficiently.
 

目錄
About the Author iii 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 About the CD 333 Index 337