Dear customers, please be informed that our shopping cart will be unavailable between August 21 and September 1, 2014, as we will be making some changes to serve you better. To minimise any possible delivery disruption, we encourage you to make your purchases before August 21. We appreciate your understanding and apologise for any inconvenience.

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
US $19.99 Purchase This E-book

This price is valid for United States. Change location to view local pricing and availability.

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