The Use of Macros in Excel 2010


show more Understanding macros provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training show less
please wait ...

Understanding macros

When you use Excel a lot, especially if you're using it for the same tasks over and over again, you'll find that you're executing the same procedures repetitively. Well you might say to yourself, gee, there had got to be a faster and easier way. I keep doing the same thing over and over again. Well you don't have to do it because macros can do the repetitive work for you. Well let's talk about what a macro is. Macros are basically little bits of instruction code that run inside Excel. Now macros can be very simple or they can turn Excel into software development and there is even alone industry of people writing macros for Excel.

Well, how do you create a macro? There are two basic ways. One way is that you can record your mouse clicks and keystrokes, kind of like recording a TV program and then playing it back. The other way is that you can write the program in a language called Visual Basic for Applications or VBA for short. It's a language that Microsoft developed...

Understanding macros
Video duration: 3m 5s 6h 21m Beginner

Viewers:

Understanding macros provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...