Microsoft Office Excel 2003 Inside Out

you know your way around a spreadsheet—so now dig into Excel 2003 and really put your data to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and handy workarounds in concise, fast-answer format. It’s all muscle and no fluff. Discover the best and fastest ways to perform everyday tasks, and challenge yourself to new levels of Excel mastery!
Nội dung trích xuất từ tài liệu:
Microsoft Office Excel 2003 Inside OutPUBLISHED BYMicrosoft PressA Division of Microsoft CorporationOne Microsoft WayRedmond, Washington 98052-6399Copyright © 2004 by Craig Stinson and Mark DodgeAll rights reserved. No part of the contents of this book may be reproduced or transmitted in any formor by any means without the written permission of the publisher.Library of Congress Cataloging-in-Publication DataStinson, Craig, 1943- Microsoft Office Excel 2003 Inside Out / Craig Stinson, Mark Dodge. p. cm. Includes index. ISBN 0-7356-1511-X 1. Microsoft Excel (Computer file) 2. Business--Computer programs. 3. Electronic spreadsheets. I. Dodge, Mark. II. Title. HF5548.4.M523S753 2003 005.369--dc21 2003052673Printed and bound in the United States of America.123456789 QWT 876543Distributed 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 informa-tion about international editions, contact your local Microsoft Corporation office or contact MicrosoftPress International directly at fax (425) 936-7329. Visit our Web site at www.microsoft.com/mspress.Send comments to mspinput@microsoft.com.AutoSum, FrontPage, IntelliMouse, Microsoft, Microsoft Press, MS-DOS, PivotChart, PivotTable,SharePoint, Visual Basic, Windows, and Windows NT are either registered trademarks or trademarks ofMicrosoft Corporation in the United States and/or other countries. Other product and company namesmentioned 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 BlantonProject Editor: Sandra HaynesSeries Editor: Sandra HaynesBody Part No. X09-69527 Contents At A GlanceContents at a Glance Part 1 Part 4 Examining the Excel Adding Graphics Environment and Printing Chapter 1 Chapter 10 What’s New in Microsoft Creating Spiffy Graphics . . . . . . . 283 Office Excel 2003 . . . . . . . . . . . . . 3 Chapter 11 Chapter 2 Printing and Presenting . . . . . . . 331 Excel Fundamentals . . . . . . . . . . .13 Part 5 Chapter 3 Creating Formulas and Custom-Tailoring the Excel Performing Data Workspace . . . . . . . . . . . . . . . . . .65 Analysis Part 2 Building Worksheets Chapter 12 Building Formulas. . . . . . . . . . . . 351 Chapter 4 Chapter 13 Worksheet Design Tips . . . . . . . . .93 Using Functions . . . . . . . . . . . . . 401 Chapter 5 Chapter 14 How to Work a Worksheet . . . . . .101 Everyday Functions . . . . . . . . . . 411 Chapter 6 Chapter 15 How to Work a Workbook . . . . . .133 Formatting and Calculating Date and Time . . . . . . . . . . . . . . 435 Part 3 Formatting and Editing Chapter 16 Worksheets Functions for Financial Analysis . . . . . . . . . . . . . . . . . . . 449 Chapter 7 Chapter 17 Worksheet Editing Techniques . . .147 Functions for Analyzing Statistics . . . . . . . . . . . . . . . . . . 463 Chapter 8 Worksheet Formatting Chapter 18 Techniques . . . . . . . . . . . . . . . . .195 Performing What-If Analysis . . . . 493 Chapter 9 Advanced For ...