Microsoft Office Excel 2007-Data Analysis and Business Modeling

Wayne L. Winston

Microsoft

PUBLISHED BY
Microsoft Press
A Division of Microsoft Corporation
One Microsoft Way
Redmond, Washington 98052-6399

© 2007 by Wayne Winston

ISBN 9780735623965

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 Control Number: 2007924648

1 2 3 4 5 6 7 8 9 QWT 2 1 0 9 8 7

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 [phone]. Visit our Web site at www.microsoft.com/mspress. Send comments to [e-mail].

Microsoft, Microsoft Press, ActiveX, Excel, MSN, PivotChart, PivotTable, SharePoint, SmartArt, Visual Basic, Windows, and Xbox 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.

This book expresses the author’s views and opinions. The information contained in this book is provided without any express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its resellers, or distributors will be held liable for any damages caused or alleged to be caused either directly or indirectly by this book.

• Acquisitions Editor: Juliana Aldous Atkinson

• Developmental Editor: Sandra Haynes

• Project Editor: Kathleen Atkins

• Editorial Production Services: Online Training Solutions, Inc.

• Technical Reviewer: Jason Lee; Technical Review services provided by Content Master, a member of CM Group, Ltd.

Body Part No. X13-68388

About the Author

Wayne L. Winston is a professor of decision sciences at the Indiana University Kelley School of Business. He has earned an MBA teaching award for 26 consecutive years and regularly teaches business analysts how to use Microsoft Office Excel to make better decisions. Wayne also consults for several Fortune 500 clients, including 3M, Bristol-Myers Squibb Company, Cisco Systems, Eli Lilly and Company, Ford Motor Company, General Electric Company, General Motors Corporation, Intel Corporation, Microsoft Corporation, NCR Corporation, Owens Corning, Pfizer, Proctor & Gamble, the U.S. Army, U.S. Department of Defense, Verizon, and WellPoint. He and business partner Jeff Sagarin developed the statistics tracking and rating system used by the Dallas Mavericks professional basketball team. Wayne is also a two-time Jeopardy! champion.