Kindle Price: $22.77
Price includes tax, if applicable

promotions apply when you purchase

These promotions will be applied to this item:

Some promotions may be combined; others are not eligible to be combined with other offers. For details, please see the Terms & Conditions associated with these promotions.

Read with our free app
You've subscribed to ! We will pre-order your items within 24 hours of when they become available. When new books are released, we'll charge your default payment method for the lowest price available during the pre-order period.
Update your device or payment method, cancel individual pre-orders or your subscription at
Your memberships & subscriptions
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet or computer—no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera, scan the code below and download the Kindle app.

QR code to download the Kindle App

Follow the authors

Tracy Syrstad
Follow
Bill Jelen
Follow
Something went wrong. Please try your request again later.

VBA and Macros: Microsoft Excel 2010 (MrExcel Library) 1st Edition, Kindle Edition

by Bill Jelen (Author), Tracy Syrstad (Author) Format: Kindle Edition
4.5 out of 5 stars 101
See all formats and editions

Use Excel 2010 VBA and macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then learn how to make Excel do things you thought were simply impossible! This book reveals scripting techniques you won’t find anywhere else and shows you how to create automated reports that are amazingly powerful and useful. It helps you instantly visualize information so you can understand and act on it. It also shows you how to capture data from anywhere and use it anywhere, and helps you automate Excel 2010’s most powerful new features. Learning advanced Excel scripting has never been easier. You’ll find simple, step-by-step instructions, real-world examples and case studies, and 50 workbooks packed with bonus examples, macros, and solutions, straight from MrExcel.

  • Work efficiently with ranges, cells, and R1C1-style formulas
  • Build super-fast applications with arrays
  • Customize the Excel 2010 Ribbon to run your macros
  • Write Excel 2010 VBA code that works on older versions of Excel
  • Create custom dialog boxes to collect information from your users
  • Use error handling to make your VBA scripts more resilient
  • Use Web queries to import data from virtually any online source
  • Master advanced techniques such as classes and collections
  • Use Excel VBA to control other Office programs…even control Windows itself, via the Windows API
  • Create add-ins to share or sell your programs

About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively.

  • Dramatically increase your productivity—saving you 50 hours a year or more
  • Present proven, creative strategies for solving real-world problems
  • Show you how to get great results, no matter how much data you have
  • Help you avoid critical mistakes that even experienced users make
Previous page
  1. ISBN-13
    978-0789743145
  2. Edition
    1st
  3. Sticky notes
    On Kindle Scribe
  4. Publisher
    Que Publishing
  5. Publication date
    21 June 2010
  6. Part of series
    MrExcel Library
  7. Language
    English
  8. File size
    51936 KB
  9. See all details
Next page
Due to its large file size, this book may take longer to download
Kindle E-Readers
Kindle Fire Tablets
Free Kindle Reading Apps
See all supported devices

There is a newer version of this item:

Excel 2013 VBA and Macros (MrExcel Library)
Excel 2013 VBA and Macros (MrExcel Library)
$22.77
(135)
Available for download now
Pay with Zip
Buy now and pay at your pace using Zip Learn more
Next 5 for you in this series See full series
Total price: $122.80 + applicable tax
By clicking on the buy button, your order will be finalised and you agree to the Kindle store terms of use.
Sold by: Amazon Australia Services, Inc.
Books In This Series (13 Books)
Page: 1 of 1Start OverPage: 1 of 1
Previous page
  1.  PowerPivot for the Data Analyst: Microsoft Excel 2010 (MrExcel Library)
    Bill Jelen
    3.9 out of 5 stars (42)
    Kindle Edition
    $30.42
  2. Business Analysis: Microsoft Excel 2010 (MrExcel Library)
    Conrad Carlberg
    3.7 out of 5 stars (22)
    Kindle Edition
    $22.77
  3. VBA and Macros: Microsoft Excel 2010 (MrExcel Library)
    Bill Jelen
    4.5 out of 5 stars (101)
    Kindle Edition
    $22.77
  4. Charts and Graphs: Microsoft Excel 2010 (MrExcel Library)
    Bill Jelen
    3.9 out of 5 stars (24)
    Kindle Edition
    $33.92
  5. Pivot Table Data Crunching: Microsoft Excel 2010 (MrExcel Library)
    Bill Jelen
    3.9 out of 5 stars (37)
    Kindle Edition
    $18.30
  6. Excel 2013 Pivot Table Data Crunching (MrExcel Library)
    Bill Jelen
    4.3 out of 5 stars (88)
    Kindle Edition
    $25.04
  7. Excel 2013 VBA and Macros (MrExcel Library)
    Bill Jelen
    4.3 out of 5 stars (135)
    Kindle Edition
    $22.77
  8. Excel 2013 Formulas and Functions (MrExcel Library)
    Paul McFedries
    4.2 out of 5 stars (26)
    Kindle Edition
    $22.77
  9. Excel 2013 Charts and Graphs (MrExcel Library)
    Bill Jelen
    4.3 out of 5 stars (32)
    Kindle Edition
    $33.92
  10. Microsoft Excel 2016 Formulas and Functions (MrExcel Library)
    Paul McFedries
    4.4 out of 5 stars (109)
    Kindle Edition
    $22.77
Next page

Product description

Review

Using Microsoft Excel 2010 VBA scripting features, Excel users can save dozens - or even hundreds - of hours per year. But most Excel users have never written a VBA script: many haven't even used Excel's built-in Macro Recorder. VBA and Macros is the solution. One simple step at a time, two leading Excel VBA scripting experts teach all the techniques needed to automate virtually any Excel task and customize virtually any Excel report or business solution. Bill Jelen ("MrExcel") and top Excel VBA consultant Tracy Syrstad begin with the absolute basics, including ranges, user-defined functions, looping, flow control, R1C1-style formulas, and event programming. Next, they cover all this, and much more: " Automating Excel 2010's brand-new features " Writing Excel 2010 code that works with older versions of Excel " Creating charts, PivotTables, and other data visualizations " Mining data with Excel's Advanced Filter " Reading from and writing to the Web " Using XML from within Excel " Using Microsoft Access as a back end to enhance multi-user access to data " Handling errors " Customizing the Excel 2010 Ribbon to run macros This book is part of the new MrExcel Library series, edited by Bill Jelen, world-renowned Excel expert and host of the enormously popular Excel help site, MrExcel.com.

  • The fastest, best way to go beyond the Macro Recorder and move up the Excel VBA learning curve
  • Shows how to automate powerful new Excel 2010 features such as Sparklines
  • Includes crucial information on making Excel 2010 VBA code work with older versions
  • Co-authored by Excel legend and Microsoft MVP Bill Jelen ("MrExcel") as part of his new MrExcel's Library series

From the Back Cover

Using Microsoft Excel 2010 VBA scripting features, Excel users can save dozens - or even hundreds - of hours per year. But most Excel users have never written a VBA script: many haven't even used Excel's built-in Macro Recorder. VBA and Macros is the solution. One simple step at a time, two leading Excel VBA scripting experts teach all the techniques needed to automate virtually any Excel task and customize virtually any Excel report or business solution. Bill Jelen ("MrExcel") and top Excel VBA consultant Tracy Syrstad begin with the absolute basics, including ranges, user-defined functions, looping, flow control, R1C1-style formulas, and event programming. Next, they cover all this, and much more: " Automating Excel 2010's brand-new features " Writing Excel 2010 code that works with older versions of Excel " Creating charts, PivotTables, and other data visualizations " Mining data with Excel's Advanced Filter " Reading from and writing to the Web " Using XML from within Excel " Using Microsoft Access as a back end to enhance multi-user access to data " Handling errors " Customizing the Excel 2010 Ribbon to run macros This book is part of the new MrExcel Library series, edited by Bill Jelen, world-renowned Excel expert and host of the enormously popular Excel help site, MrExcel.com.

  • The fastest, best way to go beyond the Macro Recorder and move up the Excel VBA learning curve
  • Shows how to automate powerful new Excel 2010 features such as Sparklines
  • Includes crucial information on making Excel 2010 VBA code work with older versions
  • Co-authored by Excel legend and Microsoft MVP Bill Jelen ("MrExcel") as part of his new MrExcel's Library series

Product details

  • ASIN ‏ : ‎ B003VPWVWG
  • Publisher ‏ : ‎ Que Publishing; 1st edition (21 June 2010)
  • Language ‏ : ‎ English
  • File size ‏ : ‎ 51936 KB
  • Simultaneous device usage ‏ : ‎ Up to 5 simultaneous devices, per publisher limits
  • Text-to-Speech ‏ : ‎ Enabled
  • Screen Reader ‏ : ‎ Supported
  • Enhanced typesetting ‏ : ‎ Enabled
  • X-Ray ‏ : ‎ Not Enabled
  • Word Wise ‏ : ‎ Not Enabled
  • Sticky notes ‏ : ‎ On Kindle Scribe
  • Print length ‏ : ‎ 1061 pages
  • Customer Reviews:
    4.5 out of 5 stars 101

About the authors

Follow authors to get new release updates, plus improved recommendations.
Previous page
  1. Tracy Syrstad

    Tracy Syrstad

    Brief content visible, double tap to read full content.
    Full content visible, double tap to read brief content.

    Tracy Syrstad is a Microsoft Excel developer and author of ten Excel books. She’s been helping people with Microsoft Office issues since 1997 when she discovered free online forums where anyone could ask and answer questions. She discovered she enjoyed teaching others new skills, and when Tracy began working as a developer, she was able to integrate the fun of teaching with one-on-one online desktop sharing sessions.

    See more on the author's page
  2. Bill Jelen

    Bill Jelen

    Brief content visible, double tap to read full content.
    Full content visible, double tap to read brief content.

    Bill Jelen is the host of MrExcel.com and the author of 60 books about Microsoft Excel including Excel Gurus Gone Wild, Pivot Table Data Crunching, and Excel 2019 Inside Out. He has made over 80 guest appearances on TV’s Call for Help with Leo Laporte and was voted guest of the year on the Computer America radio show. He writes the Excel column for Strategic Finance magazine.

    He has produced over 2200 episodes of his daily video podcast Learn Excel from MrExcel. Before founding MrExcel.com in 1998, Jelen spent twelve years “in the trenches”, as a financial analyst for the accounting, finance, marketing, and operations departments of a publicly held company. Since then, his company automates Excel reports for hundreds of clients around the world. The website answers over 30,000 questions a year – for free – for readers all over the world.

    In his free time, Jelen is a rocket launch photographer for We Report Space.

    See more on the author's page
Next page

Customer reviews

4.5 out of 5 stars
4.5 out of 5
101 global ratings

Review this product

Share your thoughts with other customers
Write a customer review

Top reviews from Australia

There are 0 reviews and 0 ratings from Australia

Top reviews from other countries

Amazon Customer
4.0 out of 5 stars Ok ok
Reviewed in India on 24 January 2019
Verified Purchase
Not all functions covered
Report
Daniela und Kai Stasch
5.0 out of 5 stars Easy way to learn VBA
Reviewed in Germany on 18 January 2015
Verified Purchase
This book is the best way to get a start in VBA and macros. Bill Jelen gives a lot of hints and examples which can be directly adopted into my daily work.
Report
Hans P. Heinrich
5.0 out of 5 stars The best at this.
Reviewed in Canada on 3 June 2013
Verified Purchase
This book is an absolute essential if you want to go above the ordinary with your excel knowledge. In today's marketplace, where your'e competing for a job based on what you know and can provide, this gives you an edge. Learn at your own pace. Learn practical stuff as well, not just theoretical geeky stuff. Fantastic book. I love the e-book version.
Report
Cain
5.0 out of 5 stars Excel for School District
Reviewed in the United States on 17 February 2012
Verified Purchase
This book is excellent if you want to know how to do VBA and macro's and other stuff. There are files included which you can test the macro's and look at how they did it. Also, you'll need to be able to research online to supplement what this book offers.

I work for a school district and everyone claims to be an expert in Excel and Access. I have coworkers I personally know who applied for promotions and got it, based on lying on their apps about skills in Excel and nobody checking. Though I know they are NOT experts. I was honest and put down moderate experience. However, after a few months with this book I've able to make virtually any VBA or macro, or at least be able to research it online and copy it from there. I can automate reports and such and everyone considers me a expert in Excel now. Unfortunately, with the downturn in the economy, nobody is hiring and our school district continues to layoff but at least I know excel!

The problem with Excel though is that you can only do these VBA/macro in Excel. The good news is most people prefer reports and spreadsheets to be in Excel versus Access or any other, simply because you can manipulate data in Excel. Access is better if you want reports that are standardized, don't change much and nobody needs to play with the data afterwards.

Bad side with Excel is it is time consuming to learn and there is a lot of room for error, especially if you are automating dozens of reports and I've had to automate about 50 of them just the last 2 months. They are going to throw more at me too because I'm the fastest, most accurate, Excel user in the office. I credit my motivation and this book + online research for that.

An example of some automated reports I do at the school district which this book has helped me:

1) Attendance Reporting - Some spreadsheets/reports show the rate which teachers submit daily "period" attendance and those who are late. Also, breaks down students who attend school over 97%, 87%, etc. While these are more formulas that reference datasheet's back into the report, I still need to do VBA's that convert schools into different names, format, splitting excel sheets into multiple files, etc. These are all automated. You can do it by hand but it will be time consuming and more chance for error. The book shows some tips but the rest you'll have to look up online or do yourself. Nevertheless, the book is a excellent starting point.

Remember, this book is a guide and you still need to do some research online to complete it but I highly recommend.
6 people found this helpful
 Report
JLV
5.0 out of 5 stars Practical and complete, I think it's the best available for now
Reviewed in the United Kingdom on 25 January 2013
Verified Purchase
VBA is no picnic, and I don't think that you will ever find an "easy 10 steps tutorial". If you want to learn VBA, you must be ready to invest much time.
Often many books waste our previous time on explaining everything, 100 pages on the User Interface and all the options, then some silly examples ("Hello World") ad nauseum.
Not this one: it combines some practical examples with simple code, or some very complex code for you to use without trying to understand it. The first 3 chapters are already a gold mine, by explaining how to correct the macro recorder, how to make sure to get the full range of data, and how to select any kind of range. Those are fantastic tips, which you find nowhere else.
After that you dive in the overwhelming range of VBA features, and you can keep this book as wonderful reference.
As always the Kindle version is not the best, especially with the images made of the source code.
This book has a few defects, I have the feeling that it mixes some very complex subjects (f.i. the Events) with more simple ones (R1C1 formulas), and some paragraphs are very obscure. Just pass them and move to the next, there is enough to learn in the easy parts to keep you busy.
I have read 2 more books about VBA: one is a very simple introduction, and the other is also a very big book, which made me sleep. This one is good.
9 people found this helpful
 Report
Report an issue

Does this item contain inappropriate content?
Report
Do you believe that this item violates a copyright?
Report
Does this item contain quality or formatting issues?
Report