Computers & Internet Books:

VBA and Macros for Microsoft Excel

Sorry, this product is not currently available to order

Here are some other products you might consider...

VBA and Macros for Microsoft Excel

Click to share your rating 0 ratings (0.0/5.0 average) Thanks for your vote!

Format:

Paperback / softback
Unavailable
Sorry, this product is not currently available to order

Description

There are an estimated 400 million Excel users. Many are Excel power users, but far fewer have figured out how to effectively use Excel VBA. This book is designed to get Excel users up and running with Excel VBA. Many Excel users are frustrated when they record their own macros with the macro recorder, only to discover that the macros won't work exactly right the next day. This book explains the shortcomings of the macro recorder, but also covers how to take the recorded code and turn it into something really useful. Once you are over that hurdle, the book explains how to understand the object- oriented Visual Basic for Applications Language. After those fundamentals, the book describes everything you could conceivably need to know to automate reports and design applications in Excel VBA. Whether you want to automate reports for your office or design full-blown applications for others, this book is for you. *Understand why the macro recorder doesn't work! *Learn how to convert recorded code into something useful *VBA syntax explained in easy-to-understand English *Automate Excel's power tools: Pivot Tables, Charts, Advanced Filters *Save hours per week by automating redundant tasks *Dramatically increase your efficiency with Excel

Author Biography:

Bill Jelen "Mr. Excel" is an accomplished Excel author and the principal behind the leading Excel website, MrExcel.com. As an Excel consultant, he has written Excel VBA solutions for hundreds of clients around the English-speaking world. His website hosts over 10 million page views annually. Prior to founding MrExcel.com, Jelen spent twelve years in the trenches, working as a financial analyst for finance, marketing, accounting and operations departments of a $500 million public company. Tracy Syrstad works as an Excel and Access Consultant. As part of the Mr.Excel.com Consulting team, she has helped develop VBA solutions for clients around the world. She remembers the painful trek up the VBA learning curve while developing applications for co-workers at a former job. She is co-editor of Holy Macro!, it's ,600 Excel VBA Examples CD" and editor of Dreamboat On Word.
Release date Australia
May 10th, 2004
Audience
  • Professional & Vocational
Country of Publication
United States
Imprint
Que Corporation,U.S.
Pages
576
Publisher
Pearson Education (US)
Dimensions
231x186x32
ISBN-13
9780789731296
Product ID
1957610

Customer reviews

Nobody has reviewed this product yet. You could be the first!

Write a Review

Marketplace listings

There are no Marketplace listings available for this product currently.
Already own it? Create a free listing and pay just 9% commission when it sells!

Sell Yours Here

Help & options

Filed under...