Author(s): Faithe Wempen
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.
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.
Introduction 1 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 Index 345