From the course: Excel: Macros in Depth (Microsoft 365)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Planning a macro
From the course: Excel: Macros in Depth (Microsoft 365)
Planning a macro
- In this movie and in the following six movies in chapter six, we're going to be working on a macro project. And it's most important in this particular chapter to be sure as you watch a movie you have watched the previous movie. It is best to watch them in order too because each movie depends upon what the previous movie has presented. There's a list here in column B. We saw in earlier movies but we're going to do something different with it. And it's actually based on a real life example. And we got a huge list here of realtors that happen to be from Colorado. Now let's imagine that you get this list once a month and furthermore you're going to be getting these from other states as well too. I'll click on one of these sales, double click its bottom edge, that's a quick way to get to the bottom. This is 2400 rows. So we've got 400 different realtors here, six rows each. Now, what we want to be able to do is to take…
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.