A reference for users of Excel 2002, showing how to take maximum advantage of its new and improved features. Shows how to create custom functions, retrieve data from databases, use value chains, cut, slice and pivot information of the Web with Excel's PivotTable utility, and more. Also includes a companion Web site with help for Office XP.

For any course teaching application software using Microsoft Office 2002 applications. This book will appeal to students in a variety of disciplines including liberal arts, business, and the sciences. The Exploring MS Office XP series gives the "when and why" of performing tasks in Office XP; it provides new integrated, real-world practice exercises; it's customizable in the RightPHit Program, certified to the core, and provides expert levels of Microsoft Office XP.

Part of the New Perspectives series, this text offers a case-based, problem-solving approach and innovative technology for meaningful learning of Microsoft Excel 2002.

Teach yourself how to use Microsoft® Visual Basic® for Applications (VBA) to take command of Microsoft Excel Version 2002. Choose your own best starting point in this self-paced guide to learn how to automate spreadsheets, write your own functions and procedures, customize menus and toolbars, and more. Easy-to-follow lessons with real-world scenarios and examples show you exactly how to maximize the built-in programming power in Microsoft Excel 2002. Numerous screenshots and a CD full of practice files help you master step-by-step programming procedures. Find out how to create custom solutions with Microsoft Excel and this book—then keep it nearby as an ongoing desktop reference to VBA functions and features. Learn at your own pace how to: Use macros to automate simple and complex tasks Manipulate workbooks and worksheets Explore range objects Work with graphical objects Build and manipulate PivotTable® objects Create loops and conditional statements with Visual Basic Use dialog box controls on worksheets Create and use custom functions and handle macro errors Create custom toolbar buttons, menu commands, command buttons, event handlers, and dialog boxes A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to [email protected].

When Comprehension through Context is Critical: The Grauer Series. The Grauer Series is the gold standard in Microsoft Office Applications texts. These texts not only direct students through Excel 2002 tasks, but it provides the "when" and the "why" of performing those tasks. With all new "Integration" problems and over 80% new exercises, The Grauer Series has the reinforcement tools to support and challenge students. The Grauer Series is customizable through the RightPHIT program, making it a tailored courseware option. Microsoft Certified to the EXPERT level, these texts contain the depth of coverage your students needs.

SERIES TAGLINE: THE HOW and WHY, PRACTICAL APPROACH TO LEARNING APPLICATIONS.

Microsoft Excel sets the standard for spreadsheet programs. Its versatility and functionality have made it the most popular spreadsheet program for Windows. It boasts an impressive set of tools to create, analyze, and share spreadsheets. With Excel 2002, Microsoft has added new features such as context-sensitive smart tags, new task panes, and Document Recovery to this popular product. Excel's compatibility with other Office 2002 products and its improved collaboration and Web integration features, including the ability to add data from Web sources, make it the perfect tool for sharing information on the Internet or intranets. Excel 2002 for Windows: Visual QuickStart Guide offers a friendly, gentle tour through all the features of Excel 2002. Starting with worksheet basics, readers will learn to edit, use functions, format cells, and add graphic objects. Then this Visual QuickStart Guide moves on to charts, printing, databases, Web publishing, and advanced techniques in Excel. This visual guide can be used as a task-based reference or as a tutorial.