Brilliant Microsoft Excel 2007 Tips & Tricks

Greg Holden (Autor)

Buch | Softcover

304 Seiten

2008
Prentice-Hall (Verlag)
978-0-273-71934-2 (ISBN)

Titel ist leider vergriffen;
keine Neuauflage

Artikel merken

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.

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

Erscheint lt. Verlag	11.12.2008
Verlagsort	Harlow
Sprache	englisch
Maße	190 x 235 mm
Gewicht	632 g
Themenwelt	Informatik ► Office Programme ► Excel
ISBN-10	0-273-71934-3 / 0273719343
ISBN-13	978-0-273-71934-2 / 9780273719342
Zustand	Neuware