Most books offer a very high-level overview of VBA, often providing readers with benign examples designed only to illustrate a particular topic. Analysts don't have the luxury of taking a few weeks time-out to learn VBA. The scenarios and issues they are facing require immediate help in the form of Excel Macros. In this case, many analysts turn to Google and online Excel forums here they can find that one Excel Macro (snippet of VBA code) that will solve their problem now. In the real world, most Excel analysts implement VBA code long before they actually learn or understand VBA. This book approaches the reader with the assumption that VBA "learning" will come later. Instead of the same general overview of VBA topics, this book provides 101 of the most commonly used real-world Excel Macros. Each segment of the book outlines a common problem that needs to be solved, and will provide the actual Excel Macro to solve the problem along with detailed explanation of how the macro works and where to use the macro. The book is in the format of a Recipe/Tips and Tricks book where each segment shows how to perform a common task via Excel Macros. This lets the reader use the book as a handy reference where a common problem can be found in the book, and solved by plugging in the given macro. After using this book and the CD, the reader will be able to: Immediately implement the required Excel Macro Understand how the given macro works Reuse the given macro in other workbooks or in conjunction with other macros Modify the macro for personal use Content Overview Working with Workbooks Working with Worksheets Working with Ranges Working with Data Working With PivotTables Working With Charts

Author Biography

Read more