# Excel 2010 Workbook For Dummies

John Wiley & Sons, Aug 13, 2010 - Computers - 408 pages
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 Excel
• The Workbook approach offers practical application, with more than 100 exercises to work through and plenty of step-by-step guidance
• This guide covers the new features of Excel 2010, includes a section on creating graphic displays of information, and offers ideas for financial planners
• Also provides exercises on using formulas and functions, managing and securing data, and performing data analysis
• A 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

User Review - Flag as inappropriate

I l;yk it it is okay

### 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