Brilliant Microsoft Excel 2007 Tips & Tricks

Greg Holden (Chicago, IL) has written more than 30 books on computers and the Internet, including Introducing MS Expression Studio; Starting an Online Business for Dummies, and How to Do Everything with Your eBay Business. He is founder and owner of Stylus Media, his own small Internet-based business.

Table of Contents

 

Part I: Tables, Charts, and Queries

Chapter 1: Improving Tables (14 pp.)

                Introduction

                Tables in Excel 2007

                BOXOUT: Formatting in Excel 2007y

                BOXOUT: Understanding Data Mining

                TASK: Preserving Leading Zeros When Importing Data

                TASK: Converting SSN and other Numbers to the Proper

                TASK: Changing Names to the Proper Format

                TASK: Converting Dates to the Proper Format

                TASK: Uniform Formatting for E-Mail Addresses

                TASK: Formatting Phone Numbers with a Formula

                TASK: Data Mining with Excel 2007

                TASK: Watching Cells that are Not Currently on Screen

                TASK: Auditing a Worksheet

 

Chapter 2: Queries (16 pp.)

                Introduction

                Working with Queries

                BOXOUT: Understanding Queries

                TASK: Run a query in the background

                TASK: Customize a parameter query

                TASK: Change the custom prompt for a query

                TASK: Use cell data as query parameters

                TASK: Use a constant parameter value for a query

                TASK: Building Your Own Query

                TASK: Using Microsoft Query to Retrieve Data

 

Chapter 3: Forms (19 pp.)

                Introduction

                Data Forms and Excel 2007

                TASK: Configuring Excel 2007 to Use Data Forms

                TASK: Creating a Blank User Form