EXCEL 2007 MACROS MADE EASY - Gail Perry

EXCEL 2007 MACROS MADE EASY

(Autor)

Buch | Softcover
208 Seiten
2008
Osborne/McGraw-Hill (Verlag)
978-0-07-159958-0 (ISBN)
36,15 inkl. MwSt
Here is the perfect solution for the spreadsheet user who wants to learn powerful shortcuts and time-saving methods for expediting and remembering tasks.
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality,  authenticity, or access to any online entitlements included with the product.




Get beyond the basics with Excel 2007 macros

Now 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 macros

Create and debug macros in VBA

Save macros to the Personal Macro Workbook or other workbooks

Create VBA subroutines and functions

Develop interactive macros

Format cells using macros

Create variables and arrays

Apply logic to macros with If/Then/Else routines

Use loops to process data

Add controls to your worksheets


 

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.

Introduction
Chapter 1. Recording Macros
Chapter 2. Editing Macros
Chapter 3. Creating Macros in Visual Basic
Chapter 4. Storing Macros
Chapter 5. Understanding Macro Commands
Chapter 6. Using Visual Basic Subroutines and Creating Functions
Chapter 7. Creating Interactive Macros
Chapter 8. Using Macros to Format Cells
Chapter 9. Using Variables in Macros
Chapter 10. Creating If/Then/Else Routines
Chapter 11. Exploring Loops
Chapter 12. Adding Controls to Your Worksheets
Index

Erscheint lt. Verlag 16.12.2008
Zusatzinfo 0 Illustrations, unspecified
Verlagsort New York
Sprache englisch
Maße 201 x 201 mm
Gewicht 441 g
Themenwelt Informatik Office Programme Excel
ISBN-10 0-07-159958-4 / 0071599584
ISBN-13 978-0-07-159958-0 / 9780071599580
Zustand Neuware
Haben Sie eine Frage zum Produkt?
Mehr entdecken
aus dem Bereich