|
Brilliant Excel 2007 Solutions: VBA & Macros
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
CONTENTS:
Introduction
1. Unleash the Power of Excel with VBA
2. This Sounds like BASIC, So why doesn't it look familiar?
3. Referring to Ranges
4. User-Defined Functions
5. Looping and Flow Control
6. R1C1-Style Formulas
7. What's new in Excel 2007 and what's changed
8. Create and Manipulate Names in VBA
9. Event Programming
10. Userforms - An Introduction
11. Creating Charts
12. Data Mining with Advanced Filter
13. Using VBA to create pivot tables
14. Excel Power
15. Data Visualizations and conditional formatting
16. Reading from and writing to the web
17. XML in excel 2007
18. Automating Word
19. Arrays
20. Text File Processing
21. Using Access as a back end to enhance Multi-User Access to Data
22. Creating classes, records, and collections
23. Advanced Userform Techniques
24. Windows Application Programming Interface (API)
25. Handling errors
26. Customizing the ribbon to run macros
27. Creating Add-Ins
INDEX
|
