Master the programming features in Excel 2002 and unleash the power of VBA (VIsual Basic for Applications). With the author's expert guideance, you should quickly lean how to harness the full programming power of Excel 2002 - from UserForms to class modules.

Formulas are the lifeblood of spreadsheets. The author delves deeply into understanding, creating, and applying formulas in topics ranging from basic workbooks to charts, pivot tables, and advanced Excel applications. He also examines financial formulas, and teaches you to develop custom worksheet functions with VBA. It also includes a CD-ROM.

Focused on report development using OLTP databases, this book offers comprehensive information on both technical and strategic aspects. It helps to examine the main features of Excel's reporting technology-PivotTable reports, Spreadsheet reports, parameter queries, and web components.

An Excel expert shows how to master the charting features in Excel 2000 and 2002 to create graphic representations of data. Basic and advanced features are covered, focusing on the new charting features provided in version 2002.

Teach yourself how to use the data-presentation and number-crunching power in the latest version of Microsoft Excel - one step at a time! Learn exactly the skills you need for Excel 2003 using easy, self paced lessons and hands-on practice exercises.

A comprehensive guidebook on Excel, a popular spreadsheet program, including X features.

Shows you how to solve real-world business problems by taking Excel's data analysis features to the max. This book focuses on the needs of business users. It teaches how to turn Excel functionality into actual solutions for the business problems that confront them.

Updated for Excel 2002, this text offers Excel power-users, as well as programmers who are unfamiliar with the Excel object model, with an introduction to writing Visual Basic for Applications (VBA) macros and programs for Excel.

A reference tool on Excel 2000. It discusses how to get Excel to work for maximum results, focuses on Excel 2000 Internet publishing features, covers creating HTML documents in Excel and publishing them on the Web, and looks at sharing documents across a corporate intranet.

Aims to consolidate functionality of pivot tables. This title is intended to help automate pivot tables using VBA, create pivot tables with external data in OLAP cubes, and create reporting systems.

Excel Annoyances addresses the quirks, bugs, and hidden features found in the various versions of the Excel spreadsheet program. Broken down into several easy-to-follow categories such as Entering Data, Formatting, Charting, and Printing, it uncovers a goldmine of helpful nuggets that you can use to maximize Excel's seemingly limitless potential.

Covering formulas, charts, data lists, macros, and versions 2000, 2002, and 2003, this book offers more than seventy easy-to-follow techniques that show both fresh and experienced Excel users how to save time and avoid tedious or redundant tasks.

Excel is the most widely used spreadsheet application in the world, especially in business settings, and is supported in over 40 countries. It is the spreadsheet and data analysis tool attached to the Microsoft Office suite, and this guide is fully updated for the newest release.

Includes step by step instructions for creating VBA macros. This guide shows you how to use VBA to create Excel apps. It explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and more.

Offers procedures, tips, and ideas for expanding Excel's capabilities with Visual Basic[registered] for Applications.

Excel for the CEO is about computers/software.

This book is about applying financial concepts via Excel -- financial mathematics can be applied more quickly and easily in Excel than any other package.

A step-by-step guide to Excel for Microsoft Office 97. The book covers the very basics of Excel before moving on to important features like using dialoge boxes and toolbars.

Suitable for intermediate to advanced Excel users who want to learn Visual Basic Editor (VBE) programming, this book helps you take your skills (and your spreadsheets) to the next level. It includes an introduction to the VBA language and the essential VBA language elements, including comments, variables and constants, and labels.

A how-to guide that teaches you to use the complete range of Excel programming tasks to solve problems. This work also provides discussion of how the Excel object model works with .NET tools, including Visual Studio Tools for Office (VSTO), for the developers looking forward to .NET development.