Excel Programming: Your visual blueprint for creating interactive spreadsheets - Softcover

Etheridge, Denise

Softcover

ISBN 10: 0470591595 ISBN 13: 9780470591598

Publisher: John Wiley & Sons, 2010

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.

About this title

About the Author

Denise Etheridge is a certified public accountant as well as the president and founder of Baycon Group, Inc. She publishes Web sites and authors computer related books. You can visit www.baycongroup.com to view her online tutorials.

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

Edition details

• Publisher: John Wiley & Sons
• Publication date: 2010
• Language: English
• ISBN 10: 0470591595
• ISBN 13: 9780470591598
• Binding: Paperback
• Edition number: 3
• Number of pages: 368