9780789748614

Excel 2013 Vba and Macros

  • ISBN 13:

    9780789748614

  • ISBN 10:

    0789748614

  • Edition: 1st
  • Format: Paperback
  • Copyright: 02/04/2013
  • Publisher: Que Pub

Note: Not guaranteed to come with supplemental materials (access cards, study guides, lab manuals, CDs, etc.)

Extend Your Rental at Any Time

Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.

Rental Options

List Price $39.99 Save

Free Shipping Free Shipping On Every Order
Currently Available, Usually Ships in 24-48 Hours

Summary

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 Macrosis 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.

Author Biography

Read more

Table of Contents

Read more

Write a Review