Excel 2007 All-In-One Desk Reference For Dummies

Excel 2007 All-In-One Desk Reference For Dummies




















Publisher: For Dummies
Number Of Pages: 777
Publication Date: 2007-01-03
Sales Rank: 74813
ISBN / ASIN: 0470037385
EAN: 9780470037386



Contents at a Glance
Introduction .................................................................1
Book I: Excel Basics....................................................11
Chapter 1: The Excel 2007 User Experience .................................................................13
Chapter 2: Getting Help, Tips, and Updates..................................................................47
Chapter 3: Customizing Excel .........................................................................................57
Book II: Worksheet Design ..........................................77
Chapter 1: Building Worksheets .....................................................................................79
Chapter 2: Formatting Worksheets ..............................................................................123
Chapter 3: Editing and Proofing Worksheets..............................................................179
Chapter 4: Managing Worksheets.................................................................................229
Chapter 5: Printing Worksheets....................................................................................267
Book III: Formulas and Functions...............................295
Chapter 1: Building Basic Formulas.............................................................................297
Chapter 2: Logical Functions and Error Trapping......................................................335
Chapter 3: Date and Time Formulas ............................................................................355
Chapter 4: Financial Formulas ......................................................................................371
Chapter 5: Math and Statistical Formulas ...................................................................385
Chapter 6: Lookup, Information, and Text Formulas.................................................407
Book IV: Worksheet Collaboration and Review ............433
Chapter 1: Protecting Workbooks and Worksheet Data ............................................435
Chapter 2: Linking Workbooks with Hyperlinks.........................................................457
Chapter 3: Sending Workbooks Out for Review .........................................................467
Chapter 4: Sharing Worksheets and Worksheet Data ................................................497
Book V: Charts and Graphics .....................................521
Chapter 1: Charting Worksheet Data ...........................................................................523
Chapter 2: Adding Graphic Objects .............................................................................559
Book VI: Data Management.......................................587
Chapter 1: Building and Maintaining Data Lists .........................................................589
Chapter 2: Filtering and Querying a Data List ............................................................613
Book VII: Data Analysis ............................................653
Chapter 1: Performing What-If Scenarios ....................................................................655
Chapter 2: Generating Pivot Tables .............................................................................679
Book VIII: Excel and VBA ..........................................699
Chapter 1: Building and Running Macros....................................................................701
Chapter 2: VBA Programming.......................................................................................711
Appendix: Using XML File Formats ..............................................................................737
Index .......................................................................739


Download links from here :

http://ubookmark.blogspot.com/2010/02/excel-for-dummies.html

Enjoy !