You use Microsoft Excel. A lot.
You repeat the same stuff. A lot.
It might be:
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!"
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!
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:
It may well set you up for promotion and higher earnings.
First, you learn. Then you will earn.
Sign up 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?
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...
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.