Did you Know?

If you are not automating Excel, you are losing time —possibly hours— every week!

"But", you say, "I don't know how to automate Excel!"

You will after this simple, short course.

You use Microsoft Excel. –A lot.

You repeat the same stuff. –A lot.

It might be:

  • Converting data from one format to another
  • Importing data from a different source
  • Re-formatting data
  • Rearranging data
  • Consolidating or summarizing spreadsheets
  • Re-doing the same calculations

Are you repeating the same action many times? 

Are you sick of working long hours? 

Do you miss family time?

Do you hate your dead-end job because you just keep re-doing the same old things in Excel? 

Do you feel like a robot, when you know you could be doing so much more?

Do you say to yourself, "If only Excel could remember and repeat what I did yesterday / last week / last month!" 

IT CAN!

You are talking about Excel Macros. 

Macros can record your actions in Excel. 

Then you can play them back many times. 

And that is only the beginning! 

Imagine being able to:

  • Record hours of repetitive drudgery and re-run it in seconds...

  • Edit your recorded Macro to fix any mistakes or improve it...

  • Change it to repeat for all selected cells...

  • Or repeat a specified number of times...

  • Get hours of your day back to use more productively –or go home early!

  • Give your colleagues better, faster ways of working...

  • Become the star in your company, the "Excel Expert"...

  • Stimulate your mind, and

  • Get a raise and a promotion!

You can do this with Excel Macros.

You know Excel spreadsheets.

Here, you will discover how to create Windows Excel Macros.

You do not need to know anything about Macros yet.   Nor the programming language they use.  In fact, you don't need to know anything about programming.

This is a "quick start", not an in-depth course. You get the cherry-picked parts that are the most useful. This low-hanging fruit will give you quick wins. It will get you started fast. 

On this course you will:

  1. Get step-by-step instructions to create Macros in Excel, which means that a small initial effort will save you hours later.
  2. Discover the macro recorder, which means that you don't program it, it programs itself.   
  3. Learn to read what you have recorded, which means that you can change it later as needed.
  4. Uncover pitfalls that trap the self-taught, which means that you won't spend hours stuck trying to solve common mistakes on your own.
  5. Get examples, which lets you "stand on the shoulders of giants".
  6. Grow in confidence to create your own macros, which means that you'll be self-sufficient.
  7. Increase your efficiency in Excel, which may mean more pay or a better job. 
  8. See how to save hours of repetitive, boring work, which means that your life will be more interesting, more exciting

It may well set you up for promotion and higher earnings. 

Become a more accomplished, more fulfilled, happier person!

What could you do with macros?

Here's an example of importing a CSV file, removing columns, formatting and sorting. A macro cuts the time tenfold.


What about the course cost?

What is your time worth?

You know; I don't.  Let's take a guess.

In 2019, average hourly pay for a Senior Administrative Assistant with Microsoft Excel skills in the US was around $20/hr.

You are going to invest six to ten hours studying this course. I expect it to save you at least an hour a week. Over the course of a year, that's about 50 hours. Deduct, say, 10 hours you spent studying the course.

That leaves 40 hours saved.  Using our average, that's a value of $20 x 40 = $800 value.

And that's only in one year!

But your investment in this course is not $800. How about less than one-fifteenth?

Of course (pun intended), we've looked at the benefit in mere money.  Yet that hour a week (or many more) could be time you don't have to work unpaid overtime. It could be extra time you can spend with your loved ones, your children, your dog, your cat, your hamster.  You could use it to catch up on sleep. Meditate. Do yoga. Have more sex.  Even study more advanced macros... 😊

Can you afford to pass up this opportunity?      

Your Instructor

Rick Raubenheimer

Hello!  I'm a trained civil engineer and use Excel a lot.

The first spreadsheet I used was Lotus 1-2-3 on MS-DOS. I liked the idea of automating it, and learned how to record and edit macros.

With Microsoft Windows came Excel and Excel Visual Basic for Applications (VBA).

My knowledge was in demand.  I started training people to use computer programs, including Excel. First, I trained staff at the firm of consulting engineers where I worked.  Later I joined my future wife in her company.  We offered computer training and, later,  computer programming.

I have written many Excel spreadsheets, often with macros, both for clients and in-house use.  I've created programs in Microsoft Access, Visual Basic, VB.NET, and others.  I have excellent knowledge of VBA across Excel, Access, Outlook and Word.

I have trained people on computers in person for many years. Now I am putting our training online. Meanwhile, I have honed my presentation skills at Toastmasters International: I'm now a "Distinguished Toastmaster", the highest level a Toastmaster can achieve.

I have an informal, easy-to-follow training style. I hope you enjoy it. Let's get started... 

Course curriculum

  • 1

    Chapter 1: Your New Life Starts Here (Introduction)

    • 1.1 Why Should I Learn Excel Macros?

    • 1.2 A Demonstration to Whet Your Appetite

    • 1.3 Welcome on the Path!

    • 1.4 Preliminaries
  • 2

    Chapter 2: Some Quick Wins

    • 2.1 Your First Macro: Frequently-Repeated Text

    • 2.2 Your Second Macro: Formatting Headings and Columns

    • 2.3 Introducing the “Developer” Ribbon

    • 2.4 Your Third Macro: Convert names to Proper Case

    • 2.5 Recap: What Did We Learn in This Section?

    • 2.6 That was Easy – Now What?
  • 3

    Chapter 3: A Pitfall: Should I Record Absolute or Relative?

    • 3.1 Recording Absolute

    • 3.2 Recording Relative

    • 3.3 What’s Inside? How Do Your Macros Work?

    • 3.4 Hello, VBE! Meet the Visual Basic Editor

    • 3.5 Improving Your Third Macro: Recording Relative

    • 3.6 About Your Third Macro (Relative Version)

    • 3.7 Where Are Your Other Macros?

    • 3.8 Recap: What Did We Learn in This Chapter?
  • 4

    Chapter 4: A Map: Finding Your Way Around the VB Editor

    • 4.1 Ribbons, Buttons and Bows!

    • 4.2 Highlights of the VB Editor Menu

    • 4.3 Better Editor Options

    • 4.4 Lowlights of the VB Editor Toolbars

    • 4.5 OK, But What Use is It? VBE Exercise: Debugging Code

    • 4.6 Recap: What Did We Learn in This Chapter?
  • 5

    Chapter 5: Beyond Mere Recording – Basic Coding

    • 5.1 Learning the Lingo: ¿Habla Visual Basic for Applications, Señorita?

    • 5.2 Excel Didn’t Record What I Did!

    • 5.3 Basic Variables: Holding Values Temporarily

    • 5.4 How to Get and Change the Contents of Cells

    • 5.5 Handy Built-In Functions

    • 5.6 How to use Conditions: “If” Statements

    • 5.7 Building the Code

    • 5.8 Looping the Loop: How to Repeat Code

    • 5.9 Recap: What Did We Learn in This Chapter?
  • 6

    Chapter 6. Resources and Wrap-Up

    • 6.1 Here’s Your Free Bonus!

    • 6.2 Where Are We Now?

    • 6.3 Help! I'm Stuck!

    • 6.4 Now Continue Your Journey

FAQ - Frequently Asked Questions

  • When does the course start and finish?

    The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.

  • How long do I have access to the course?

    How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.

  • What if I am unhappy with the course?

    We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

  • I already know a bit about Excel Macros. Will I still benefit?

    You should: There are always things one can learn. Why not take the course, and use the 30-day refund option if you feel you did not get enough value?

Bonus!

Enroll now and receive, free, our Excel file "Excel Shortcut keys & My Macro Shortcuts".

When you have created some macros, you will want a record of which shortcut keys you have allocated to them. This resource includes a list of the known shortcut key combinations in Excel. We also list all the pre-allocated Ctrl+ shortcuts (which you should avoid for your macros). That sheet also has space for you to note the shortcut keys that you allocate to your universal and local macros. .

Get started now!

Limited-time introductory price: More than 50% off your normal investment.