Accessing and Analyzing Data with Microsoft Excel (Bpg-Other)

Paul Cornell.

PUBLISHED BYMicrosoft PressA Division of Microsoft CorporationOne Microsoft WayRedmond, Washington 98052-6399

Copyright 2003 by Paul Cornell

All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any means without the written permission of the publisher.

Library of Congress Cataloging-in-Publication DataCornell, Paul, 1968- Accessing and Analyzing Data with Microsoft Excel / Paul Cornell. p. cm. Includes index. ISBN 0-7356-1895-X 1. Microsoft Excel (Computer file) 2. Business—Data processing. 3. Business— Computer programs. I. Title. HF5548.4.M523C675 2003 005.369—dc21 2002044877

Printed and bound in the United States of America.

1 2 3 4 5 6 7 8 9 QWE 8 7 6 5 4 3

Distributed in Canada by H.B. Fenn and Company Ltd.

A CIP catalogue record for this book is available from the British Library.

Microsoft Press books are available through booksellers and distributors worldwide. For further information about international editions, contact your local Microsoft Corporation office or contact Microsoft Press International directly at fax (425) 936-7329. Visit our Web site at www.microsoft.com/mspress. Send comments to mspinput@microsoft.com.

ActiveX, AutoSum, FrontPage, MapPoint, Microsoft, Microsoft Press, MSDN, Outlook, PivotTable, PivotChart, PowerPoint, Visual Basic, Windows, and Windows NT are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Other product and company names mentioned herein may be the trademarks of their respective owners.

The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious. No association with any real company, organization, product, domain name, e-mail address, logo, person, place, or event is intended or should be inferred.

Acquisitions Editor: Alex Blanton Project Editor: John Pierce

Body Part No. X09-35333

Acknowledgments

I want to thank my team at Microsoft, especially Jean Philippe Bagel, for allowing me to write this book. I’d like to thank Frank Rice for answering my Microsoft Access questions, Colin Wilcox for producing the Microsoft Data Analyzer tutorial included on the book’s CD, and Francois Ajenstat for writing the book’s foreword.

Thanks to the team at Microsoft Press, especially Alex Blanton and John Pierce, for their enthusiasm, helpfulness, and attention to detail as they guided this book through to print.

I want to thank my family: my wife, Shelley, for giving up a lot of our together time; my daughters, Zoe and Bailey, for giving up some play time with Daddy; and my parents for always encouraging me while I pursued my dreams. I love all of you.

Finally, I want to thank God for giving me the knowledge and opportunity to write this book.

About the Author

Paul Cornell works as a writer and an editor for the Microsoft Office Help team. He has worked on several Office Help projects, including the Microsoft Office Visual Basic Language Reference, Office XP Web Services Toolkit Help, Microsoft Office XP Primary Interop Assemblies Help, and the Microsoft Data Analyzer Tutorial.

In addition to writing and editing technical articles for the Microsoft Developer Network (MSDN), Paul contributes to the Office Power User Corner column at the Microsoft Office Assistance Center (http://office.microsoft.com/ Assistance) and the Office Talk column at the Microsoft Office Developer Center (http://msdn.microsoft.com/office).

Paul lives with his wife and two daughters in Washington State.

The manuscript for this book was prepared and galleyed using Microsoft Word. Pages were composed by Microsoft Press using Adobe FrameMaker+SGML for Windows, with text in Garamond and display type in Helvetica Condensed. Composed pages were delivered to the printer as electronic prepress files.

Cover Designer: Patricia Bradbury Interior Graphic Designer: James D. Kramer Principal Compositor: Dan Latimer Interior Artist: Joel Panchot Principal Copy Editor: Patricia Masserman Indexer: Shane-Armstrong Information Systems

Категории