Excel Programming

Excel Programming 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

About This Edition