Synopses & 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 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.
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 to
Create, format, modify, and print spreadsheets
Build and use formulas
Work with charts and graphics
Manage and analyze data
Customize Excel with macros and VBA
On the CD, you'll find:
See the CD Appendix for complete system requirements.
Practice creating spreadsheets and working with formulas and functions
Learn to depict your data with graphics
Plan common or complex Excel tasks
View feature demos on the CD
About the Author
Greg Harvey, PhD, is an experienced educator and the bestselling author of numerous Excel books.
Table of Contents
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.