- Paperback: 300 pages
- Publisher: MICROSOFT PRESS; 1 edition (1 Oct 2001)
- Language English
- ISBN-10: 0735613591
- ISBN-13: 978-0735613591
- Product Dimensions: 23.1 x 18.8 x 2.8 cm
- Average Customer Review: 4.0 out of 5 stars See all reviews (1 customer review)
-
Amazon Bestsellers Rank:
178,898 in Books (See Top 100 in Books)
- #1 in Books > Computers & Internet > Microsoft Windows > Applications > Excel > Excel 2002
- #20 in Books > Computers & Internet > Software & Graphics > Applications > Microsoft Excel
- #21 in Books > Computers & Internet > Microsoft Windows > Applications > Excel > Programming
- See Complete Table of Contents
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details. |
Product details |
More About the Author
Product Description
Product Description
Teach yourself how to use Microsoft® Visual Basic® for Applications (VBA) to take command of Microsoft Excel Version 2002. Choose your own best starting point in this self-paced guide to learn how to automate spreadsheets, write your own functions and procedures, customize menus and toolbars, and more. Easy-to-follow lessons with real-world scenarios and examples show you exactly how to maximize the built-in programming power in Microsoft Excel 2002. Numerous screenshots and a CD full of practice files help you master step-by-step programming procedures. Find out how to create custom solutions with Microsoft Excel and this book—then keep it nearby as an ongoing desktop reference to VBA functions and features. Learn at your own pace how to: • Use macros to automate simple and complex tasks • Manipulate workbooks and worksheets • Explore range objects • Work with graphical objects • Build and manipulate PivotTable® objects • Create loops and conditional statements with Visual Basic • Use dialog box controls on worksheets • Create and use custom functions and handle macro errors • Create custom toolbar buttons, menu commands, command buttons, event handlers, and dialog boxes
From the Publisher
The beginner developer’s personal training system of easy step-by-step lessons and practice files for customizing Excel Version 2002, as well as an ongoing reference resource to VBA functions. The easiest way to teach yourself how to exploit the built-in power of VBA in Excel Version 2002—one step at a time.
Inside This Book
(Learn More)
First Sentence
Last month, I lost the remote control to my VCR. Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Last month, I lost the remote control to my VCR. Read the first page
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Reviews
Most Helpful Customer Reviews
Format:Paperback
I had a project at work where I needed to use the arcahic Excel 2002 to automatically generate reports. Obviously the newer editions contained features I did niot have, but fortunately I found this gem, which after 6 chapters got me up and running. It is easy to follow and there is a CD with all the worksheets included. Ideal for beginners, but you will soon find you go way beyond it.
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
13 reviews
39 of 39 people found the following review helpful
Good First Introduction, A Trainer For Non-Programmers
14 July 2003
Format:Paperback|Amazon Verified Purchase
This book is clearly a training manual for non-programmers wanting to do Excel macros. It is not intended for experienced programmers except as a quick overview. Nevertheless, the author introduces object-oriented programming terminology early and uses it consistently in an easy (most of the time), non-threatening way. Non-programmers, who carefully work through each of the excellent examples, without knowing it, will have picked up the basics of object-oriented programming while finding countless ways to automate their day-to-day work.
As macro writing becomes more and more like regular programming, learning to use an editor and program development environment becomes more important. Nice use is made here of the VB Editor with emphasis on the Object Browser and the Immediate window - preparing the reader for perhaps moving on to more sophisticated development environments such as Visual Studio, which of course is not covered in this book. (Programming Office applications is included in the latest Visual Studio beta.)
It is a joy to find a book that teaches macros with VBA in a way that permits easily moving on to more general software development with VB. The early Office macro languages were well removed from "real" programming; but VBA has changed that. OK, so perhaps it is softball and not baseball. This is a great book to give to an administrative Microsoft Office workaholic who is restless for more knowledge and might just become a self-taught developer.
This book has a 2001 copyright; but as I write in July 2003 I still cannot find a better first book for VBA with Excel for non-programmers.
On July 24, 2003, I want to add that there are two speed bumps in the book where the content is decidedly more difficult than the balance of the book. The first, midway through the book, is a chapter on manipulating Pivot Tables; and the second is an overly-fancy final chapter with lots of Pivot Table and graphics content. Both of these chapters are useful; but the level of difficulty seems two steps up from the other chapters. Perhaps these two chapters prompted some of the negative comments by others. You can safely skip these two (of twelve) chapters if you wish.
12 of 12 people found the following review helpful
Very accessible and useful book
30 Jan 2002
Format:Paperback
I have had bad luck with most programming books. I bought this one as a VBA reference to fill in the blanks of some of the others. This is by far the best programming book I have ever read, and the first one that I read cover to cover. Not only does this book provide the intuition and practical examples, it does so in a readable and accessible fashion. With it I not only improved my programming skills, but learned some Excel tricks that I have never before seen. I highly recommend.
8 of 8 people found the following review helpful
Jacobson is clear and concise for learning the Range Object
27 Aug 2003
Format:Paperback
I read this book two editions ago and it helped me convert all the workbooks for a large California bank from Lotus and older Excel formats. The book teaches you to use the Range object which is the main Object in Excel. Once you know it you can do most things with a little help from the great macro recording facility of Excel--you just generalize a few terms and apply your new knowledge of the Range Object. Thank you Reed!
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
- Books > Business, Finance & Law
- Books > Computing & Internet > Microsoft Windows > Applications > Excel > Excel 2002
- Books > Computing & Internet > Microsoft Windows > Applications > Excel > Programming
- Books > Computing & Internet > Software & Graphics > Business & Home Office > Spreadsheets > Microsoft Excel
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
