Unlock Excel VBA & Excel Macros

Achieve More. Save time (Real-World Projects & Workbooks included). Automate Complex Tasks with Excel VBA & Macros.

   Watch Video

Go from Beginner to Excel VBA Expert


I'll take you step-by-step through engaging video tutorials and teach you everything you need to know to be able to use VBA to improve your work flow, save time and automate your current Excel projects.

You'll learn to:

1. Enhance your current Excel files & automate your work with VBA.

2. Easily adjust VBA code you find online to fit your purpose.

3. Master Excel VBA & Macros.

4. Directly apply the Excel VBA example files included to your own work.

5. Use VBA when you reach a limitation with formulas or Excel functionality.

6. Create simple solutions to complex problems by levering Excel functionality with Macros.

Don’t waste your time

Don't waste your time on poor quality videos and confusing explanations. In this Excel VBA course, complex topics are taught in a simple way by an instructor with 17 years of experience. The content has been carefully crafted and clearly organized. The videos are high quality and include animations to emphasize points. Most importantly you learn VBA by doing.

What you can look forward to in this course:

  • Understand how to use the right syntax in VBA
  • Useful Excel VBA codes you can directly use for your work
  • Use the macro recorder for simpler tasks and improve the code
  • Working with the Visual Basic Editor
  • Debugging tools and error handling methods
  • Different ways to reference ranges and cells
  • Different methods to loop
  • How to work with data types
  • PivotTables in Excel using VBA
  • Importing data from other files and exporting data to text files
  • Interacting with other applications (Word, PowerPoint, Outlook)
  • ActiveX and Userforms to enhance the Excel interface
  • Basically all the knowledge you need to automate tasks in Excel


 

Regular Price

$199

Today's Price

Only $99

Savings

50% OFF

"I'm already extremely impressed with the organization and professionalism of this course. The course also has exactly what I need to tackle important problems at work. Very good!"

- Kirsch Mackey

"Very professionell approach and very well spoken and detailed information outlined in a good way. I`m a big fan from what I have seen so far. If you are going to grasp the "thinking" and learn the logic behind excel, VBA and different concept from a course. Leilas courses is the one!"

- Niclas Johansson

"It was an amazing experience learning it with Leila. She is a great teacher. The course is designed and conducted in the best of ways. If you are interested in learning about macros without much knowledge of programming and some knowledge of Excel, This course is your way to go. Best wishes to Leila."

- Dishank Gupta

 

What differentiates this course from the other Excel VBA & macros courses?


  1. Over 50 Excel VBA & macro examples. These are solutions my clients have needed through the years. They are likely to be useful for you too.
  2. 22 hours of Video content.
  3. Using the right VBA syntax is the most difficult part. An important topic which isn't covered enough in other VBA courses. In this course you understand why you write things in certain ways.
  4. Create 3 Complete Excel VBA Tools. We go from idea to final product and cover each step.
  5. Over 100 pages of documentation (including useful code) so you can easily refer to it when in need.
  6. Simple explanations for complex concepts.
  7. High quality video and different delivery methods to keep things interesting.
  8. Lots of ideas to automate your current tasks.

"Very clear. Not new to VBA and I thought I would be able to breeze through the first few videos, but had to stop and replay as there was so much I didn't know."

- William Wicks

"I'm loving this course so far!"

- Paola Guevara

"Leila has the amazing ability to not only teach this highly difficult subject in a comprehensible way, but also to combine it with interesting and useful examples plus fancy layouts. I'm very pleased with this Course and can't wait to Code my own Little Tools... Thank you so much!"

- Alexander Brück

Meet Your Instructor


Leila Gharani
Leila Gharani

My courses & tutorials are for those who use Excel at work and want to become better. For those that want to contribute by coming up with solutions to problems.

I don’t just want to show you solutions, but to inspire you to experiment, create and share that with others.

I am a Certified Microsoft Excel Expert and was given the Microsoft Excel MVP award in 2017. I have over 15 years of experience implementing and training users on Management Information Systems of different sizes and nature - these include SAP BW and Oracle HFM.

My background is: Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert & Project Manager. My passion is teaching and solving difficult Excel problems. I am also addicted to learning and enjoy taking online courses on a variety of topics.


Course Curriculum


  Summary & Final Words
Available in days
days after you enroll

 

Who is right for this course


  • Business Professionals who'd like to automate tasks with Excel VBA
  • You currently use Excel - know it well, and want to improve your skills
  • You have Excel on Windows
  • Demonstration is done with Excel 2016 but the techniques work with any version of Excel.

Who's not right for this course


  • You consider yourself a very basic Excel user (I suggest you learn Excel well, before learning VBA).
  • You don't have Excel for PC (Windows) - The course is taught for Excel on Windows. If you have a Mac, I wouldn't be able to help you if you run into problems (I've never worked with a Mac).
  • The course doesn't cover Web-scraping or connecting to third party tools (it covers connecting to Office applications like Word, PowerPoint & Outlook).

Frequently Asked Questions


When does the course start and finish?
You decide when you start and when you finish. It's completely self-paced.
How long do I have access to the course?
After enrolling, you have lifetime access to this course - across any and all devices you own.
Do you offer a guarantee?
Yes. We'd 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.
Why is it priced so low?
I believe knowledge should be affordable. You see, I had the privilege of receiving a good education - but the education that made the biggest difference for me was either free or affordable. It was what I learnt from blog posts, forums, courses and books.
What if I have another question not listed here?
Send us an email at [email protected] and we'll happily answer your query.

This course is closed for enrollment.