O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 14

Automating Tasks with Macros and VBA

So far in this book, you've learned about the many things you can do with Excel when working manually—everything from creating new workbooks to entering data in them to creating charts from that data.

Whatever kind of work you do in Excel, chances are good that you'll need to perform some tasks repeatedly. You can continue to perform them manually if you choose, but you may be able to save any amount of time and effort by automating them.

In this chapter, we'll look at how you can automate tasks by using macros and Visual Basic for Applications (VBA), the programming language included in Excel 2011 and the other Office 2011 applications. We'll look at how to record macros in general, then go through ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required