Leila Gharani – Unlock Excel VBA & Excel Macros

• Amazon
• Cigna
• Deloitte
• Intel
• JP Morgan Chase
• Microsoft (of course)
• Morgan Stanley
• PayPal
• Tesla
• US Bank

Want to work for one of these companies one day? You’ll boost your chances if you know Excel VBA.

Excel VBA is used across numerous industries, too. Banking, finance, agriculture, healthcare, construction, hospitality – I could go on and on. It’s everywhere.

If you’re looking to stand out and not be just another Excel user, Excel VBA is how you get your resume to the top of the stack.

I Wanted this Course to Be Different

No, my course isn’t the only VBA course out there.

I know you have other options to learn this topic.

You could learn from another Excel expert, you could buy a course on Udemy, and you could even watch YouTube videos, piecing things together.

So, I asked myself, “How can I offer something different and better than all the other options?”

That’s when it hit me.

Through my research, I found all the other VBA training and courses have one thing in common: They only give you one piece at a time. They don’t give you the entire puzzle. They also don’t give you ready-made code books for quick fixes. Or real-world projects to learn from.

At that moment, I knew how to structure our VBA course.

Learn VBA By Building Projects and See How Each Piece Contributes To The Puzzle

A VBA project is like a completed puzzle.

Problem is, other trainings only give you a handful of pieces – and from all different puzzles!

They give you three pieces from the hot air balloon puzzle. Then, they toss you two pieces for the basket of fruit. And finally, a corner piece for the mountain lake.

How the heck are you ever supposed to build a finished project this way!?

It’s a confusing way to teach VBA, in my opinion.

Instead, in our Excel VBA Macros Mastery course, you’ll build three separate projects. Each project was specifically chosen to teach you different, important features of Excel VBA.

Finally – and this is the magic – you only complete projects using techniques you’ve already learned.

In other words, we teach you the pieces of the puzzle, and then put them together into a finished project.

It’s a layered, step-by-step approach that will teach you Excel VBA faster than anything else.

Watch The Video For A Quick Overview Of The Course

Your First Project: Automated Table Of Contents

As I mentioned, there are three main projects you’ll complete.

In this first project, you’ll create a tool to automate a table of contents inside Excel. You’ll complete the project using skills you’ll learn in that section’s lessons, such as:

• Getting familiar with the Visual Basic Editor
• Creating macros and 7 different ways to run them
• Understanding the difference between macros and VBA
• The most useful built-in VBA functions
• Debugging so you can quickly find & fix errors

After learning these techniques, plus more, you’ll tackle the table of contents project. Not only will you have a finished, working file. You’ll have all the skills you learned along the way.

Your Second Project: Create A Sales Reporting Tool

Using what you’ve already learned, your next mission will be to create a regional sales reporting tool.

But your existing skills won’t be enough for this (slightly) more difficult project. That’s why, before entering the project area, you’ll enter the classroom.

You’ll first learn these necessary techniques:

• Loops! These little guys will become your best friends because they’ll automate so much for you
• Arrays, which allow you to quickly run procedures
• How to create Excel tables using VBA
• Telling Excel to open folders and files, using VBA
• How PivotTables work with VBA

Once you’ve completed these lessons, you’ll download the project workbook and create your sales reporting tool. You’ll be surprised at how easy it is after watching the previous lessons.

Finally, you’ll move on to tackle the third project.

Armed with these foundational skills, you’ll be ready for your second project.