Brilliant Microsoft Excel 2007 VBA & MacrosUpplaga 1

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 doesnt 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 doesnt work! Convert recorded code into something useful Understand VBA syntax from easy-to-understand English explanations Automate Excels 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 E...