Dummies.com
  • Print
  • Share
Excel 2007 All-In-One Desk Reference For Dummies (1118050606) cover image

Excel 2007 All-In-One Desk Reference For Dummies

ISBN: 978-1-118-05060-6
E-book
816 pages
February 2011
How to read this e-book on:
Adobe e-books are read using Adobe Digital Editions. Install Adobe Digital Editions on your PC in order to read or transfer your e-book.
Introduction.

Book I: Excel Basics.

Chapter 1: The Excel 2007 User Experience.

Chapter 2: Getting Help, Tips, and Updates.

Chapter 3: Customizing Excel.

Book II: Worksheet Design.

Chapter 1: Building Worksheets.

Chapter 2: Formatting Worksheets.

Chapter 3: Editing and Proofing Worksheets.

Chapter 4: Managing Worksheets.

Chapter 5: Printing Worksheets.

Book III: Formulas and Functions.

Chapter 1: Building Basic Formulas.

Chapter 2: Logical Functions and Error Trapping.

Chapter 3: Date and Time Formulas.

Chapter 4: Financial Formulas.

Chapter 5: Math and Statistical Formulas.

Chapter 6: Lookup, Information, and Text Formulas.

Book IV: Worksheet Collaboration and Review.

Chapter 1: Protecting Workbooks and Worksheet Data.

Chapter 2: Linking Workbooks with Hyperlinks.

Chapter 3: Sending Workbooks Out for Review.

Chapter 4: Sharing Worksheets and Worksheet Data.

Book V: Charts and Graphics.

Chapter 1: Charting Worksheet Data.

Chapter 2: Adding Graphic Objects.

Book VI: Data Management.

Chapter 1: Building and Maintaining Data Lists.

Chapter 2: Filtering and Querying a Data List.

Book VII: Data Analysis.

Chapter 1: Performing What-If Scenarios.

Chapter 2: Generating Pivot Tables.

Book VIII: Excel and VBA.

Chapter 1: Building and Running Macros.

Chapter 2: VBA Programming.

Appendix: Using XML File Formats.

Index.

  • Print
  • Share