Sorry, this item is currently unavailable.

101 Ready-to-Use Excel Macros

ISBN: 9781118281215 | 1118281217
Format: Paperback
Publisher: Wiley
Pub. Date: 6/13/2012

Why Rent from Knetbooks?

Because Knetbooks knows college students. Our rental program is designed to save you time and money. Whether you need a textbook for a semester, quarter or even a summer session, we have an option for you. Simply select a rental period, enter your information and your book will be on its way!

Top 5 reasons to order all your textbooks from Knetbooks:

  • We have the lowest prices on thousands of popular textbooks
  • Free shipping both ways on ALL orders
  • Most orders ship within 48 hours
  • Need your book longer than expected? Extending your rental is simple
  • Our customer support team is always here to help
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

Please wait while this item is added to your cart...