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.

Designed to provide non-developers with a hands-on guide to both Excel VBA and XML, this book gives users a wide range of VBA coverage including how to write subroutines and functions from scratch, manipulate files and folders with VBA statements, manage date with arrays and collections, and much more. Includes CD.

Learn how to use Excel without having to decipher technical jargon or wade through a giant manual. By providing straightforward, easy-to-follow explanations and numbered steps, this compact guide shows how to use Excel in the shortest time possible.

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.

The indispensable guide for all managers and business students who wish to use Microsoft Excel to its full potential. As the industry standard spreadsheet for the analysis and presentation of results, Microsoft Excel is indispensable in the business world. This text provides a practical and straightforward guide to using the functions of Microsoft Excel to their full potential, guiding the reader from basic principles through to the more complicated areas such as modelling, the analysis of charts, reporting, and automatic importing of data from the web directly into an Excel workbook. Bernard Liengme has written this book specifically to meet the requirements of business students and professionals working with Microsoft Excel. The text is illustrated throughout with screen-shots, as well as a wide variety of examples and case studies based in real-world business contexts, introduced with a minimum of maths, and readily adaptable to workplace situations. The new edition has been brought fully up to date with the new Microsoft Office XP release of Excel 2002 but can be used alongside any previous version of Excel, with new Excel 2002 features clearly indicated throughout.