Autorentext
Gail Perry (Indianapolis, IN) is a CPA, author and software trainer from Indianapolis, IN. She has been editing the TurboTax product documentation for Intuit for the past several years. In addition, she's written several books on Excel, including Excel Answers 2000! for Osborne.
Klappentext
Zusammenfassung
Get beyond the basics with Excel 2007 macrosNow you can take your Excel skills to the next level with help from this hands-on guide. Excel 2007 Macros Made Easy shows you how to create, run, and revise macros to simplify repetitive tasks and store the instructions for complicated ones. You'll learn to use Visual Basic for Applications (VBA), add macros to the Excel toolbar, and share your macros with other users. Discover how easy it is to develop custom macros, save time, and boost productivity.Record and edit macrosCreate and debug macros in VBASave macros to the Personal Macro Workbook or other workbooksCreate VBA subroutines and functionsDevelop interactive macrosFormat cells using macrosCreate variables and arraysApply logic to macros with If/Then/Else routinesUse loops to process dataAdd controls to your worksheets
Inhalt
1.Recording macros
2.Debugging macros
3.Creating macros in Visual Basic
4.Storing macros
5.Understanding macro commands
6.Using Visual Basic subroutines
7.Creating interactive macros
8.Using macros to format cells
9.Using variables in macros
10.Creating if/then/else routines
11.Creating for/next loops
12.Adding macro buttons to your worksheets
Titel
EXCEL 2007 MACROS MADE EASY
Autor
EAN
9780071599597
ISBN
978-0-07-159959-7
Format
E-Book (epub)
Hersteller
Herausgeber
Genre
Veröffentlichung
27.10.2008
Digitaler Kopierschutz
Adobe-DRM
Anzahl Seiten
240
Jahr
2008
Untertitel
Englisch
Unerwartete Verzögerung
Ups, ein Fehler ist aufgetreten. Bitte versuchen Sie es später noch einmal.