Excel 2007: Reasons to Use Macros


show more Why use macros? provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

Why use macros?

To automate repetitive tasks, you can quickly record a macro in Excel 2007 so that you don't have to repeat the same set of commands or steps over and over and over. So this is a real timesaver, especially if you're going to be doing this often to the same worksheet or sets of workbooks. Now, to set up or to record a macro, you need to set up Excel to allow you to see the Developers tab. Now there's different ways that you could record macros in Excel, and again, because we're working in the essential things that you need to know about Excel, we're going to use the simplest way of doing that. And that's to record our movements on the screen.

First of all though, we need to see the Developers tab, which is not visible at the moment. So what we have to do is we need to go up to our Microsoft Office button and select it, and go back over to our Excel options button that we were looking at at the very beginning of our set of movies. And in doing that, on our very first...

Why use macros?
Video duration: 2m 13s 5h 13m Beginner

Viewers:

Why use macros? provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...