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
This book provides the intermediate/experienced Excel user with everything they need to build on their existing Excel skills to more effectively use and develop all of the more advanced features and functions of Excel 2007.
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.
Ask a Question About this Product More... |