Verwandte Artikel zu 101 Ready-To-Use Excel Macros: With downloadable code...

101 Ready-To-Use Excel Macros: With downloadable code (Mr. Spreadsheet's Bookshelf) - Softcover

Alexander, Michael

 
9781118281215: 101 Ready-To-Use Excel Macros: With downloadable code (Mr. Spreadsheet's Bookshelf)
Softcover
ISBN 10: 1118281217 ISBN 13: 9781118281215
Verlag: John Wiley & Sons, 2012

Inhaltsangabe

Save time and be more productive with this helpful guide to Excel macros!
 
While most books about Excel macros offer only minor examples, usually aimed at illustrating a particular topic, this invaluable resource provides you with the tools needed to efficiently and effectively program Excel macros immediately. Step-by-step instructions show you how to create VBA macros and explain how to customize your applications to look and work exactly as you want them to. By the end of the book, you will understand how each featured macro works, be able to reuse the macros included in the book and online, and modify the macro for personal use.
* Shows you how to solve common problems with the featured macros, even if you lack extensive programming knowledge
* Outlines a problem that needs to be solved and provides the actual Excel macro, as well as the downloadable code, to solve the problem
* Provides an explanation of how each macro works and where to use the macro
 
With 101 Ready-to-Use Excel Macros, Microsoft MVP Michael Alexander helps you save time, automate tasks, and ultimately be more productive.

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

Über die Autorin bzw. den Autor

Mike Alexander is a Microsoft Certified Application Developer (MCAD) and author of several books on advanced business analysis with Microsoft Access and Excel. He has more than 15 years of experience consulting and developing Office solutions. Michael has been named a Microsoft MVP for his ongoing contributions to the Excel community. In his spare time, he runs a free tutorial site, www.datapigtechnologies.com, where he shares Excel and Access tips.
 
John Walkenbach is author of more than 50 spreadsheet books and lives in southern Arizona.
Visit his website at http://spreadsheetpage.com.

Von der hinteren Coverseite

Save time and increase productivity with these macros
 
Excel macros can make your work easier and you more productive by automating common tasks. But there can be a bit of learning curve when it comes to creating your own macros. If you need immediate help and don't have weeks to learn Visual Basic for Applications (VBA), you've come to the right place. This helpful guide arms you with 101 Excel macros that will solve your issues now!
 
Inside you'll find step-by-step instructions for creating these VBA macros, which you can then customize for your applications. This book offers tips, tricks, and detailed explanations along with the actual Excel macros so you can see how they work and where they can be applied. You'll then be able to immediately implement the code and reuse it in other workbooks as you quickly become a macro pro.
 
Let Mr. Spreadsheet show you how to:
* Go beyond recording simple macros
* Dynamically manipulate workbooks and worksheets
* Write code to manage cell or range changes
* Automate PivotTable features
* Use VBA to simplify charting and dashboarding
* Write macros to send e-mails directly from Excel
* Integrate Excel with other Microsoft Office applications
 
COMPANION WEBSITE
 
Visit www.wiley.com/go/101excelmacros to download workbook files for all examples used in the book.

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

Verlag
John Wiley & Sons
Erscheinungsdatum
2012
Sprache
Englisch
ISBN 10 
1118281217
ISBN 13 
9781118281215
Einband
Taschenbuch
Auflage
1
Anzahl der Seiten
336
Kontakt zum Hersteller
Nicht verfügbar
Verantwortliche Person
Nicht verfügbar