Publisher's Synopsis
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
