Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
*** Completely up-to-date for November 2016 ***
*** This course is fully subtitled in English! ***
Become a proficient Excel Macro Programmer in a very short time.
Excel Macros are powerful. Everybody wants to learn Excel Macros and VBA. They can make Excel work like magic. But most Excel users never use them. Other spending several days on a multi-hour course or working through a 1000-page book, getting overwhelmed with information. So why waste a great deal of time learning things you may never use.
In this course my goal is to help you learn ways to create Excel Macros that won’t burst your brain. Also to convey the main principles of VBA language and allow beginners, taking their first steps, to learn without requiring individual training.
Content and overview
A macro is a sequence of instructions that automates some aspect of Excel so that you can work more efficiently and with fewer Errors. Macros are written in VBA, which stands for Visual Basic for Applications, is a programming language developed by Microsoft.
If you think Excel VBA programmers are smarter or more gifted than you, then you’re mistaken. Yes, macros can be intimidating and yes, programming is a huge topic. If you saw a course on Excel programming with hundreds of lectures, would you really watch all of them?
But wait a minute… What about people who may not have programming background, but aspire to reap the utmost from the program? Are there any programming principles and well-guarded secrets that you can learn and use them to create any Macros you want?
In this course you will find several short, to the point lectures covering Excel Macros and VBA entertaining and accessible to non-techies. The goal is not to make you a star Excel programmer. If you want to be that, go for it! But I’ll give you some best practices and make this course extremely practical. After all, you are not a programmer, you just need to write an Excel Macro to help you get your work done.
Why is this course different?
Are you looking to learn practical Macro techniques you can put to use instantly? If so, then this is the course for you. It’s entirely project based and it’s full of examples which are fully explained and easy to understand. It has been recorder with the brand new Excel 2016 in full HD 1080p. If you get stacked don’t worry. I have fast and fully support through the discussion board. And if you don’t like the course simply return it. There is a 30-day money back guarantee. At the end of this Microsoft Excel class you will be given a Certificate of Completion
What are you waiting for? Enroll now! (it is 100% no risk deal)
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
Introduction of the course
Become a proficient Excel Macro Programmer in a very short time.
The secret to success with Excel Macros and VBA is start small, break tasks down into smaller parts and of course practice and practice.
|Please take one minute to introduce yourself to the rest of the course|
Download the Excel Project Files + Course Study Tracker
Let’s get started by answering the most common questions.
I need your help!
|Section 2: The Basics of Macros|
|With macros you can take multiple steps sequences and turn it into a single step
In this Lecture we are going to learn how we can use Macros.
|As we said in previous lecture, a macro is a set of instructions or code that you create to tell Excel to execute a number of actions. Let’s see some examples to understand how you can use them to automate repetitive tasks|
All workbooks with an .xlsx file extension are automatically known to be safe, whereas you can recognize .xlsm files as a potential threat. Learn all the secrets of security in this Lecture.
|Rules regarding Naming Macros|
|There are many ways to start recording a macro.
Learn the most important.
Running a Macro using the Ribbon
|Running a Macro using the Quick Access Toolbar|
Here is a list of key combinations with letters. You want to avoid associating a macro with the following combinations
|Running a Macro using Buttons or Graphics|
Quiz 1: The Basics of Macros
How can I help you?
|Section 3: Enter the world of VBA|
Welcome to the 2nd main section of this course. It’s absolutely awesome that you are here to enter the world of Excel VBA
|Like all programming languages, dealing with errors can by scary. Anytime you start something new you will make mistakes. But you don’t know that most of the times mistakes are easy to resolve|
Learn the differences between these two methods to create an automated task
|Take your first look behind the curtain to explore Visual Basic Editor|
|Visual Basic Editor contains several windows that you can customize and make your life easier|
Quiz 2: Enter the world of VBA
|Section 4: Get in-depth with Macros|
Learn in detail the most important elements of VBA
|Most of the time when we create a macro, it is designed for use in a specific workbook. But
what if you want a macro to be available all the time, regardless which workbook is opened that time?
|If you work with macros a lot, you may need to organize them based on what a macro really does|
In this lecture you'll learn the steps in detail to record and test a macro
A simple but effective way to run a macro is with the help of form controls and specifically buttons. How can you do that?
Quiz 3: Get in-depth with Macros
|Section 5: How to create your First Piece of Code|
|Welcome to this new Section, it’s fantastic that you made it here, as you are going to create your first piece of code. And in this lecture, we are going to write our first line of VBA code|
|I hope you ‘re excited writing your first code in the previous lecture. Now we’ll continue to learn more about the 3 important elements of VBA|
In this lecture I wonna talk about With End With statement
|From the previous lecture we learned how to use With for a specific workbook. Using With is fine when we have one workbook or worksheet. But when using multiple sheets we need to use something else. This is where Dim and Set comes in|
You have already learned how to write a value to a cell. But what if you want to read from one cell to another?
Learn how to use Range and Cells properties
|Variables are extremely powerful when we create Visual Basic applications|
Quiz 4: How to create your First Piece of Code
|Section 6: Supercharge Macros and VBA with Loops|
|In this lecture you'll understand how important are the If Then Else statements and the freedom that give us when we want to create trickier macros|
|Using Relative or Absolute Reference and the difference between them
|If you need to count something or you need to loop through a series of predetermined elements within a given set then the For and Next statements are a must.|
Using DO…UNTIL Statements with Macros
Case Study: Prompting a user to select a worksheet and run a macro
Sometimes we need to create more complex macros. Learn how to combine Macro Recording and VBA Statements
|How to join 2 different Macros|
Tips for running your Macros fast
How to Automatically Transfer Data From One Excel Worksheet To Another With Vba and Macros.We use a command button and code it using VBA so that the data entered by an operator is automatically transferred to another worksheet on click.
Quiz 5: Supercharge Macros and VBA with Loops
|Section 7: Ready-to-use Excel Macros|
|Saving a Workbook before Closing|
|Closing All Workbooks at Once|
My Final Thoughts & Thank you!
|Section 8: BONUS SECTION|
Great discounts for my other courses!
Hi, I am Andreas and I'm a teacher. I really love learning and teaching whenever I can.
I have over 16 years of experience in teaching as an instructor, especially in Microsoft Excel. I have my own computer learning school, called Futurekids, from 2001 to now. I am the founder of Mellon Training, an online video tutorials learning school.
I have a Master's Degree in Computer Science and a Degree in Electronic Engineering.
I always wanted to create my own business. Being your own boss is an incredibly liberating experience but difficult as well.
I have a passion for software products that make people's lives easier. I teach Python Programming, Microsoft Excel and all Microsoft software products for over 17 years. I am a professional Forex Trader for over 5 years.
I love to create websites and optimize them with Search Engine Optimization techniques. I created my online e-shop, called Bite me not jewels, with my wife.
I live in Rodos, a beautiful Greek island. When I am not working, I love being with my family and my two kids. Travel, forex trading, and reading books are my favorite hobbies.