Excel 2010 eLearning Kit For Dummies

by Wempen, Faithe

• ISBN13: 9781118110799
• ISBN10: 111811079X
• Edition: CD
• Format: Paperback
• Copyright: 2012-01-10
• Publisher: For Dummies

Summary

The Excel 2010 eLearning Kit For Dummies BOOK: Descriptive learning goals that clearly define chapter content and help learners determine whether the coverage matches the instruction they are seeking. Directed, but flexible, learning paths that readers can use to customize their learning experience. Readers can follow each chapter section, perform each chapter exercise, and take full advantage of the integrated CD material to receive a linear, multimedia learning experience. Or, readers can use the tried and tested Dummies Way to knowledge--by skipping around, selecting material, and pacing themselves to satisfy their learning goals. Clear, convenient navigation that enables learners to easily follow a linear learning path or jump to selected material from the book chapter, on the CD, or online. Tutorial pedagogy and multimedia tools that give learners hands-on involvement and learn by doing. Assessment mechanisms, including chapter summaries that offer additional practice exercises, concise descriptions of key concepts, and definitions of essential terms. The Excel 2010 eLearning Kit For Dummies CD: Integrated audio and video instruction and transcripts, including screencasts, illustrations, animations, and video, as well as transcripts of all CD material. Interactivity offers immediate reinforcement of applied learning. Progress tracking that gives learners the capability to track which lessons/exercises they've completed. The Excel 2010 eLearning Kit For Dummies KIT: An integrated learning experience with the book and CD teaming up to deliver a directed, but flexible eLearning system. A sense of community that comes from access to additional course material online, access to a variety of online courses available for other subjects, and interaction with a learning community or forum where they can share learning experiences.

Author Biography

Faithe Wempen has been educating people about computer hardware and software since 1992. She's the author of over 100 books, including Office 2010 eLearning Kit For Dummies. She also teaches Computer Information Technology at Indiana University-Purdue University at Indianapolis (IUPUI) and online at Powered.com.

Table of Contents

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