Excel 2013 VBA and Macros (MrExcel Library)

Using Microsoft Excel 2013 VBA scripting features, you 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. Excel 2013 VBA and Macros is the solution. One simple step at a time, two leading Excel VBA scripting experts teach all the techniques you need 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 efficient, modern object programming. You'll learn how to automate Excel 2013's most powerful new features for data analysis, formatting, visualization, sharing, and presentation. Jelen and Syrstad cover all this, and more:

* 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 2013 Ribbon to run macros

* Writing Excel 2013 code that works with older versions of Excel

This book is part of the popular MrExcel's Library series, edited by Bill Jelen, world-renowned Excel expert and host of leading Excel help site, MrExcel.com.