Excel Programming: Your visual blueprint for creating interactive spreadsheets

Etheridge, Denise

ISBN 10: 0470591595 / ISBN 13: 9780470591598

Published by Visual, 2010

About this Item

Connecting readers with great books since 1972! Used books may not include companion materials, and may have some shelf wear or limited writing. We ship orders daily and Customer Service is our top priority! Seller Inventory # S_425269725

Bibliographic Details

Title: Excel Programming: Your visual blueprint for...

Publisher: Visual

Publication Date: 2010

Binding: paperback

Condition: Very Good

Edition: 3rd Edition

About this title

Synopsis:

A great guide to Excel programming that is perfect for visual learners and takes you beyond Excel basics!

This book is the perfect reference for Excel users who want to delve deeper into the application to create powerful and dynamic programs. From creating macros to customizing dialog boxes, this step-by-step guide helps you get more out of Excel than you knew was possible. Each step has callouts so you can see exactly where the action takes place and this Web site offers tons of usable code and sample macros that you can put to use instantly.

• Explains step-by-step how to automate Excel, the world's leading spreadsheet application from Microsoft
• Covers most tasks in two-page spreads -- no flipping back and forth required!
• Teaches you over 130 tasks, including how to record macros, program in Visual Basic for Applications (VBA), debug code, automate charts, interface with other macros, automate functions -- all in an easy-to-follow visual format
• Uses clear, step-by-step, numbered instruction and lots of graphics and screenshots -- perfect for visual learners!
• Helps you maximize your productivity with practical examples, tips, and advice

 Harness everything that Excel has to offer with this friendly, practical, visual guide.

From the Back Cover:

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