VBA and Macros: Microsoft Excel 2010 (MrExcel Library) and over one million other books are available for Amazon Kindle. Learn more
  • List Price: $39.99
  • Save: $20.99 (52%)
Rented from RentU
To Rent, select Shipping State from options above
Due Date: Dec 19, 2014
FREE return shipping at the end of the semester. Access codes and supplements are not guaranteed with rentals.
FREE Shipping on orders over $35.
Used: Good | Details
Sold by RentU
Condition: Used: Good
Comment: Fast shipping from Amazon! Qualifies for Prime Shipping and FREE standard shipping for orders over $35. Overnight, 2 day and International shipping available! Excellent Customer Service.. May not include supplements such as CD, access code or DVD.
Access codes and supplements are not guaranteed with used items.
Add to Cart
Qty:1
  • List Price: $39.99
  • Save: $14.31 (36%)
FREE Shipping on orders over $35.
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
Trade in your item
Get a $10.16
Gift Card.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

VBA and Macros: Microsoft Excel 2010 (MrExcel Library) Paperback – July 1, 2010

ISBN-13: 978-0789743145 ISBN-10: 0789743140 Edition: 1st

Buy New
Price: $25.68
Rent
Price: $19.00
49 New from $22.11 36 Used from $20.09
Rent from Amazon Price New from Used from
eTextbook
"Please retry"
Paperback
"Please retry"
$19.00
$25.68
$22.11 $20.09

There is a newer edition of this item:


Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student



Frequently Bought Together

VBA and Macros: Microsoft Excel 2010 (MrExcel Library) + Excel 2010 Power Programming with VBA + 101 Ready-To-Use Excel Macros
Price for all three: $75.91

Buy the selected items together

NO_CONTENT_IN_FEATURE

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Series: MrExcel Library
  • Paperback: 656 pages
  • Publisher: Que Publishing; 1 edition (July 1, 2010)
  • Language: English
  • ISBN-10: 0789743140
  • ISBN-13: 978-0789743145
  • Product Dimensions: 9.1 x 7 x 1.3 inches
  • Shipping Weight: 2.2 pounds (View shipping rates and policies)
  • Average Customer Review: 4.4 out of 5 stars  See all reviews (23 customer reviews)
  • Amazon Best Sellers Rank: #57,943 in Books (See Top 100 in Books)

Editorial Reviews

About the Author

Bill Jelen, Excel MVP and the host of MrExcel.com, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. Bill was a regular guest on Call for Help with Leo Laporte and has produced more than 1,200 episodes of his daily video podcast, Learn Excel from MrExcel. He is the author of 30 books about Microsoft Excel and writes the monthly Excel column for Strategic Financemagazine. You will most frequently find Bill taking his show on the road, doing half-day Power Excel seminars wherever he can find a room full of accountants or Excellers. Before founding MrExcel.com, Jelen spent 12 years in the trenches—working as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company. He lives near Akron, Ohio, with his wife, Mary Ellen, and his sons, Josh and Zeke.

 

Tracy Syrstadis the project manager for the MrExcel consulting team. She was introduced to Excel VBA by a co-worker who encouraged her to learn VBA by recording steps and then modifying the code as needed. Her first macro was a simple lookup and highlight for a parts index, although it hardly seemed simple then. But she was encouraged by this success and others to follow. She’ll never forget the day when it all clicked. She hopes this book will bring that click to its readers sooner and with less frustration. She lives near Sioux Falls, South Dakota, with her husband, John.

 


More About the Authors

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

Customer Reviews

4.4 out of 5 stars
5 star
15
4 star
3
3 star
4
2 star
1
1 star
0
See all 23 customer reviews
This book is very easy to follow.
Brandon
The examples provide a basis to understand how VBA works in Excel 2010 so a non-programmer can quickly create macro to simply repetitive tasks.
PJD CPA
Good book for anyone looking to learn VBA.
Rene Resendez

Most Helpful Customer Reviews

71 of 72 people found the following review helpful By Glenn on November 22, 2010
Format: Paperback Verified Purchase
While I am getting some good information out of this book, I have to say it is not for the beginner. Unless you are naturally intuitive, logical, persistant, and have a good understanding of Excel and programming, you will find this book frustrating. The problem is that a lot is left "un-said". Luckily, I have some of the previously mentioned qualities and I was a whiz at the old Lotus macros (soooo much easier) so this isn't completely new to me.

I have since bought the John Walkenbach book, "Excel 2010 Power Programming with VBA" and hightly recommend that for someone just starting out or not very intuitive. Walkenbach fills in a lot more of the gaps and really explains the whole VBA experience from the beginning in good, concise detail. After I get through more of the Walkenbach book, I'll return to this book because it does have a lot of useful information, I'm just not prepared for it yet.
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
40 of 40 people found the following review helpful By Heather Gray on December 15, 2010
Format: Paperback Verified Purchase
I am an advanced excel user who is semi-new to VBA. Not new to macros at all. And I've done some VBA editing from recorded macros. What this book does not say is, it really is aimed at people who already know VBA. I think it tells you how to put it into better practice for specific results.

It has not been very helpful to me at this point. I've had to go out to the internet to get the code I need to build the excel data model I need for my job.

The book might be helpful to those who already know VBA. But for a beginner, even having used a little VBA, it is confusing.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
11 of 11 people found the following review helpful By Nabu on November 14, 2012
Format: Paperback
I'm quite new to VBA world. I have just begun to study only 5-6 months ago for some projs in my firm. Luckily I'm engineering-mind so I have obtained some good results with this book. The probl is this book doesnt explain you everything and the code in some points is quite hard. The good news is the examples are REALLY useful in a work-environment. My advice is beginning with a entry-level book (i began with Excel VBA Programming for Dummies, john Walkenbach) and THEN to begin reading this book.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
6 of 6 people found the following review helpful By Pitabas Mohanty on August 24, 2012
Format: Paperback Verified Purchase
This book is undoubtedly the best book available on this subject. I have read a number of books on VBA and this books is simply miles ahead of the other books.

I teach a course in India on Financial Modeling Using Excel to the MBA students in India and I use macros a lot in my models. I was looking for a good book on this subject which I can refer to for this course (as a reference book). What I like the most about this book are the following:

Simplicity in writing style: Everything is very clearly and lucidly explained. It is also written as a self-help guide. You can open your laptop, read each page and experiment with VBA. The author really knows how to communicate with the audience and he does that beautifully in each page in this book.

Arrangement of Topics: The topics in this book are arranged in the best possible way. Most beginners struggle with the macro security issue and the book deals with these annoying issues in the very first chapter itself.

Lots of Short, simple, and extremely powerful examples: This book is full of them. No matter whether you are a beginner, an intermediate user or an advanced user of VBA, you will find something for you in this book.

I will strongly recommend this book to anyone who does serious macro programming.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
5 of 5 people found the following review helpful By Brandon on October 31, 2012
Format: Paperback Verified Purchase
This book is very easy to follow. The authors do a good job at breaking each part down. I have minimal computer programming skills and within a week I was able to write a few simple macros. After completing about half the book over the last few weeks I'd say I'm the "VBA guy" in my office of about 10 people.

This book is a great way to set yourself apart in your office. It's mostly for excel, but the VBA platform also works in Word so you'll be able to make simple macros in Word in no time.

Also, the book is mostly enjoyable. I won't say it's novel material, but it's one of the best computer books I've read - not a lot of technical jargon. Again, I HIGHLY RECOMMEND!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
4 of 4 people found the following review helpful By yael on February 28, 2011
Format: Paperback Verified Purchase
This book is really well written and usefull. I have no experience in macro or code writing but I could write my first usable macro in one day after reading the first 50 pages of the book. It had been recommended to me by a friend, and went even beyond my expectations.
I cannot tell for sure, but I have the feeling that it can be also very usefull for senior programmers.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 3 people found the following review helpful By alex20850 on July 9, 2012
Format: Paperback
While I committed to work through this book, I can't give it five stars.
I feel like this book tries to get too practical, too fast.

If teaching is leading someone along a path to a destination, I feel like it has too many distractions. I have over 20 years experience with spreadsheets and 10+ years in teaching and writing training manuals. As a comparison of a good Excel manual, but for functions rather than VBA I would recommend Bern Held's Microsoft Excel Functions & Formulas. It takes you step-by-step from one concept to the next with an exercise.

For example, the first case study has 21 steps showing you how to use a macro to create report. The purpose of the case study is to show why you need to:
1) Use relative references
2) Use special navigation keys
3) Never use AutoSum.

I am creating a supplementary training document for myself which will simplify the exercises.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Customer Images

Most Recent Customer Reviews

Search

What Other Items Do Customers Buy After Viewing This Item?