From the Back Cover
Brilliant Excel 2007 VBA & Macros
What you need to know and how to do it
Excel is one of the most powerful office and business productivity tools available – but do you know how to harness its full potential? Do you want to get a better understanding of its full capabilities and potential, and develop the Excel skills that you need to produce solutions to all of your business needs? Brilliant Excel VBA & Macros will deliver increased office productivity and improved results by unleashing your inner Excel expert ! This book is for the savvy Excel user who wants to understand and then use the advanced features of Excel but doesn’t want to dedicate their life to it
Develop your Excel expertise instantly with proven techniques
If you are a regular user of Excel, this book will dramatically increase your productivity and efficiency in producing the reports that you need in a timely manner. If you need to use Excel on a daily basis, importing raw data and performing time-consuming manipulations using Excel's power tools, then this book will teach you how to automate these processes, dramatically saving hours of time.
There are many experienced Excel users, but very few have figured out how to effectively use Excel VBA. Many users are frustrated when they record their own macros with the macro recorder, only to discover that the macros won't work correctly the next day. This book is designed to get you up and running with Excel VBA, and 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 teaching you those fundamentals, the book then goes on to describe everything you could conceivably need to know to automate reports and design applications in Excel VBA.
Even if you've never programmed before, this book will take you up the learning curve and enable you to automate common tasks in Microsoft Excel. Whether you want to automate reports for your office or design full-blown applications for others, this book will solve all of your problems and save you a huge amount of time and frustration.
Brilliant Excel 2007 VBA & Macros will show you how to ….
- Understand why the macro recorder doesn’t work!
- Convert recorded code into something useful
- Understand VBA syntax from easy-to-understand English explanations
- Automate Excel’s power tools- Pivot Tables, Charts, Advanced Filters
- Save hours per week by automating redundant tasks
- Dramatically increase your efficiency with Excel
About the Authors
Bill Jelen is MrExcel, as well as an Excel MVP. He 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.
Tracy Syrstad works as an Excel and Access Consultant. As part of the MrExcel.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.
Visit us on the web at
About the Author
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!, its 600 Excel VBA Examples CD and editor of Dreamboat On Word.