RENT TEXTBOOKS

101 Ready-to-Use Excel Macros

by: Alexander, Michael; Walkenbach, John

ISBN: 9781118281215 | 1118281217

Edition: 1st
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

Summary Table of Contents Author Biography

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 th... MOREey 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 Save time and be more productive with this helpful guide to Excel macros! While most books about Excel macros offer only minor examples, usually aimed at illustrating a particular topic, this invaluable resource provides you with the tools needed to efficiently and effectively program Excel macros immediately.

Save time and increase productivity with these macros Excel macros can make your work easier and you more productive by automating common tasks. But there can be a bit of learning curve when it comes to creating your own macros. If you need immediate help and dont have weeks to learn Visual Basic for Applications (VBA), youve come to the right place. This helpful guide arms you with 101 Excel macros that will solve your issues now! Inside youll find step-by-step instructions for creating these VBA macros, which you can then customize for your applications. This book offers tips, tricks, and detailed explanations along with the actual Excel macros so you can see how they work and where they can be applied. Youll then be able to immediately implement the code and reuse it in other workbooks as you quickly become a macro pro. Let Mr. Spreadsheet show you how to: Go beyond recording simple macros Dynamically manipulate workbooks and worksheets Write code to manage cell or range changes Automate PivotTable features Use VBA to simplify charting and dashboarding Write macros to send e-mails directly from Excel Integrate Excel with other Microsoft Office applications COMPANION WEBSITE Visit www.wiley.com/go/101excelmacros to download workbook files for all examples used in the book.

Introduction 1

Part I: Getting Started with Excel Macros 5

Part II: Working with Workbooks 37

Part III: Automating Worksheet Tasks with Macros 71

Part IV: Selecting and Modifying Ranges 103

Part V: Working with Data 137

Part VI: Working with PivotTables 187

Part VII: Manipulating Charts with Macros 233

Part VIII: E-Mailing from Excel 253

Part IX: Integrating Excel and Other Office Applications 273

Index 302

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, www.datapigtechnologies.com, 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 http://spreadsheetpage.com.

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