Excel Macros For Dummies

Make Excel^® do your routine work

Macros are those little snippets of wizardry that can turn your Excel files from boring old spreadsheets into do-anything super files. Excel^® Macros For Dummies shows you how to get started. Learn how to manipulate data, automate reporting tasks, send emails directly from Excel, assign macros to buttons (fun!), and keep your macros running smoothly. Find over 70 automations you can use right away, plus step-by-step guides and go-to reference material you’ll use again and again.

Inside…

• The what and why of macros
• All about PivotTables
• Using the Visual Basic Editor
• Cleaning up messy data
• Making macros run faster
• Automating all the busywork
• Keeping macros secure
• Fixing errors in your macros