From the course: Excel 2013 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Definition and examples - Microsoft Excel Tutorial
From the course: Excel 2013 Essential Training
Definition and examples
When you find yourself repeating certain command sequences in Excel, sometimes the thought is, here I go again, same thing all over. Do I have to go through those same six steps, those same eight steps? Ultimately the answer is no. There is a feature in Excel called a Macro. A Macro is simply the ability to take a single step that encompasses many, many steps. Let's start with just a small idea. You're the manager of an HR group, and what you do occasionally is you review this data like what we're seeing here. And when you flag a cell because you think it's incorrect or needs adjustment, what you do, and admittedly this might be overkill. You go to the Home tab; you provide a color background, let's say yellow here. You might make the font red; make it bold and going overboard a bit, maybe even going into Borders, Thick Box Border. It's just to illustrate the idea that we've taken four or five actions here and we like that look. And we like to use it elsewhere too. Now if it's nearby,…
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.