Unlock Excel VBA and Excel Macros (Udemy.com)

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

Created by: Leila Gharani

Produced in 2022

What you will learn

  • Enhance your current Excel files & automate your work with VBA.
  • Master Excel VBA & Macros
  • Directly apply the Excel VBA example files included to your own work.
  • Reduce manual routine tasks to the click of a button.
  • Make your work-life easier.
  • Create simple solutions to complex problems by levering Excel functionality with Macros.
  • Formulas & Excel core functionality can't do everything. Use VBA when you reach a limitation.
  • Easily adjust VBA code you find online to fit your purpose.

Quality Score

Content Quality
Video Quality
Qualified Instructor
Course Pace
Course Depth & Coverage

Overall Score : 92 / 100

Live Chat with CourseDuck's Co-Founder for Help

Need help deciding on a excel course? Or looking for more detail on Leila Gharani's Unlock Excel VBA and Excel Macros? Feel free to chat below.
Join CourseDuck's Online Learning Discord Community

Course Description

Go from Beginner to Microsoft 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.
What differentiates this course from the other Microsoft Excel VBA & macros courses? It includes:
  1. Over 50 Microsoft Excel VBA & macro examples. These are solutions my clients have needed through the years. They are likely to be useful for you too.
  2. 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.
  3. Create 3 Complete Excel VBA Tools. We go from idea to final product and cover each step.
  4. Over 100 pages of documentation (including useful code) so you can easily refer to it when in need.
  5. Simple explanations for complex concepts.
  6. High quality video and different delivery methods to keep things interesting.
  7. Lots of ideas to automate your current tasks.

Learn from Google or from this Course?
I've been there! I first learnt VBA from Google.
It was truly a light-bulb moment, when I realized that Google has some answers - it could give me some of the code I was looking for - but there two things missing:
  1. The WHY - why does the code work in one situation but not another.
  2. Structure - topic sequence, real-case examples, workbooks, documentation.
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.
"I have already tried some VBA classes but so far I was never able to apply what I learnt to my own work. This course is different. I have already used some of the techniques Leila is teaching and applied it to my work files. I was able to reduce manual work for me and my colleagues by creating my own macros from scratch. Highly recommended!!!" -- Randy Taylor
"Leila is the real deal... there are many VBA courses on Udemy (some of which I've taken) that merely demonstrate the functionalities. Leila explains the important foundation concepts and how the model is set up allowing you to truly create VBA code from thought rather than copying and pasting from various places. Her class is professionally constructed, with resources and content for each lecture, practice content for you to try things yourself and good Q&A opportunities to answer specific questions. Trust me, this is the course you want to take." -- Justin Fazzio

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
Who this course is for:
  • Business Professionals who'd like to simplify & automate work flow.
  • Data analysts.
  • You currently use Excel and like to improve your skills.

*Some courses are excluded from this sale. Coupon not working? If the link above doesn't drop prices, clear the cookies in your browser and then click this link here.
Also, you may need to apply the coupon code directly on the cart page to get the discount.

Coupon Code

Instructor Details

Leila Gharani

Leila Gharani is a Microsoft Excel MVP (Most Valuable Professional) dedicated to helping you create outstanding tools and reports in Excel. Her courses are for those who want to learn Excel, accelerate their careers and achieve more in less time.
Leila' background is Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert & Project Manager. For over 15 years she has worked in the Finance and IT departments implementing reporting systems based on Oracle and SAP. All the while using Excel VBA to automate and improve processes.
Since 5 years, Leila runs her own Excel site and has an active YouTube channel with many engaging, high quality videos. She provides customized Excel dashboard seminars, enhanced visualization techniques, and advanced Excel seminars to large corporations. She also teaches at the University of Applied Sciences in Upper Austria.
Her courses include examples based on her experience as well as the consulting work she has done for international companies. Many of the Excel tips and tricks she shares is based on the questions received from experienced professionals in her Excel training sessions.
She places great value on keeping her Excel courses not only informative but also engaging. For this reason, students will find enough challenges, exercises and downloadable files to practice so they can maximize the value gained from each course.
Leila's p



100 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Jason Raines on a month ago

Leila's course helped me go from zero understanding of VBA to developing sophisticated tools that impressed my boss and coworkers within a few weeks. She is very thorough and teaches to real world applications. I highly recommend this course to anyone looking to learn VBA. Its the best out there.

By Sze Wing on 2 months ago

The course is nice and covers a lot of topics. I hope there would be VBA scripts for each lesson listed in the pdf file for quick reference rather than open the Excel file every time I want to revise. Anyway the course is well-explained and useful. I think I need to watch it several times for better understanding.

By S.B. Carney on 2 months ago

It was Excellent right up to milestone project 2. The Pivot table part of the excerise i could never duplicate and got lost in the code. Everthing was just rushed over in my opinion

By HoMyung Lee on 2 months ago

The course may seem very long since she covers many subjects and tries to go into each as detailed as possible, but i think she did an amazing job considering how complex VBA is. I can definitely say that I now know what VBA is and have rudimentary VBA skill. I especially loved when she would take the time to repeat some of the small tips that are useful but the audience might have missed it the first time. Like she said at the end of the course, youll definitely have to revisit to the section of the course that you need for your own project for a recap. Lastly, the TAs response time to your questions is extremely fast (<24 hrs usually) and extremely helpful! I definitely recommend this course to those who are interested and getting into VBA.

By Santosh Seethanaboyina on 2 months ago

This course is designed fantastically as it helps one to build upon the basics and then connect to real life situations where one can use the leanings straight away. I will rate the course very high in terms of bringing in the practical scenarios where VBA is applicable. So, if you are looking for a quick launchpad into the world of VBA, this is going to be a perfect choice.

By Michael Orozco-Fletcher on 2 months ago

Leila does an amazing job of explaining the material, but sometimes you need to rewatch a video or two in order to ensure that the program works as Leila demonstrates.

By Hlder Filipe on a month ago

Now I know how a 5 star course should look like. I'm a long time subscriber of Leila Gharani channel on Youtube. I'm familiarized with her approach in teaching, that's why I've chosen this course to get started with Excel VBA, and I didn't get disappointed. Leila serves you this course with the finest contents and all the ingredients that you need to fulfill your needs. If you "eat this big gourmet meal", take your time to "digest" it and go back to review some complex tips, I'm sure you will succeed in this programming language. This course is very practical and you will get some fabulous resources to put in practice in your work. If you need a course to get started with Excel VBA, choose this one.

By Vinicius Ordobas Muniz on 2 months ago

Leila is a great teacher, her voice tone is easy to understand, and she goes back to previous concepts to make sure you know moving forward.

By Brian Sullivan on a month ago

This course is insanely useful and will allow any user to utilize vba completely in the office to a very advanced level. Thank you for teaching the course!

By Joseph harris on 3 weeks ago

Excellent course for becoming familiar with visual basic programming and/or macros! This course explores ways Excel can be used to create tools that increase efficiency and productivity when performing routine tasks, generating and presenting reports, or completing more unique projects. I would definitely recommend the "Unlock Excel VBA and Excel Macros" course!

By Mario R. Croes on 3 months ago

I enjoy it, will have to re watch some lectures again in order to understand VBA completely.

By Fleur Pepper on 6 months ago

Excellent Course, the resources increased my learning expectations. I am now far more confident to apply VBA and research its topics . In summary I have upskilled from a VBA learner to including the skill in my resume.