EXCEL 2007 MACROS MADE EASY (Made Easy Series) [Paperback]

Gail Perry (Author)

Book Description

ISBN-10: 0071599584 | ISBN-13: 978-0071599580 | Publication Date: October 27, 2008 | Edition: 1

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

 

Editorial Reviews

About the Author

Gail Perry is a CPA, financial journalist, the author more than 20 books on financial software, taxes, and personal finance. She is the managing editor for AccountingWEB, a contributing editor for SMBFinance magazine, and an instructor.

Product Details

• Paperback: 208 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (October 27, 2008)
• Language: English
• ISBN-10: 0071599584
• ISBN-13: 978-0071599580
• Product Dimensions: 8 x 7.9 x 0.4 inches
• Shipping Weight: 12 ounces (View shipping rates and policies)
• Average Customer Review: 4.4 out of 5 stars  See all reviews (5 customer reviews)
• Amazon Best Sellers Rank: #238,516 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

7 of 7 people found the following review helpful:

3.0 out of 5 stars Excel 2007 Macros, April 20, 2009

By 

Robert K. Ferguson "Fergie" (US, Virginia) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: EXCEL 2007 MACROS MADE EASY (Made Easy Series) (Paperback)

This book presents the fundamentals of recording and modifying Excel macros. It would be more useful if it contained a few actual, complex macros as examples for users who wanted to do more than put their names into a cell.

6 of 6 people found the following review helpful:

5.0 out of 5 stars Very Basic, But Very Good At Getting Started, September 15, 2009

By 

Brian J. Morse "Physics Want-A-Be" (San Diego, CA USA) - See all my reviews
(REAL NAME)   

This review is from: EXCEL 2007 MACROS MADE EASY (Made Easy Series) (Paperback)

I agree w/ the previous reviewer that more complex examples would be nice, but I bought this book with some old programming experience (COBOL) and just needed to get pointed in the right direction w/ Macros and possibly modifying the Visual Basic code they create. If that is what you're looking for this book is perfect.

Yes, it does lead you through very detailed examples - sometimes you appreciate the handholding, and other times you can skim through it. A couple areas come to mind: 1)such as the need to install the Developer Ribbon and most importantly 2)the complex way Excel 2007 can store your macros in various locations. (FYI, it took me a while to figure out that the PERSONAL workbook that is automatically opened is Hidden and you have to Unhide it to modify or delete macros stored there).

I've loaned it to two colleagues, both of which ran out and purchased their own copy.

2 of 2 people found the following review helpful:

4.0 out of 5 stars Great for even the beginner, December 5, 2010

By 

Elizabeth Hardy Thompson "Elizabeth Hardy Tho... (In his heart, NC) - See all my reviews

Amazon Verified Purchase

This review is from: EXCEL 2007 MACROS MADE EASY (Made Easy Series) (Paperback)

This book is great to keep at your desk for writing codes, from simple codes to complex. I think even someone who isn't so experienced could understand the terminology found in this book. From what I can see in Office 2010, the code is that same.