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 reference useful for Excel beginners, intermediate users, power users, and would-be power users everywhere, this book provides Excel tips, tricks, and techniques. It covers the Excel interface, file formats, interactivity with other Office applications, and collaboration features. It includes a CD-ROM with templates and worksheets from the book.

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.

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

Covers the basics most Excel users need to know, including: opening, saving protecting, and recovering workbook files and using workbook templates; adding, copying, and deleting worksheets, e-mailing worksheet data, and publishing worksheet data to the Web; entering and editing data and text and working with cells and ranges; and more.

A manual on Excel 2000, providing an alphabetical listing and step-by-step instructions. It covers QuickTime VR, options that allow users to share tasks on one worksheet, and document publishing on the Web. It also covers tasks such as changing print settings, analyzing data and customizing charts.

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

Suitable for the Excel programmer, this title also contains what you need to know about: creating stellar UserForms and custom dialog box alternatives; working with VBA subprocedures and function procedures; incorporating event-handling and interactions with other applications; and building user-friendly toolbars, menus, and help systems.

Spreadsheet software is a class of very interactive computer programs with interfaces that consist of rows and columns that are displayed on-screen in a scrollable window. With Microsoft's popular Excel 2002, you can manipulate and analyze data in ways that would be impossible, very cumbersome, and definitely error prone for you to do manually.

Suitable for beginners and power users, this book includes examples, techniques, and tips. It helps readers understand formulas, functions, tables, worksheets, and workbooks; explore unlimited conditional formatting; develop custom functions and create UserForms; and analyze data with external database files and pivot tables.

Containing examples, techniques, and tips, this title helps you learn how to master Excel's 'menuless' Ribbon interface, develop custom functions, create UserForms, and analyze data with external database files and PivotTables.

Suitable for Excel beginners, intermediate users, and power users, this book offers the Excel tips, tricks, and techniques. It covers the topics such as Excel interface, file formats, interactivity with other Office applications, and collaboration features. It includes a CD-ROM with templates and worksheets from the book.

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.

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.

Provides answers to frequently asked questions in Excel 2007. This work helps you to find just what you need to know about navigating the new interface; using the Ribbon and Quick Access toolbar; saving, protecting, and recovering workbook files; entering and editing data; creating formulas and functions, and more.

With examples and tips, the Excel 2002 Bible guides you step-by-step through the entire program - from basic cell formatting to the new Web capabilities of Excel 2002.

Consists of a series of non trivial tips and tricks that cover various aspects of Excel. This book includes tips and tricks on dealing with function arguments, creating charts, pivot tables, taming the Ribbon, why use a UserForm, how to create add ins in Excel 2007, absolute vs. relative references, and changing data entry orientation.

A basic guide for programmers to the new version of Excel covering areas including: macro programming, using ActiveX controls and designing custom dialog boxes. A 3.5 disk is included containing sample code to save time retyping.

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.