Beschreibung
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.
Autorenportrait
Greg Harvey, PhD, is an experienced educator and the bestselling author of numerous Excel books.
Inhalt
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.