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 ...
