Books‎ > ‎Computers & Internet‎ > ‎Programming‎ > ‎

Excel Programming: Your visual blueprint for creating interactive spreadsheets | By Denise Etheridge

posted Sep 9, 2013, 1:44 AM by Free EBook   [ updated Sep 9, 2013, 2:20 AM ]

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.

Product Details
Excel Programming: Your visual blueprint for creating interactive spreadsheets

Buy at Amazon

Average customer review:  
(4 customer reviews)

Product Details

  • Amazon Sales Rank: #562568 in eBooks
  • Published on: 2011-01-14
  • Released on: 2011-01-14
  • Format: Kindle eBook
  • Number of items: 1

Editorial Reviews

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

Customer Reviews

Most helpful customer reviews

4 of 4 people found the following review helpful.
4Useful material 
By Monik Montreal 
This is a very good material for self-taught excel users.
To consider:
- you must be already quite good in excel
- if you need extensive explanations, this book is NOT for you
- if you have the excel-instinct and intuition this book will support you to go further
- the structure of the book is good for 'impatient' users (as me) who do not like reading a lot but prefer going directly to the 'action'
- to become an excel-macro-guru you might need more advanced materials

0 of 0 people found the following review helpful.
5Best I have seen 
By M. Pizza 
This book is my go to book when I need to understand a new VBA concept, or I just need to see an example. It is topic oriented much like a Dummies book, but laid out much better, and dare I say easier to follow.

0 of 0 people found the following review helpful.
4It's more of a dictionary of VB for Excel 
By Richard R. Dupree 
I first found this book in a local bookstore when I was looking around to kill some time between meetings. I ordered a copy from Amazon at a considerably lower price. It is more like a dictionary or quick reference guide with only 2 pages devoted to most commands. They do include several examples of usage. It is not a typical programming book - they don't take any particular problem and discuss the solution over 10-20 pages. It assumes you know how to use Excel and have a good programming background. I'd definitely recommend it as one tool to help those working in Excel wth VB. You can do some really neat things and automate a lot of tasks if you have the time and patience.