Top
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
