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
| ISBN: | 9780470591598 |
| Publication date: | 23rd July 2010 |
| Author: | Denise Etheridge, Jinjer L Simon |
| Publisher: | John Wiley & Sons, Inc. an imprint of Wiley |
| Format: | Paperback |
| Pagination: | 352 pages |
| Series: | Visual Read Less - Learn More |
| Genres: |
Computer programming / software engineering Business applications |
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
Excel Programming features in the following genres: Computer programming / software engineering, Business applications
Excel Programming is available in Paperback
Excel Programming was written by Denise Etheridge, Jinjer L Simon and published by John Wiley & Sons, Inc. an imprint of Wiley
Excel Programming has 352 pages
Yes it is part of Visual Read Less - Learn More series