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

Definition and examples - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

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,…

Contents