You, too, can excel -- especially with expert advice from one of the country's leading authorities on spreadsheet software. Whenever you get stuck or need to learn something you've never done before, turn to Microsoft Excel 2000 Bible. With plenty of examples and little-known tips, John Walkenbach guides you step-by-step through the entire program -- from basic cell formatting to the exciting new Web capabilities of Excel 2000.

Explains how to create functional spreadsheets and offers advice on entering data, working with formulas, and importing and converting files

Designed as a reference for business professionals, this guide to Excel 2002 begins with quick primers that move users to proficiency in all categories. It describes features of Excel that are important to business users and provides step-by-step plans for completing common Excel projects. The CD-ROM provides examples of Excel workbooks discussed throughout the book.

This one-stop reference combines the in-a-nutshell approach with detailed comprehensive information, providing readers with everything they need to know about the premier spreadsheet application. Throughout the book, readers will find handy tips to help make better power use of the many new features available in Excel 2000.

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