Excel Programming: Your Visual Blueprint for Creating Interactive Spreadsheets - Softcover

Reseña del editor

A great guide to Excel programming that is perfect for visual learners and takes you beyond Excel basics!This book is the perfect reference for Excel users who want to delve deeper into the application to create powerful and dynamic programs. From creating macros to customizing dialog boxes, this step-by-step guide helps you get more out of Excel than you knew was possible. Each step has callouts so you can see exactly where the action takes place and this Web site offers tons of usable code and sample macros that you can put to use instantly. * Explains step-by-step how to automate Excel, the world's leading spreadsheet application from Microsoft * Covers most tasks in two-page spreads -- no flipping back and forth required! * Teaches you over 130 tasks, including how to record macros, program in Visual Basic for Applications (VBA), debug code, automate charts, interface with other macros, automate functions -- all in an easy-to-follow visual format * Uses clear, step-by-step, numbered instruction and lots of graphics and screenshots -- perfect for visual learners! * Helps you maximize your productivity with practical examples, tips, and advice Harness everything that Excel has to offer with this friendly, practical, visual guide.

Contraportada

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 140 key Excel programming techniques, including:

• Assigning digital signatures to macros

• Using the Visual Basic Editor

• Understanding variable and data types

• Declaring a multidimensional array

• Creating If Then Else statements

• Working with workbooks and files

• Adding comments to a cell

• Creating and filtering PivotTables

• Automating procedures with Excel events

• Importing and exporting XML files

• High-resolution screen shots demonstrate each task

• Succinct explanations walk you through step by step

• Two-page lessons break big topics into bite-sized modules

• "Apply It" and "Extra" sidebars highlight useful tips

Companion Web site features usable code from the book and sample macros