Excel 2010 Workbook For Dummies (Google eBook)

Front Cover
John Wiley & Sons, Aug 13, 2010 - Computers - 408 pages
0 Reviews
Reinforce your understanding of Excel with these Workbook exercises

Boost your knowledge of important Excel tasks by putting your skills to work in real-world situations. The "For Dummies Workbook" format provides more than 100 exercises that help you create actual results with Excel so you can gain proficiency.

Perfect for students, people learning Excel on their own, and financial professionals who must plan and execute complex projects in Excel, "Excel 2010 Workbook For Dummies" helps you discover all the ways this program can work for you.Excel is the world's most popular number-crunching program, and "For Dummies" books are the most popular guides to ExcelThe Workbook approach offers practical application, with more than 100 exercises to work through and plenty of step-by-step guidanceThis guide covers the new features of Excel 2010, includes a section on creating graphic displays of information, and offers ideas for financial plannersAlso provides exercises on using formulas and functions, managing and securing data, and performing data analysisA companion CD-ROM includes screen shots and practice materials

"Excel 2010 Workbook For Dummies" helps you get comfortable with Excel so you can take advantage of all it has to offer.

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

  

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Introduction
1
Doing Data Analysis 283
4
Creating Spreadsheets
7
Entering the Spreadsheet Data
21
Formatting the Spreadsheet
39
Printing Spreadsheet Reports
59
Modifying the Spreadsheet
77
Using Formulas and Functions
99
Text Formulas and Functions
201
Working with Graphics
209
Adding Graphics to Spreadsheets
225
Managing and Securing Data
247
Protecting the Spreadsheet
271
Performing WhatIf Analysis
285
Generating Pivot Tables
299
Macros and Visual Basic for Applications
315

Copying and Correcting Formulas
121
Creating Date and Time Formulas
143
Financial Formulas and Functions
153
Using Math Functions
163
Using Common Statistical Functions
175
Using Lookup Functions
183
Using Logical Functions
189
Using the Visual Basic Editor
327
Top Ten Features in Excel 2010
343
Comparing Worksheets Side by Side
355
About the CD
357
Table of Exercises
363
Index
369
Copyright

Common terms and phrases

About the author (2010)

Greg Harvey, PhD, is an experienced educator and the bestselling author of numerous Excel books.

Bibliographic information