Excel 2010 Basics and Advanced For Dummies eLearning Course Access Code Card (6 Month Subscription)

by Wempen, Faithe

• ISBN13: 9781118446324
• ISBN10: 1118446321
• Edition: 1st
• Format: Paperback
• Copyright: 2012-10-12
• Publisher: For Dummies

Summary

In this complete Basics-to-Advanced course, you'll learn it all: Covers everything you need to know to perform the task at hand. Includes information on creating and editing worksheets, formatting cells, entering formulas, creating and editing charts, inserting graphs, designing database forms, adding database records, using seek-and-find options, printing, adding hyperlinks to worksheets, saving worksheets as web pages, adding existing worksheet data to an existing web page, and sending worksheets via e-mail. In each lesson, you'll find clear, expert instruction, interactive quizzes, hands-on activities, summaries, and a way to review topics so you can progress at your own pace.

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