Brilliant Microsoft Excel 2007 VBA & Macros - Brossura

Bill, Jelen

Brossura

ISBN 10: 0273714058 ISBN 13: 9780273714057

Casa editrice: Financial Times Prentice Hall, 2007

Riassunto

There are an estimated 400 million Excel users, very few of whom know how to use Excel VBA effectively. This book is designed to get Excel users up and running with Excel VBA. Users will quickly learn how to automate reports and design applications. Brilliant Excel VBA & Macros explains the shortcomings of the macro recorder, but also covers how to take the recorded code and turn it into something really useful. Once the user has mastered the macro recorder, the book explains how to understand the object- oriented Visual Basic for Applications Language. Throughout the book there are no-nonsense, step-by-step tutorials and lots of practical examples aimed directly at business users.

Su questo libro

L'autore

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.

Dalla quarta di copertina

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

www.pearson-books.com

 

 

Dettagli dell?edizione

• Editore: Financial Times Prentice Hall
• Data di pubblicazione: 2007
• ISBN 10: 0273714058
• ISBN 13: 9780273714057
• Rilegatura: Copertina flessibile
• Lingua: Inglese
• Numero edizione: 1
• Numero di pagine: 624