Excel 2013 eLearning Kit For Dummies

by Faithe Wempen

Overview

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.

Product Details

ISBN-13:	9781118493045
Publisher:	Wiley
Publication date:	11/04/2013
Series:	For Dummies Books
Pages:	384
Sales rank:	485,227
Product dimensions:	7.30(w) x 9.00(h) x 0.90(d)

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

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