From the course: Excel 2010 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Understanding macros - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
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 to be used inside…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.