Quick 'n Easy Turbo-Start Excel Macros
Save hours on repetitive tasks by automating Microsoft Excel! Get your life back!
Enroll in CourseYou 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 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 this:
- You record hours of repetitive drudgery and re-run it in seconds...
- You edit your recorded Macro to remove missteps...
- You change it to repeat for all selected cells...
- Or repeat a specified number of times...
- You get hours of your day back to use more productively –or go home early!
- You give your colleagues better, faster ways of working...
- You become the star in your company, the "Excel Expert"...
- You stimulate your mind, and
- You get a promotion with a raise!
You can do all 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. 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 should be most useful to you. This low-hanging fruit will give you quick wins. It will get you started fast.
On this course you will:
- Get step-by-step instructions to create Macros in Excel, which means that a small initial effort will save you hours later.
- Discover the macro recorder, which means that you don't program it, it programs itself.
- Learn to read what you have recorded, which means that you can fix it later or share it with your team.
- Uncover pitfalls that trap the self-taught, which means that you won't spend hours stuck trying to solve common mistakes on your own.
- Get examples, which lets you "stand on the shoulders of giants".
- Increase your efficiency in Excel, which means that you'll save hours later.
- Grow in confidence to create your own macros, which means that you'll be self-sufficient.
- 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.
First, you learn. Then you will earn.
Sign up now!
Get started now!
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 this course does not cost $800. How about less than one-eighth?
Yes: Only $97.
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. Study more advanced macros, even... 😊
Can you afford to pass up this opportunity?
Your Instructor
Hello! I'm a trained civil engineer and enthusiastic about Excel.
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.
In parallel, I learned how to code stand-alone programs. It was FORTRAN at university, then various dialects of BASIC. With Microsoft Windows came Excel and Visual Basic. Microsoft married the two in Excel Visual Basic for Applications (VBA).
My knowledge was in demand. So I started training people on 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 my training online. Meanwhile, I have honed my speaking 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
-
PreviewRecording Absolute
-
StartRecording Relative
-
StartWhat’s Inside? How Do Your Macros Work?
-
StartHello, VBE! Meet the Visual Basic Editor
-
StartImprove Your Third Macro by Recording Relative
-
StartAbout Your Third Macro (Relative Version)
-
StartWhere Are Your Other Macros?
-
StartRecap: What Did We Learn in This Section?
Frequently Asked Questions
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 lists the known shortcut key combinations in Excel. A dedicated sheet lists all the pre-allocated Ctrl+ shortcuts (which you should avoid for your macros). It has space for you to note the shortcut keys that you allocate to your universal and local macros.