Excel VBA 24-Hour Trainer (Wrox Programmer to Programmer) - Softcover

Urtis, Tom

 
9780470890691: Excel VBA 24-Hour Trainer (Wrox Programmer to Programmer)
Softcover
ISBN 10: 047089069X ISBN 13: 9780470890691
Verlag: John Wiley & Sons, 2011

Inhaltsangabe

This unique book-and-DVD package helps even non-programmers extend Excel with VBA
 
Virtually every manual task in Excel can be automated with VBA, which increases your productivity and saves enormous amounts of time. This unique book-and-DVD package prepares you to get more out of Excel by using Visual Basic for Applications (VBA) to automate many routine or labor-intensive Excel tasks. Microsoft Excel MVP and author Tom Urtis walks through a series of lessons and illustrations, while the accompanying DVD provides demos and screencasts to complement each lesson.
* Introduces you to programming with Visual Basic for Applications (VBA), macro composition, and the programming environment
* Explains events programming, embedded controls, user forms, message boxes, input boxes, looping, and more
* Shows you how to control other Office applications from Excel, such as Word, Outlook, Access, and PowerPoint
* Includes enhanced coverage of each lesson on the DVD, which also offers detailed examples
* Provides ideas for applying VBA to everyday tasks in a way that's both practical and fun
 
Use this book-and-DVD package to get the total learning experience of VBA for Excel!

Die Inhaltsangabe kann sich auf eine andere Ausgabe dieses Titels beziehen.

Über die Autorin bzw. den Autor

Tom Urtis is a Microsoft Office developer, programmer, instructor, and Microsoft Excel MVP. Tom is founder of Atlas Programming Management (www.atlaspm.com), a Silicon Valley-based Office business solutions company specializing in Excel, providing consulting, development, training, and support of fully customized Office programs for a diverse international clientele.

Von der hinteren Coverseite

Increase your productivity and save time and effort with Excel VBA
 
This unique book-and-DVD package prepares you to get more out of Excel by using Visual Basic for Applications (VBA) to automate your routine or labor-intensive Excel tasks. Microsoft Excel MVP and author Tom Urtis walks through a series of lessons while the accompanying DVD provides demos to complement each lesson. Urtis takes an in-depth look at how manual tasks in Excel can be programmed with VBA for greater speed, efficiency, and accuracy. You'll learn how to use VBA to manipulate Excel in ways you may never have thought possible.
 
Excel VBA 24-Hour Trainer:
* Introduces you to VBA and discusses topics including object orientedprogramming, variable declaration, objects and collections, and arrays
* Teaches you how to write your own macros for programming loops, events, charts, pivot tables and pivot charts, and user-defined functions
* Shows you how to customize the look and feel of Excel with UserForms, Input Boxes, Message Boxes, and embedded controls
* Examines advanced topics including class modules, add-ins, and retrieving external data with ADO and SQL
* Demonstrates how to interact with other Office Applications from Excel, including Word, Access(r), PowerPoint(r), and Outlook(r)
 
Wrox guides are crafted to make learning programming languages and technologies easier than you think. Written by programmers for programmers, they provide a structured, tutorial format that will guide you through all the techniques involved.
 
On the DVD
 
Don't just learn-do!
 
The lessons within the book are accompanied by an instructional demonstration on the DVD.
* Write your own macros
* Make decisions with VBA
* Repeat actions with loops
* Automate procedures with worksheet and workbook events
* Work with arrays
* Create class modules
* Program charts and pivot tables
* Create add-ins
* Interact with Office applications Word, Access, PowerPoint, and Outlook
* Manage external data
* Debug your code

„Über diesen Titel“ kann sich auf eine andere Ausgabe dieses Titels beziehen.

Verlag
John Wiley & Sons
Erscheinungsdatum
2011
Sprache
Englisch
ISBN 10 
047089069X
ISBN 13 
9780470890691
Einband
Taschenbuch
Auflage
1
Anzahl der Seiten
432
Kontakt zum Hersteller
Nicht verfügbar
Verantwortliche Person
Nicht verfügbar

Weitere beliebte Ausgaben desselben Titels

9788126531394: EXCEL VBA 24-HOUR TRAINER

Vorgestellte Ausgabe

ISBN 10:  8126531398 ISBN 13:  9788126531394
Verlag: Wiley India Private Limited, 2011
Softcover