• Sign In / Register
  • Help
  • Basket0
The books you love, the emails you want
Time is running out, opt in before 25 May or you'll stop hearing from us
Yes Please
VBA and Macros: Microsoft Excel 2010 (Paperback)
  • VBA and Macros: Microsoft Excel 2010 (Paperback)

VBA and Macros: Microsoft Excel 2010 (Paperback)

(author), (author)
1 Review Sign in to write a review
Paperback 656 Pages / Published: 01/07/2010
  • Not available

This product is currently unavailable.

  • This item has been added to your basket

Check Marketplace availability





Microsoft Excel 2010



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. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will

* 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

Publisher: Pearson Education (US)
ISBN: 9780789743145
Number of pages: 656
Weight: 1021 g
Dimensions: 232 x 180 x 33 mm

You may also be interested in...

Excel 2013 All-In-One for Dummies
Added to basket
M Is for (Data) Monkey
Added to basket
Excel 2010 in easy steps
Added to basket
Excel Dashboards and Reports
Added to basket
Microsoft Excel Made Easy
Added to basket
Power Pivot and Power Bi
Added to basket
Statistics for the Utterly Confused
Added to basket
Excel 2013 Power Programming with VBA
Added to basket
Excel 2010 Power Programming with VBA
Added to basket
Excel 2013 Bible
Added to basket
Microsoft Excel 2013 Plain & Simple
Added to basket
Microsoft Excel 2007 In Simple Steps
Added to basket
Added to basket


View all

“VBA and Macros”

After visiting the MrExcel website with questions about VBA I knew that any publications would be exactly what I needed as a fledgling VBA'er.
Easy to follow, very descriptive and on my level of understanding,... More

Paperback edition
18th July 2012
Helpful? Upvote 4

Please sign in to write a review

Your review has been submitted successfully.