Publisher: For Dummies
Number Of Pages: 408
Publication Date: 2007-09-04
Sales Rank: 329593
ISBN / ASIN: 0470169370
EAN: 9780470169377
Contents at a Glance
Introduction .............................................................................1
Part I: Creating Spreadsheets ....................................................7
Chapter 1: Getting Familiar with the Excel 2007 Interface ...............................................................9
Chapter 2: Entering the Spreadsheet Data .......................................................................................19
Chapter 3: Formatting the Spreadsheet............................................................................................37
Chapter 4: Printing Spreadsheet Reports .........................................................................................57
Chapter 5: Modifying the Spreadsheet..............................................................................................77
Part II: Using Formulas and Functions ...................................101
Chapter 6: Building Formulas...........................................................................................................103
Chapter 7: Copying and Correcting Formulas................................................................................123
Chapter 8: Creating Date and Time Formulas ................................................................................145
Chapter 9: Financial Formulas and Functions................................................................................153
Chapter 10: Using Math Functions...................................................................................................163
Chapter 11: Using Common Statistical Functions .........................................................................175
Chapter 12: Using Lookup Functions ..............................................................................................183
Chapter 13: Using Logical Functions ...............................................................................................193
Chapter 14: Text Formulas and Functions......................................................................................205
Part III: Working with Graphics.............................................213
Chapter 15: Charting Spreadsheet Data..........................................................................................215
Chapter 16: Adding Graphics to Spreadsheets ..............................................................................229
Part IV: Managing and Securing Data....................................251
Chapter 17: Building and Maintaining Data Lists...........................................................................253
Chapter 18: Protecting the Spreadsheet .........................................................................................275
Part V: Doing Data Analysis..................................................287
Chapter 19: Performing What-If Analysis........................................................................................289
Chapter 20: Generating Pivot Tables...............................................................................................303
Part VI: Macros and Visual Basic for Applications ..................319
Chapter 21: Using Macros.................................................................................................................321
Chapter 22: Using the Visual Basic Editor ......................................................................................329
Part VII: The Part of Tens......................................................343
Chapter 23: Top Ten Features in Excel 2007...................................................................................345
Chapter 24: Top Ten Tips for Using Excel Like a Pro ....................................................................349
Appendix: About the CD........................................................357
Index...................................................................................365
Download links from here :
http://ubookmark.blogspot.com/2010/02/excel-for-dummies.html
Enjoy !
No comments:
Post a Comment