Automate Complex Tasks with Microsoft Excel VBA & Excel Macros (Real-World Projects included). Achieve More. Save time.
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:
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.
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.
Create 3 Complete Excel VBA Tools. We go from idea to final product and cover each step.
Over 100 pages of documentation (including useful code) so you can easily refer to it when in need.
Simple explanations for complex concepts.
High quality video and different delivery methods to keep things interesting.
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:
The WHY - why does the code work in one situation but not another.
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
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.
5 Lectures
9 Lectures
8 Lectures
10 Lectures
7 Lectures
10 Lectures
8 Lectures
9 Lectures
7 Lectures
12 Lectures
9 Lectures
9 Lectures
7 Lectures
11 Lectures
6 Lectures
8 Lectures
11 Lectures
11 Lectures
8 Lectures
5 Lectures
Leila Gharani is a Microsoft MVP (Most Valuable Professional) dedicated to helping you create outstanding tools and reports in Excel & Google Sheets. Her courses are for those who want to shine at work, 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...
Very well. by KABEYA MUNYAMA MODESTE LE GRAND
I appreciate the described structure and I'm looking forward to learning the Excel skillset based on that.
This course was really good up to about the halfway point. But when we went through creating the regional sales tool, there were some things that made it difficult to follow along. The pivot tables used in the tool you create were not provided and there were no steps to create them. You could get them from the finished file provided at the end of the section, but it is disruptive to realize that and read the Q&A to find that solution. Also, there is VBA code that is just pasted in by the instructor, and you need to manually type it in. At times the code was obscured in the video which made it difficult to even type it. This is a course focusing on VBA so I would think all the VBA code used would be entered step-by-step by the instructor.
So this course is very valuable for learning VBA, but it did leave me a bit disappointed after the halfway point.
Well orgranized course! Covers most basic and useful functions
This is very good platform to enhance skill
Clear and precise instruction
very good, I am learning a lot throw practice material given by the course which personaly works great for me
Learned a lot but Excel is pretty powerful and often not straight forward about using variables, using parenthes, using option words such as Sub,.. I liked the excample of the invoices and I took a lot of ideas which helped me to develop the first tool. However, still have to get familiar about basic concepts of procedure, function, call by value, call by reference as I'm more coming from a programmin language level.
Have to stay motivated and continue learning which is not that easy as there are also often so many different ways to get to the final goal
too complex
Your email address will not be published. Required fields are marked *
Sai A. S.
Nice explanation