Excel Macros For Dummies, 2nd Edition

This book assumes no prior programming experience, so even programming novices can get up to speed quickly on the basics of Excel macros and the VBA language.  Each chapter shows how to perform common tasks 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. 

Each chapter will offer the reader practical macros that can be implemented right away. This book reinforces the reader's learning by presenting practical exercises, incrementally extending the reader's knowledge.

After reading each element of this book, the reader will be able to:

• Immediately implement the given Excel Macro
• Understand how the given macro works
• Reuse the given macro in other workbooks or in conjunction with other macros

Content Overview:

• Macro Fundamentals
• Getting Cozy with the Visual Basic Editor
• Anatomy of Macros
• Working with Workbooks
• Macros that Give you the Sheets
• Feeling at Home on the Range
• Cleaning Data with Macros
• Automating Common Reporting Tasks
• Sending Emails from Excel
• Automating Data Retrieval with Power Query
• Ten Handy Visual Basic Editor Tricks
• Ten Places to Turn for Macro Help