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
EAN
9780071599597
ISBN
978-0-07-159959-7
Format
E-Book (epub)
Veröffentlichung
27.10.2008
Digitaler Kopierschutz
Adobe-DRM
Anzahl Seiten
240
Jahr
2008
Untertitel
Englisch