on all orders of $59 or more

6% OFF your purchase of $100 or more!
Use coupon code THURSDAY in checkout.

101 Ready-to-Use Excel Macros

, by ;
101 Ready-to-Use Excel Macros by Alexander, Michael; Walkenbach, John, 9781118281215
Note: Supplemental materials are not guaranteed with Rental or Used book purchases.
  • ISBN: 9781118281215 | 1118281217
  • Cover: Paperback
  • Copyright: 6/13/2012
  • Sorry, this item is currently not available.
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
Mike Alexander is a Microsoft Certified Application Developer (MCAD) and author of several books on advanced business analysis with Microsoft Access and Excel. He has more than 15 years of experience consulting and developing Office solutions. Michael has been named a Microsoft MVP for his ongoing contributions to the Excel community. In his spare time, he runs a free tutorial site,, where he shares Excel and Access tips.

John Walkenbach is author of more than 50 spreadsheet books and lives in southern Arizona.
Visit his website at

You might also enjoy...

Please wait while the item is added to your bag...