Excel Programming: Your visual blueprint for creating interactive spreadsheets

Excel Programming: Your visual blueprint for creating interactive spreadsheets

by Denise Etheridge
     
 

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

See more details below

Overview

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

Read More

Product Details

ISBN-13:
9780470591598
Publisher:
Wiley
Publication date:
08/24/2010
Series:
Visual Blueprint Series, #28
Pages:
368
Sales rank:
1,316,414
Product dimensions:
7.40(w) x 9.00(h) x 1.00(d)

Related Subjects

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >