Excel Macros For Dummies, 3rd Edition

Book Description

Save time and become an Excel wizard with the world’s leading Excel macro guide

Do you love Excel and all the things you can do with it, but wish you could just work…faster? Excel macros—automated workflows that save you time and energy—might be just what you need. In Excel Macros For Dummies, you’ll learn over 70 of the most productive, time-saving macros in less time than it takes to back up the files on your computer!

Every chapter in the book gives you practical info and exercises you can put to work immediately, alongside step-by-step instructions and guidance on how to customize Excel to fit your every need. Inside, you’ll find:

• Automations that take your Excel productivity to the next level, and beyond
• Fully updated macros compatible with the newest version of Excel included in Microsoft 365
• Careful explanations of the basics as well as tips for the advanced user

With something for everyone, Excel Macros For Dummies is the productivity supercharger you’ve been waiting for. Grab a copy today!

Table of contents

Part 1 Holy Macro Batman!	
Chapter 1 Macro Fundamentals
Chapter 2 Getting Cozy with the Visual Basic Editor
Chapter 3 The Anatomy of Macros

Part 2 Making Short Work of Workbook Tasks	
Chapter 4 Working with Workbooks
Chapter 5 Working with Worksheets

Part 3 One-Touch Data Manipulation	
Chapter 6 Feeling at Home on the Range
Chapter 7 Manipulating Data with Macros

Part 4 Macro-Charging Reports and Emails	
Chapter 8 Automating Common Reporting Tasks
Chapter 9 Sending Emails from Excel
Chapter 10 Wrangling External Data with Macros

Part 5 The Part of Tens	
Chapter 11 Ten Handy Visual Basic Editor Tips
Chapter 12 Ten Places to Turn for Macro Help
Chapter 13 Ten Ways to Speed Up Your Macros

About The Author

Dick Kusleika

Dick Kusleika has been helping users get the most out of Microsoft Office products for more than twenty-five years through online forums, blogging, books, and conferences.