Publisher's Note- The online training portion of this product is no longer available.
A complete package for learning Excel 2013!
Excel is essential to business today, but it can be tricky to navigate. If you're eager to excel at Excel, then this dynamic multimedia learning solution is for you. This complete Excel 2013 package includes a full-color printed book and a For Dummies interactive eLearning course on CD. You'll discover the basics of the Excel interface, how to navigate it, and how to make the most of key features including charts, formulas, functions, macros, and more.
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 2013, the leading spreadsheet application used today
- Walks you through creating worksheets, working with formulas and functions, formatting data, using financial functions, displaying data in PivotTables, and much more
- 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 material sequentially or choose separate sections at your own time and pace
Excel 2013 eLearning Kit For Dummies shows you the ins and outs of all things Excel so you can enhance your productivity and become a spreadsheet star!
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.
Related collections and offers
About the Author
Faithe Wempen, M.A., is an adjunct instructor of Computer Information Technology at Indiana University Purdue University at Indianapolis (IUPUI). She is also a Microsoft Office Master Instructor and the author of over 140 books on computer hardware and software.
Table of Contents
Lesson 1: Creating Basic Worksheets 7
Lesson 2: Creating Formulas and Functions 41
Lesson 3: Formatting and Printing Worksheets 75
Lesson 4: Formatting Data 105
Lesson 5: Storing and Managing Tables and Lists 151
Lesson 6: Exploring Financial Functions and Scenarios 173
Lesson 7: Working with Math, Statistical, and Text Functions 203
Lesson 8: Creating and Formatting Charts 227
Lesson 9: Working with PivotTables and PivotCharts 263
Lesson 10: Correcting and Validating Data 299
Lesson 11: Protecting and Sharing Data 319
Appendix: About the CD