Allen Wyatt

Isn’t It Time for You to Master Macros?

Years ago I was living in Indianapolis, working at a great job, and dreading going to work. As I recounted in this video, I spent huge chunks of my time doing the same things over and over again in Excel. It was hard, mind-numbing work.

Fortunately, I found a way out of the drudgery and abolished the dread I felt in dealing with my work. This discovery created an “escape hatch” for me; it allowed me to make the repetitive work a snap, and I could breeze through it quickly and easily. Literally, what used to take me about 12 hours to do, I was able to do in a matter of minutes.

What was the secret I discovered? In a word, macros.

But you knew that, didn’t you? There’s a good chance you already know that macros can do for you what they did for me. You probably know that if you just knew how to create your own macros, you could deal with a lot of the drudgery you now feel when you use Excel every day.

So. Here’s the question: Isn’t it time for you to learn how to master macros?

You know it is. You know this is a great way to start the new year off right—by learning a new skill that can augment your Excel skill set and better your work life.

I want to help you do that. I want to introduce you to the power of macros, show you what they can do, and show you how they do it. If you do any work with Excel, I can show you how to make that work easier and faster.

This really is powerful stuff! (But you already knew that, too, right?)

Does learning how to create and use macros scare you just a bit? I understand that feeling, but I also know from personal experience that with just the right type of instruction and some effort on your part, you can—just like I did—develop your own macros and make quick work of the repetitive drudgery you face on a daily basis.

The macros you create can make the work you do more enjoyable, allow you to do it faster, and (along the way) establish you as a “get it done now” type of person.

That’s why I developed my Excel Macros Master Class courses—to help you improve your skills and get more done with Excel. Even if you’ve never touched a macro before in your life, I’m convinced you’ll benefit from my beginning course, and if you have used macros before, there’s a good chance you’ll benefit from my advanced course.

“Although I wouldn’t have classified myself as a beginner at developing VBA macros, I still learned a good bit [from Allen’s course]. The downloadable workbooks included with most sessions will come in quite handy as reference material moving forward. Thanks for the high quality work which is typical of everything you do.”
—Barry

 

What the Courses Cover

There are two Excel Macros Master Class courses, and each of them is geared toward a different level of Excel user. If you are an absolute “macro novice,” just taking your first steps on the journey of discovery that will allow you to master macros, then my Beginning Excel Macros Master Class course is just what you need. If you already know the basics of macros but need to “up your game,” so to speak, then you’ll benefit by my Advanced Excel Macros Master Class course.

Whichever course you choose, you’ll find it packed with great information. Each course is divided into sections, each covering a major topic area related to working with macros. Each section is further divided into a series of sessions (or, if you prefer, lessons) that are individually crafted to help you expand your understanding of macros. Further, the course is designed to help you progress and succeed at your own pace.

Here’s a quick rundown of the sections in each course:

Beginning Excel Macros Master Class   Advanced Excel Macros Master Class
Section #   Section Title
100   Course Introduction
101   Setting Up Your System
102   Two Methods to Create and Use Macros
103   Managing Macros
104   Understanding VBA Projects
105   Understanding VBA Procedures
106   Understanding Variables and Operators
107   Understanding VBA Functions
108   Interacting with the User
109   Affecting Program Execution
110   Understanding Excel’s Object Model
111   Working with Ranges and Selections
112   Manipulating the Worksheet Object
113   Adjusting Worksheet Structure
114   Manipulating the Workbook Object
115   Putting Macros to Work
116   Debugging Macros
117   Course Wrap-Up
Download Detailed Outline
 
Section #   Section Title
200   Getting Started
201   Accessing the Excel Environment
202   Letting Users Access Your Macros
203   Advanced Ways to Work with Data
204   Searching and Replacing
205   Working with Non-Workbook Files
206   Working with Files and Folders
207   Creating Event Handlers
208   Creating and Using UserForms
209   Building and Using Your Own Add-Ins
210   Honing Your Skills
211   Using the Visual Basic Editor
212   Using the Debugging Tools
213   Final Words
Download Detailed Outline

As I said—these courses are packed with information! Remember that each of these sections are further divided into multiple sessions; between the two courses there are 115 of them, in all. If you want an even more detailed outline of the course, you can download it by clicking or right-clicking the link just below the section list of the desired course, above.

“As a weekly subscriber to Allen Wyatt’s ExcelTips, I signed up for his course with high expectations. My expectations were exceeded! The course’s session format is well designed, and Allen is clearly a master at both Excel and teaching it. If you want to get an understanding of the basic building blocks for building macros—this is your course!”
—Joe Crance (MBA)

 

A Sample Course Session

To give you a taste for how I present information in the course, I want to share one of the sessions from the Beginning Excel Macros Master Class course. Below is the video for session 101-1, “Getting Ready to Work with Macros.” This session is part of section 100, which you can see in the section outline, above. (Hint: You may want to maximize the video so it fills your screen. I find this helpful when viewing sessions.)

 

 

I hope that gives you an idea of how I conduct my courses—I try to be clear, concise, and complete when discussing any particular topic. Note that for this particular session, the supplemental materials include two transcripts (one “raw” and the other edited). These supplemental materials are available on the session’s page once you register for the course. In addition, you may have noticed that this sample session (and all the sessions in both courses) include closed captions, which can be a great aid for those who are hard-of-hearing.

 

What Course Registration Includes

If you decide to sign up for one of my Excel Macros Master Class courses, here’s what registration as a class member gives you:

  All the videos for the course  
  A downloadable Excel workbook for most sessions, so you can follow along with what is presented in the video  
  Two types of downloadable transcripts for each video (the raw transcript and an easier-to-read edited transcript)  
  Additional downloadable supplemental materials, if necessary for the session  
  Closed-captioning available for each streaming video session  
  The ability to pause, rewind, and replay the videos as many times as you want  
  The ability to watch, work, discover, and learn at your own pace, without any artificial deadlines  
  The ability to mark each session as completed so you can easily track your progress in the course  
  12 months of full access all course materials, including videos and supplemental materials  
  Unlimited 24/7 access, as long as you have an Internet connection  
  Support from me (Allen Wyatt) as you learn to create your own macros  
  Optional (added cost) ability to download videos to your system or have them sent to you (every class member has streaming access to videos, but you may want access to the actual video files)  
  A suitable-for-framing certificate of completion (mailed to you) available at the end of the course, upon request  
  100% 30-day money-back guarantee (You get plenty of time to try out the course)  

 
I’ve structured my Excel Macros Master Class courses so that it is easy to develop the skills you need when it comes to macros. Plus, I’ve done my best to pack each course with features and benefits that make it an absolutely awesome value.

 

The Price for All this Awesomeness?

The registration fee for the courses is a fraction of what in-person events can cost. (I should know—I’ve attended and taught my fair share of such events!) The amount depends on which course you choose, whether you want the course in streaming format, or if you want the ability to download the video files in addition to streaming.

There are two courses (beginning and advanced) and two options for each course (streaming or streaming+download). In addition, if you want to register for BOTH the beginning and advanced courses, I’m offering them together for a special bundle price.

Beginning
Excel Macros
Master Class Course
  • High-quality streaming video for all sessions
  • Watch videos on multiple devices
  • Excel workbooks for appropriate sessions
  • Closed-captions (streaming video only)
  • Transcripts (2 versions) for each session
  • Additional downloadable supplemental materials,
    if necessary for the session
  • Pause, rewind, and replay videos as many times as you want
  • Watch, work, discover, and learn at your own pace
  • Online tracking of the sessions you’ve completed
  • Lifetime access to supplemental materials downloaded
    during your 12 month registration period
  • 12 months of access to all course materials online
  • Unlimited 24/7 access during your 12 month registration period (as long as you have an Internet connection)
  • Personalized help in learning macros during
    your 12 month registration period
  • Certificate of completion suitable for framing
    (upon request)
  • 100% money-back guarantee during the
    30 days following registration
  • Register Today!

  • $247

  • Beginning Excel Macros
    Master Class Course
    + Video Download Option
  • Everything above, PLUS everything shown below.
  • Downloadable course video files in
    720p high-def format
  • Downloadable course video files in
    1080p high-def format
  • Lifetime access to videos
    downloaded during your
    12 month registration period
  • Video files sent to you on
    USB hard drive
    (upon request)
  • Register Today!

  • $347
Advanced
Excel Macros
Master Class Course
  • High-quality streaming video for all sessions
  • Watch videos on multiple devices
  • Excel workbooks for appropriate sessions
  • Closed-captions (streaming video only)
  • Transcripts (2 versions) for each session
  • Additional downloadable supplemental materials,
    if necessary for the session
  • Pause, rewind, and replay videos as many times as you want
  • Watch, work, discover, and learn at your own pace
  • Online tracking of the sessions you’ve completed
  • Lifetime access to supplemental materials downloaded
    during your 12 month registration period
  • 12 months of access to all course materials online
  • Unlimited 24/7 access during your 12 month registration period (as long as you have an Internet connection)
  • Personalized help in learning macros during
    your 12 month registration period
  • Certificate of completion suitable for framing
    (upon request)
  • 100% money-back guarantee during the
    30 days following registration
  • Register Today!

  • $347

  • Advanced Excel Macros
    Master Class Course
    + Video Download Option
  • Everything above, PLUS everything shown below.
  • Downloadable course video files in
    720p high-def format
  • Downloadable course video files in
    1080p high-def format
  • Lifetime access to videos
    downloaded during your
    12 month registration period
  • Video files sent to you on
    USB hard drive
    (upon request)
  • Register Today!

  • $447
BOTH Courses Together
Beginning and Advanced
Best Value
  • High-quality streaming video for all sessions
  • Watch videos on multiple devices
  • Excel workbooks for appropriate sessions
  • Closed-captions (streaming video only)
  • Transcripts (2 versions) for each session
  • Additional downloadable supplemental materials,
    if necessary for the session
  • Pause, rewind, and replay videos as many times as you want
  • Watch, work, discover, and learn at your own pace
  • Online tracking of the sessions you’ve completed
  • Lifetime access to supplemental materials downloaded
    during your 12 month registration period
  • 12 months of access to all course materials online
  • Unlimited 24/7 access during your 12 month registration period (as long as you have an Internet connection)
  • Personalized help in learning macros during
    your 12 month registration period
  • Certificate of completion suitable for framing
    (upon request)
  • 100% money-back guarantee during the
    30 days following registration
  • Register Today!

  • $497

  • BOTH Courses Together
    Beginning and Advanced
    + Video Download Option
  • Everything above, PLUS everything shown below.
  • Downloadable course video files in
    720p high-def format
  • Downloadable course video files in
    1080p high-def format
  • Lifetime access to videos
    downloaded during your
    12 month registration period
  • Video files sent to you on
    USB hard drive
    (upon request)
  • Register Today!

  • $697

 
Important Note: Those who choose to register for the “Streaming + Video Downloads” option receive, 31 days after signing up, access to a download page that provides the video files (without closed-captioning) in two formats: 720p high-def and 1080p high-def. High-quality video files are HUGE, so I also provide the opportunity for “Streaming + Video Downloads” registrants to have the video files sent to them in both formats on a USB 3.0 hard drive at no additional cost, upon request. Access to the downloadable video files is provided 31 days after registering because the first 30 days constitute the “kick-the-tires” period where any registrant can ask for a full refund of the registration fee.

I’m excited about these courses!

I’m betting that you can catch a glimpse of why I’m excited. While I can’t come to your hometown and host one of my two-day Excel seminars, I can do the next best thing and provide the online tools you need to finally harness how to create and use macros. And, I can provide it at a lower cost than a “hometown seminar” and provide more features and benefits.

“I want to report successful completion of your course. I enjoyed the freedom of viewing the videos as my schedule permitted. Also, it really helped to have topics available to view multiple times as I tend not to learn quickly. The videos together with the workbooks and transcripts provided a complete package that was well worth the cost of the course.”
—David

 

Accepting New Students

I only open the doors to my courses a few times each year. The doors are open right now (or you wouldn’t be reading this), but they won’t stay open for long. Here’s the complete rundown on important dates relative to this course opening:

  • May 9, 2018: Doors to the course open; new students can register. Early bird pricing is in effect.
  • May 16, 2018: Early bird pricing ends at end of the day.
  • May 24, 2018: Doors to the course close at end of the day.

Once the doors close, my estimation is that they won’t open again for about 4 months. I close the doors like this so that I can block the time necessary to help the influx of students that always occurs.

Remember, you can register anytime that I’m accepting students (like right now), and when you do, you’ll have immediate access to the course for which you decide to register.

If you don’t have time for the course immediately, but you anticipate that you will within the next month or so, you may want to go ahead and register now. My courses are self-paced, and even though you get immediate access to the course upon registration, you can delay starting for a bit, if that better fits your schedule. You have access to the course for a complete year (12 months) from the time you register.

 

Still Can’t Decide?

If you are still on the fence about registering for a course, consider a few things:

  1. The full course outlines are fantastic. I provided a quick overview of the outline, above, but you can check out the full outline by scrolling back up and downloading your own copy. (The links are right under the section listing for each course.)
  2. I’ve actively tried to provide more support materials to class participants than other online courses. (I don’t know of other courses, for instance, that provide the powerful combination of a printed outline, two sets of transcripts, and available closed-captioning.)
  3. I make myself available to course participants, through this website and via e-mail, for as long as you are registered for the course. (In other words, you won’t be left on your own as you work through the course—I’ll be there to help you.)

I’ve spent an immense amount of time and resources to put together the Excel Macros Master Class courses. In these courses I show you the real power of macros in an approachable, achievable way. If you decide to register for a course, I want you to acquire real, marketable skills you can use regularly. It will take work on your part, but I’m there to help you out as you finally master how to work with macros!

The bottom line is that my courses are for regular people who simply want to increase their knowledge about Excel and make it work the way they want.

“There is a great need for this. I teach Excel (and other Office applications) at a couple of local colleges, Continuing Ed, and can tell you there are people who have been using Excel for years but do not know the basics, shortcuts and tips and tricks, so it is not just the newbie that has the need. Thanks for all the great content that you have provided over the years!”
—Gayle

I’m confident you won’t be disappointed in these courses but, even so, there is no risk on your part. As I’ve noted a few times on this page, my courses are covered by a 100% 30-day money-back guarantee, the same as all my other products. If you don’t like what you see or it’s not working out for you, just e-mail me and request the refund. My only requirement is that you do it within 30 days from when you first register. (That gives you plenty of time to “kick the tires” and try everything out.)

Are you ready to expand your knowledge of Excel and finally (finally!) conquer macros? If so, I’m ready to help you gain the skills you need. All you need to do is register by scrolling back up to the pricing table and clicking the button for the course option that’s right for you.

Do you have other questions about the Excel Macros Master Class courses? E-mail me (Allen@MacrosMasterClass.com) and I’ll get you helped out as quickly as I can.