Ideal for use as a self-paced training guide or for instructor-led training, this book offers fast-paced tutorials and learning exercises for quickly grasping spreadsheet basics and building proficiency.

This easy to use, approachable guide provides fast-paced, to-the-point tutorials and learning exercises for quickly grasping application basics and building proficiency. Designed for the beginning to intermediate student, the book can be used for self training and instructor-led classes, focusing on using the computer to get specific tasks done at home or at work.

Experienced Excel users who want to extend their applications abilities will benefit from the beginning tools that will teach readers how to record and edit macros, and then focus on creating small but powerful functions and subroutines.

All the methods and tools you need to successfully program with Excel John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Featuring a complete introduction to Visual Basic for Applications and fully updated for the new features of Excel 2010, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel’s capabilities with VBA. Offers an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA) Features invaluable advice from "Mr. Spreadsheet" himself (bestselling author John Walkenbach), who demonstrates all the techniques you need to create large and small Excel applications Provides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you won’t find anywhere else This power-user's guide is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA.

An easy-to-use learning tool for beginning to intermediate PC users that offers fast-paced, concise tutorials and learning exercises for quickly grasping the latest Web creation application.

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.

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