Everyday Computing Advanced Computing The Internet At Home Health, Mind & Body Making & Managing Money Sports & Leisure Travel Beyond The Classroom
Handheld Computing
Hardware
Money Management Software
Multimedia
Office Productivity Software
Operating Systems
Win a $500 Gift Card!
Excel 2007 All-In-One Desk Reference For Dummies

Excel 2007 All-In-One Desk Reference For Dummies


By Greg Harvey, PhD

ISBN: 978-0-470-03738-6
Format: Paper
Pages: 816 Pages
Pub. Date: January 2007

E-mail a Friend About This Book
Price: $29.99
Description
Author Information
Table of Contents
Read Excerpt: Chapter (PDF)
Read Excerpt: Table of Contents (PDF)
Read Excerpt: Index (PDF)
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.

Related Articles
Creating a New Chart with the Excel Chart Wizard
Comparing Slices of Data with an Excel Pie Chart
Creating a Visual Report in Microsoft Project 2007
Concatenating Text in Excel 2007
Excel Formulas: Leaving Decimals Behind with INT
Related Titles
Excel 2007 Just the Steps For Dummies
Excel 2007 Data Analysis For Dummies
Microsoft Office Excel 2007 Formulas & Functions For Dummies
Microsoft Office Live For Dummies
Excel 2007 Workbook For Dummies