From the course: Excel 2016 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Exploring the need for macros
From the course: Excel 2016 Essential Training
Exploring the need for macros
- One of Excel's most powerful features is called a macro. A macro is a way to automate your work. Let's start with a simple idea. Here's a worksheet called HR List. It's in the file called 15 - Macros. From time to time, you flag certain cells here. You're an HR Manager. You've got some other people who work for you who will do the editing and the adjustment of these, and you highlight a cell, and you make it yellow maybe. Maybe add a red Font, and, admittedly, maybe this is overkill, you make it bold, you make it italic. You might even want to add a border. That's five or six steps. I wasn't really counting. For whatever reason, you like that. You'd like to use it again down here. Well, we could copy the format, but you might want to use it tomorrow or the next day or at different times. Wouldn't it be great if we could simply click somewhere, press a keystroke shortcut, have this happen all over again? Now, admittedly, a small series of actions, but the idea behind a macro is…
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.