Excel Macros For Dummies
By Michael Alexander
Publisher: Wiley / For Dummies
Final Release Date: May 2015
Pages: 288

Learn to:

  • Save time, automate, and be more productive with Excel macros
  • Immediately implement and use over 70 Excel macros
  • Understand how each macro works and how to customize it
  • Reuse the macros in other workbooks or with other macros

Maximize these ready-made Excel macros to make your workflow smarter and faster

Macros automate aspects of Excel so you can streamline your workflow and minimize errors. Even if you're not a VBA guru and don't have time to become one, take heart! This book includes some of the most commonly used Excel macros and shows you exactly how to put them to work solving problems you encounter on the job.

  • Macros 101 — get an overview of macro fundamentals, meet VBA and Visual Basic Editor, and learn how macros are constructed
  • Workbook workshop — explore macros that can automate a series of tasks from creating workbooks and backing them up to printing all worksheets at once
  • Navigation and manipulation — discover macros that work together to help you navigate your spreadsheets and manipulate, scrub, and shape data
  • Macro report magic — find macros to help you automate pivot table and chart tasks and automatically email reports as attachments

Visit the companion website at www.dummies.com/extras/excelmacros to download the sample files for each macro in the book. These enable you to see the macro at work and to copy and paste the code.

Open the book and find:

  • Macro solutions for many Excel tasks
  • An overview of VBA basics
  • Ways to customize macros for your needs
  • Tips for streamlining your workflow
  • Troubleshooting advice
  • Methods for automating reports
  • Visual Basic Editor tricks
  • Where to get help with your macros
Product Details
Recommended for You
Customer Reviews
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook:  $29.99
Formats:  ePub, Mobi, PDF