Excel^® 2007 All-In-One Desk Reference For Dummies^®

by Greg Harvey (Mind Over Media, Point Reyes Station, California)

• ISBN13: 9780470116807
• ISBN10: 0470116803
• Format: eBook
• Copyright: 2007-03-01
• Publisher: For Dummies

Summary

Master the Ribbon, powerful graphics capabilities, and more!Your one-stop guide to great-looking spreadsheets that actually mean somethingCreate colorful spreadsheets and charts, use Live Preview, and maximize everything Excel 2007 has to offer! Find just what you need to know about using the new Ribbon, designing spreadsheets that communicate, editing and printing them, working with formulas, protecting your data when you collaborate, turning out cool charts, and much more. The included four-color insert highlights the Ribbon, new graphics features, and more!Discover how to Create dynamic spreadsheets with style galleries Work with more than 40 new cell styles Automate formatting with Live Preview Share Excel data with other programs Use VBA to write custom Excel functions

Table of Contents

Introduction

Excel Basics

The Excel 2007 User Experience

Getting Help, Tips, and Updates

Customizing Excel

Worksheet Design

Building Worksheets

Formatting Worksheets

Editing and Proofing Worksheets

Managing Worksheets

Printing Worksheets

Formulas and Functions

Building Basic Formulas

Logical Functions and Error Trapping

Date and Time Formulas

Financial Formulas

Math and Statistical Formulas

Lookup, Information, and Text Formulas

Worksheet Collaboration and Review

Protecting Workbooks and Worksheet Data

Linking Workbooks with Hyperlinks

Sending Workbooks Out for Review

Sharing Worksheets and Worksheet Data

Charts and Graphics

Charting Worksheet Data

Adding Graphic Objects

Data Management

Building and Maintaining Data Lists

Filtering and Querying a Data List

Data Analysis

Performing What-If Scenarios

Generating Pivot Tables

Excel and VBA

Building and Running Macros

VBA Programming

Appendix: Using XML File Formats

Index

Table of Contents provided by Publisher. All Rights Reserved.