For courses in Microsoft Excel 2002. This text is highly-visual and skills-based, delivering the steps in a screen-by-screen format. Learn.edu methodology gives quick framework for success in Office XP and the series is certified to the core level of Microsoft XP.
For courses in Microsoft Office Professional 2002 and Excel 2002. This text is highly-visual and skills-based, delivering the steps in a screen-by-screen format. Learn.edu methodology gives quick framework for success in Office XP and the series is certified to the core level of Microsoft XP.
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].
For courses in Microsoft Office Professional 2002 and Excel 2002. This text is highly-visual and skills-based, delivering the steps in a screen-by-screen format. Learn.edu methodology gives quick framework for success in Office XP and the series is certified to the core level of Microsoft XP.
The I-Series textbooks strongly emphasize that students learn and master applications skills by being actively engaged. The text has been written with clear steps to help students accomplish tasks that lead to a finished document, worksheet or database table. The authors believe that teaching how to perform these tasks is not enough for complete understanding and mastery; so they also discuss why the steps that students are about to experience are important, and what role they play in the overall plan.
Part of the highly successful Shelly Cashman Series, Microsoft Excel 2002 Comprehensive Concepts and Techniques provides step-by-step instructions accompanied by full-color screen shots, helping students learn basic through expert-level Excel 2002 skills quickly and easily.
Office 2002 is the next version (after Office 2000) of Microsoft's program suite that includes Word, Access, Outlook and Excel. The aim of 2002 is to take advantage of Office's core position within most business systems and make it the interface to business processes and web services. One of the most significant advances is the XML capability that has been added to Access and Excel, with the latter becoming the key to future Web Service integration and an essential part of any Office developer's skill set. -- Written by two active and popular members of the Excel community -- Includes coverage of all the new features including smart tags, pivot tables, and web components -- Examines all the new XML capabilities that 2002 brings to the Excel world
SERIES TAGLINE: The O'Leary Series is the true step-by step way to develop computer application skills.Its design emphasizes the step-by step visual approach with screen captures for every concept.