|
![]() |
|||
|
||||
OverviewPublisher'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 Full Product DetailsAuthor: Gail PerryPublisher: McGraw-Hill Education - Europe Imprint: Osborne/McGraw-Hill Dimensions: Width: 20.10cm , Height: 1.00cm , Length: 20.10cm Weight: 0.441kg ISBN: 9780071599580ISBN 10: 0071599584 Pages: 208 Publication Date: 16 December 2008 Audience: Professional and scholarly , Professional & Vocational Format: Paperback Publisher's Status: Active Availability: Manufactured on demand ![]() We will order this item for you from a manufactured on demand supplier. Table of ContentsIntroduction 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 IndexReviewsAuthor InformationGail 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. Tab Content 6Author Website:Countries AvailableAll regions |