|
||||||||||||||||||||
|
||||||||||||||||||||
|
||||||||||||||||||||
Produktinformation
Möchten Sie die Produktinformationen aktualisieren oder Feedback zu den Produktabbildungen geben?
Ist der Verkauf dieses Produkts für Sie nicht akzeptabel? |
Mehr über den Autor
Entdecken Sie Bücher, lesen Sie über Autoren und mehr
› Besuchen Sie die Seite von John Walkenbach auf Amazon
› Besuchen Sie die Seite von John Walkenbach auf Amazon
Produktbeschreibungen
Kurzbeschreibung
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.
Synopsis
Master the programming features in Excel 2002 and unleash the power of VBA (VIsual Basic for Applications). With the author's expert guideance, you should quickly lean how to harness the full programming power of Excel 2002 - from UserForms to class modules.
In diesem Buch
(Mehr dazu)
Einleitungssatz
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. Lesen Sie die erste Seite
Buchdeckel | Copyright | Inhaltsverzeichnis | Auszug | Stichwortverzeichnis | Rückseite
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. Lesen Sie die erste Seite
Mehr entdecken
Wortanzeiger
Ausgewählte Seiten ansehenWortanzeiger
Buchdeckel | Copyright | Inhaltsverzeichnis | Auszug | Stichwortverzeichnis | Rückseite
Tags(Was ist das?)Bei einem Tag handelt es sich um ein Schlagwort, das zum Produkt passt.
Tags erleichtern allen Kunden die Suche und die Sortierung ihrer Lieblingsprodukte. |
Eine digitale Version dieses Buchs im Kindle-Shop verkaufen
Wenn Sie ein Verleger oder Autor sind und die digitalen Rechte an einem Buch haben, können Sie die digitale Version des Buchs in unserem Kindle-Shop verkaufen.
Weitere Informationen
Kundenrezensionen
Die hilfreichsten Kundenrezensionen
1 von 2 Kunden fanden die folgende Rezension hilfreich
Format:Taschenbuch
Kann dieses Buch in jeder Hinsicht empfehlen. Sehr viele Beispiele, sehr verständlich ausgedrückt (Ami-Buch halt).
Am Anfang erfolgt eine kurze Excel-Einführung (die man jedoch überspringen kann), dann folgen die VBA-Grundlagen. Die späteren Kapitel bauen nicht zu sehr aufeinander auf, so dass man dieses Buch auch als Nachschlagewerk verwenden kann.
Die hilfreichsten Kundenrezensionen auf Amazon.com (beta)
Amazon.com:
23 Rezensionen
45 von 46 Kunden fanden die folgende Rezension hilfreich
Great book--highly recommended
31. August 2002
Format:Taschenbuch
I am a real estate finance analyst and researcher who wanted more control over the manipulation of my data in Excel as well as learning how to create user forms. John Walkenbach's "Excel 2002 Power Programming with VBA" was an informative and excellent resource that taught me most of what I was looking for. Walkenbach begins with a brief explanation of Excel and the fundamentals of object-oriented programming (OOP), which underpins VBA. The reader has to be patient and be willing to experiment; working through Walkenbach's examples with Excel open is almost a must.
There are several issues that I would like to point out. One reviewer was upset over the fact that Walkenbach did not offer some utilities from the book's CDs for free. I did not try any of the utilities because I was more interested in the book's actual contents and explanations. Walkenbach does, however, offer the reader a full and unrestricted PDF version of the book in the CD, which I think is mighty generous of him. Instead of lugging the +1,000 page book, I sometimes leave the PDF version on my laptop so I could always have it with me. Lastly, I use Excel 97 at work and Excel X on the Mac at home, and despite some minor incompatibility issues, I would say that the book for the most part could be used for all versions of Excel 97 and up.
BTW, I would also recommend "Excel 2002 VBA" by Bullen, Green, Bovey, and Rosenberg published by Worx Press for a more advanced treatment of VBA.
30 von 32 Kunden fanden die folgende Rezension hilfreich
A well written book
22. Juli 2002
Format:Taschenbuch
I went over this book twice. Although I believe I understood most of it, I am not yet a power programmer.
This book is an intermediate book on Excel programming. Don't expect to become an expert from it. The book is very well written and John Walkenbach writes in a way that no other programmer does. The book stimulates the interest of the reader into Excel. The examples are well explained. I did not give this book five stars because the Windows API is not explained in depth.
According to me the path of the books to Excel programming is:
1 Excel The Bible( the second half of the book)
2 Excel for Power Programmers
3 Excel 2002 VBA Programmer's reference
The last book in the list is not for inexperienced programmers and is not as pleasant to read( So do not start with it).
I also recommen Excel 2002 formulas if the would be programmer does not have an extensive experience in Excel
This book is an intermediate book on Excel programming. Don't expect to become an expert from it. The book is very well written and John Walkenbach writes in a way that no other programmer does. The book stimulates the interest of the reader into Excel. The examples are well explained. I did not give this book five stars because the Windows API is not explained in depth.
According to me the path of the books to Excel programming is:
1 Excel The Bible( the second half of the book)
2 Excel for Power Programmers
3 Excel 2002 VBA Programmer's reference
The last book in the list is not for inexperienced programmers and is not as pleasant to read( So do not start with it).
I also recommen Excel 2002 formulas if the would be programmer does not have an extensive experience in Excel
23 von 24 Kunden fanden die folgende Rezension hilfreich
A great book on VBA
2. März 2002
Format:Taschenbuch|Von Amazon bestätigter Kauf
I got this book and the author's other on Formulas. Although I am only using Excel 2000, I got it because I would be using Excel 2002 in the future. With no experience in VBA for MS apps, I needed something to get me up and running with writing macros from scratch. Familiar with VB6 I figure I can pick VBA up easily. I had a book on VBA from SAMS teach yourself series some years back, which I found dry and useless. I had thrown it away so I got this book.
I was up and running in about two hours writing macros that would look down a column of data and find the last non-empty cell in a range that had empty cells between data cells. I also wrote macros to update a summary at the top of the worksheet depending on how much data was in a particular row and to advance to the next empty cell in a row after data was entered, assisting the user in entering/selecting data.
Excellent and easy to understand. The real meat doesn't start until Chapter 7 when VBA is introduced. Prior to that is a refresher on formulas and Excel itself. I'm results oriented so I skimmed up to Chapter 7 before looking for answers to my problem. I am only in Chapter 9, before userforms, which is overkill for my needs at work but I will begin tinkering since it'll be done on my own time. Highly recommended for those who need a good solid intro to VBA. If you know VB, it'll be cake walk. For those who don't, there are plenty of examples to help you out and remember to understand the Excel object model. You should be all set if you at least try some of the examples instead of staring at the print.
The only thing I think is missing is a listing of the methods and properties of the Excel object model. For that, I have "Excel 2002 VBA" by Wrox. Funny how I've only used that book for its listing in its appendix, which is several hundred pages long and easily worth the price of that book. But that's another review...
Waren diese Rezensionen hilfreich?
Wir wollen von Ihnen hören.
Kunden diskutieren
|
Das Forum zu diesem Produkt
Fragen stellen, Meinungen austauschen, Einblicke gewinnen Aktive Diskussionen in ähnlichen Foren
Kundendiskussionen durchsuchen
|
Ähnliche Foren
|
||||||||||||||||||||||||||||||||||
Lieblingslisten
Ähnliche Artikel finden
Anhand des Sachgebietes nach ähnlichen Produkten suchen:
Ihr Kommentar
Möchten Sie die Produktinformationen aktualisieren oder Feedback zu den Produktabbildungen geben?
|
