Lesson 1: The basics of Macros.
A basic overview of Excel macros and how to set up the environment in order to use them.
Introduction
This lesson will introduce you to the concept of macros and explain why they are important, and how to use them. I will show you how to prepare Excel to use macros and will discuss important aspects of the macro development environment. I will make significant reference to the recommended text books to help fill in the necessary background that you will need to effectively use macros in your daily activities with Microsoft® Excel.
No prior knowledge of macros is assumed and I will provide all of the example spreadsheets used in this course for you to practice with while learning. There are a number of versions of Microsoft® Excel in use today ranging from Excel '97 to the very latest, Excel 2003.
All of the code examples used in this course have been created using Excel 2002, but they should work perfectly well in any version. The main goal of this class is to give you ideas of how you can incorporate the use of Excel macros into your day-to-day work with Excel. The approach I plan to take is to present a typical problem that I had to solve, and then show you how I went about using macros to solve it.
From this approach, I hope to show you how to breakdown a problem into its specific parts, create the appropriate macro code for each of these parts, and then assemble the individual code parts into a final solution. The resulting macro will then be a part of your utility toolkit for use anytime you need it.
The Files: PDF Version of Lesson 1
