EXCEL 2007 MACROS MADE EASY
Published on 16. December 2008
Book
Paperback/Softback
208 pages
978-0-07-159958-0 (ISBN)
Description
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
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
More details
Language
English
Place of publication
New York
United States
Publishing group
McGraw-Hill Education - Europe
Target group
Professional and scholarly
Product notice
Paperback (trade)
Unsewn / adhesive bound
Illustrations
0 Illustrations
Dimensions
Height: 203 mm
Width: 203 mm
Thickness: 15 mm
Weight
337 gr
ISBN-13
978-0-07-159958-0 (9780071599580)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Person
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.
Content
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
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