Excel 2010 Workbook For Dummies

Excel 2010 Workbook For Dummies

Paperback For Dummies

By (author) Greg Harvey

$20.01
List price $34.35
You save $14.34 41% off

Free delivery worldwide
Available
Dispatched in 4 business days
When will my order arrive?

  • Publisher: John Wiley & Sons Ltd
  • Format: Paperback | 408 pages
  • Dimensions: 201mm x 251mm x 25mm | 726g
  • Publication date: 12 October 2010
  • Publication City/Country: Chichester
  • ISBN 10: 047048960X
  • ISBN 13: 9780470489604
  • Edition statement: Workbook
  • Illustrations note: figures
  • Sales rank: 535,818

Product description

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.

Other people who viewed this bought:

Showing items 1 to 10 of 10

Other books in this category

Showing items 1 to 11 of 11
Categories:

Author information

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

Back cover copy

Get hands-on practice and learn to use all the features of Excel 2010!Using Excel as nothing more than an electronic version of an accountant's spreadsheet would be like using a super-modified race car just to drive the kids to school. Excel lets you design forms, interact with corporate databases, interpret and present sales figures, and perform dozens of other tasks. The exercises in this workbook let you practice the techniques and learn by doing. Then you can reinforce your knowledge by viewing the feature demos of various Excel tasks on the CD.See how toCreate, format, modify, and print spreadsheetsBuild and use formulasWork with charts and graphicsManage and analyze dataCustomize Excel with macros and VBAOn the CD, you'll find: Demo files showing you various features of Excel 2010Sample workbook files and completed worksheets for practice exercisesSee the CD Appendix for complete system requirements.Practice creating spreadsheets and working with formulas and functionsLearn to depict your data with graphicsPlan common or complex Excel tasksView feature demos on the CD

Table of contents

Introduction. Part I: Creating Spreadsheets. Chapter 1: Getting Familiar with the Excel 2010 Interface. Chapter 2: Entering the Spreadsheet Data. Chapter 3: Formatting the Spreadsheet. Chapter 4: Printing Spreadsheet Reports. Chapter 5: Modifying the Spreadsheet. Part II: Using Formulas and Functions. Chapter 6: Building Formulas. Chapter 7: Copying and Correcting Formulas. Chapter 8: Creating Date and Time Formulas. Chapter 9: Financial Formulas and Functions. Chapter 10: Using Math Functions. Chapter 11: Using Common Statistical Functions. Chapter 12: Using Lookup Functions. Chapter 13: Using Logical Functions. Chapter 14: Text Formulas and Functions. Part III: Working with Graphics. Chapter 15: Charting Spreadsheet Data. Chapter 16: Adding Graphics to Spreadsheets. Part IV: Managing and Securing Data. Chapter 17: Building and Maintaining Data Lists. Chapter 18: Protecting the Spreadsheet. Part V: Doing Data Analysis. Chapter 19: Performing What-If Analysis. Chapter 20: Generating Pivot Tables. Part VI: Macros and Visual Basic for Applications. Chapter 21: Using Macros. Chapter 22: Using the Visual Basic Editor. Part VII: The Part of Tens. Chapter 23: Top Ten Features in Excel 2010. Chapter 24: Top Ten Tips for Using Excel Like a Pro. Appendix A: Comparing Worksheets Side by Side. Appendix B: About the CD. Appendix C: Table of Exercises. Index.