- Paperback: 984 pages
- Publisher: John Wiley & Sons; Pap/Cdr edition (1 July 2001)
- Language English
- ISBN-10: 0764547992
- ISBN-13: 978-0764547997
- Product Dimensions: 24.1 x 18.9 x 5.4 cm
- Average Customer Review: 4.6 out of 5 stars See all reviews (5 customer reviews)
-
Amazon Bestsellers Rank:
330,840 in Books (See Top 100 in Books)
- #5 in Books > Computers & Internet > Microsoft Windows > Applications > Excel > Excel 2002
- #42 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? Visit the Amazon.co.uk Trade-In Store for more details. |
Product details |
More About the Author
Product Description
Product Description
Get the most out of Excel, Microsoft′s powerful spreadsheet application. With John Walkenbach, the leading Excel expert better known as "Mr. Spreadsheet", discover better ways to analyze data and find solutions using Microsoft Excel 2002.
This book is an excellent resource for getting up to speed using streamlined spreadsheet creation tools, enhanced analysis tools and powerful Web integration. Transform Excel into an application suited to the whole organization so workgroups can work more effectively. Discover how developers can integrate information seamlessly, whether proposal text, financial figures or research data. Whether you are an expert or a novice, Excel 2002 Power Programming with VBA will help you work more efficiently, turning your data into answers you can count on.
Bonus: The book contains a coupon for the Professional Power Utility Pak.
This book is an excellent resource for getting up to speed using streamlined spreadsheet creation tools, enhanced analysis tools and powerful Web integration. Transform Excel into an application suited to the whole organization so workgroups can work more effectively. Discover how developers can integrate information seamlessly, whether proposal text, financial figures or research data. Whether you are an expert or a novice, Excel 2002 Power Programming with VBA will help you work more efficiently, turning your data into answers you can count on.
Bonus: The book contains a coupon for the Professional Power Utility Pak.
From the Back Cover
Excel 2002 Power Programming with VBA Develop Powerful, User–Oriented Excel 2002 Applications With this unique guide, renowned spreadsheet authority John Walkenbach invites you to harness the full potential of Excel–and join the elite group of users and developers who truly understand what the product is capable of. Offering plenty of detailed, well–thought–out examples, he walks you through the basics of Excel application development and VBA programming–and then gives you a lucid, wide–ranging seminar on advanced programming techniques and application development issues. It′s all you need to create user–oriented custom applications that leverage the power of Excel 2002. Your Road Map to Excel Application Development
∗ Take Excel to the next level with formula tricks and techniques
∗ Work with VBA sub procedures and function procedures
∗ Create stellar UserForms as well as custom dialog box alternatives
∗ Develop applications that maximize the power of PivotTables and charts
∗ Incorporate event–handling and interactions with other applications
∗ Build user–friendly toolbars, menus, and help systems
∗ Manipulate files and Visual Basic components and understand class modules
∗ Get advice on compatibility issues and answers to frequently asked Excel programming questions
Bonus CD–ROM Includes
∗ A trial version of the author′s award–winning Power Utility Pak 2000
∗ A demo of the author′s Sound–Proof 2000
∗ Over 175 example Excel workbooks from the book
System Requirements: Pentium PC with Windows 98 or greater; 32 MB RAM; Microsoft Excel 2002. See About the CD appendix for details and complete system requirements. www.mandtbooks.com
∗ Take Excel to the next level with formula tricks and techniques
∗ Work with VBA sub procedures and function procedures
∗ Create stellar UserForms as well as custom dialog box alternatives
∗ Develop applications that maximize the power of PivotTables and charts
∗ Incorporate event–handling and interactions with other applications
∗ Build user–friendly toolbars, menus, and help systems
∗ Manipulate files and Visual Basic components and understand class modules
∗ Get advice on compatibility issues and answers to frequently asked Excel programming questions
Bonus CD–ROM Includes
∗ A trial version of the author′s award–winning Power Utility Pak 2000
∗ A demo of the author′s Sound–Proof 2000
∗ Over 175 example Excel workbooks from the book
System Requirements: Pentium PC with Windows 98 or greater; 32 MB RAM; Microsoft Excel 2002. See About the CD appendix for details and complete system requirements. www.mandtbooks.com
Inside This Book
(Learn More)
First Sentence
To fully appreciate the application development features available in Excel 2002, it's important to understand where this product came from and how it fits into the overall scheme of things. Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
To fully appreciate the application development features available in Excel 2002, it's important to understand where this product came from and how it fits into the overall scheme of things. 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
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
30 of 30 people found the following review helpful:
4.0 out of 5 stars
Informative, straightforward and relevant,
By A Customer
This review is from: Excel 2002 Power Programming with VBA (Paperback)
As a reasonably proficient Excel user who has learnt a few bits of VBA by recording macros and jiggling the code, I found this book to be an excellent resource for the step into writing proper code. As I came across different real-life problems I was able to find the answers quickly and almost without fail. I consider this the acid test of a manual such as this.I even finally read the introduction and gained insight into objects, properties and the like which helped enormously. My only criticism would be the very lengthy introductory chapters - the author states that the book assumes a reasonable knowledge of Excel and then spends 6 chapters and over 100 pages introducing Excel! The writing style is a model of clarity with some nice light touches (no patronising 'VBA for dummies' humour). Very highly recommended
21 of 21 people found the following review helpful:
5.0 out of 5 stars
Excellent Resource for up and coming VBA programmers,
This review is from: Excel 2002 Power Programming with VBA (Paperback)
I'd already cut my teeth writing macros on a couple of databases I was using. I'd started by recording macro's using excels built in recorder, and then looking at the code and trying to work out what did what. But pretty soon I hit brick walls, and needed something to help me understand what was going on properly and walkenbach came to the rescue! This book is aimed exactly at the level I was looking for: someone who is computer literate and has a moderate level of VBA programming experience. The book leads you through the *very* basics before building on the knowledge step by step and eventually becomes just a reference for when you really get stuck or just forget a command. Its absolutely perfect for learning from, and even now, when I would consider myself capable of solving any excel problem using VBA, is a really useful resource. Get it. It won't be money wasted!
14 of 14 people found the following review helpful:
5.0 out of 5 stars
Excellent resource for learning VBA,
By
This review is from: Excel 2002 Power Programming with VBA (Paperback)
Being a long time Excel user with some programmingbackground (but not in VBA), I found this book to be an excellent way to learn VBA. Actually, most of the time I have found it difficult to put it down! Admittedly, it is voluminous, so if you want to get to
Share your thoughts with other customers: Create your own review
Would you like to see more reviews about this item?
|
Most Recent Customer Reviews |
Listmania!
Look for similar items by category
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- 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
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.
