From the author of "Special Edition Using Microsoft Excel 2000" comes a reference packed with examples and detailed information on Excel's built-in functions and their uses. The accompanying CD augments the help files, allowing users to link to live workbooks illustrating certain functions. Written for intermediate and advanced users.

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.

Learn quickly and efficiently from a true Excel master using the tried and true Special Edition Using formula for success. Here, readers will find information that's undocumented elsewhere--even in Microsoft's own Help systems.

This one-of-a-kind reference delivers all the tips and techniques you need to maximize one of the most powerful spreadsheet tools: formulas. With clear explanations of operators, nesting, and functions plus hundreds of practical, real-world examples, spreadsheet expert John Walkenbach shares proven solutions for typical (and not-to-typical) Excel challenges. From working with dates to performing table lookups to creating array formulas, this in-depth guide will help you supercharge your spreadsheets -- and make the most of Excel.

For any course teaching application software using Microsoft Office 2000 applications. This book will appeal to students in a variety of disciplines including liberal arts, business, and the sciences. All books in this series offer consistent presentation common design, pedagogy, and writing style. Concepts as well as key-strokes are stressed. Hands-on exercises in every lesson provide just the right amount of practice time. This best-selling author team's hands-on approach and conceptual framework helps students master important concepts, as well as the features of the powerful new Office 2000 applications.

MICROSOFT EXCEL 2000 STEP BY STEP is the easiest and fastest way to teach yourself to use the latest version of Microsoft's popular spreadsheet program. Work through every lesson to complete the full course, or do individual lessons to learn just the skills you need. Either way, you learn at your optimum pace from the teacher who knows you best-you. With this book and Microsoft Excel 2000, you'll learn to: Create worksheets, charts, and graphs to effectively analyze data Quickly organize data using filter and sort Simplify calculations using formulas, AutoCalculate, Subtotal, and other functions Use PivotTables and PivotCharts to summarize and present data in a visual format Liven up presentations by inserting pictures, customizing formats, and adding charts Publish data to the Internet or intranets and work simultaneously with others by sharing a workbook via your company intranet Import data from other sources, merge multiple spreadsheets, and share your work Integrate Microsoft Excel with other Microsoft Office programs Forecast trends and relationships with Goal Seek and Scenario Manager Validate data and help protect work with a password Create and use macros to automate work Format dates for the twenty-first century This book is approved courseware for the Microsoft Office Specialist Program. Go to: http://www.microsoft.com/learning/mcp/officespecialist/default.mspx