Unlock Excel VBA & Excel Macros – Leila Gharani
Let’s face it – much of what we do in Excel is a slog.
Yes, it’s fun to discover new Excel features.
Yes, it’s exciting to do trend analysis and spot an opportunity everyone else missed.
Yes, it’s rewarding to see your colleagues react to your beautiful new dashboard.
But that’s the sexy side of Excel. And unfortunately, most of your time isn’t spent on these tasks.
No, much of your work in Excel is slow, tedious, and boring.
Worst of all, it’s manual. You’re like a caveman, stacking rock upon rock using nothing but your blistered hands and gritted teeth.
Well, just like how the pulley automated the lifting of heavy objects, there’s an Excel tool to automate your manual work.
It’s called Excel VBA. You can start learning it today with this Excel VBA Macros Mastery Course!
Automate The Boring Stuff So You Can Spend More Time On What Excites You
Why not automate those borings Excel tasks so you can spend more time on what you enjoy?
Things like discovering new Excel features, analyzing data, and creating dashboards.
Imagine if you could free up three, five or even ten hour each week by automating manual tasks? How much more time would you have for these other, more exciting Excel tasks?
Not only does Excel VBA make your workday more enjoyable. Learning it also puts you in a position for better work and more pay.
Make Your Resume Stand Out
99% of people have “Proficient in Excel” written on their resume.
But how many have “Proficient in Excel VBA”?
Very few.
After taking our Excel VBA Macros Mastery course, you’ll have it on your resume. And best of all, you’ll be able to prove it.
Excel VBA is used by the largest and most successful companies across the globe. Here is a list of just a handful of companies that use it:
- 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.
Your Third Project: Create An Invoicing Tool
Here’s why I love this one…
You know how I’m all about applying Excel to solving real-world problems, right? Application matters more than theory.
Well, this project is based off an actual project I created during the time I was a freelancer. It’s a pretty sweet tool, I’ve got to say. Our clients loved how easy we made it for them to send invoices.
As a lead-up to creating this invoicing tool, you’ll learn these critical VBA skills:
- How to make applications talk to each other, like making Excel talk to Word or PowerPoint
- How to save specific sheets as PDF files
- Running events like opening a workbook, printing, or changing the color of a range of data
- How to add external links and comments
- How to create submission forms and add buttons, fields, and other ways to “dress up” your forms
With these skills, you’ll be fully prepared to create the invoicing tool. I dare say it’ll be fun, too.
Each project includes-step-by step directions so you’re never lost. Simply follow me and you can’t go wrong.
Also, each project comes with a code-free version of the file for download, so you can play around with the final product and see how it works.
You Can Finally Tweak Files You Find Online
These projects will teach you most of what you’ll ever need to know about Excel VBA.
Complete them, and you’ll be in the 1% of Excel users.
Still, there will no doubt be times where you’ll want to find an existing model instead of creating one from scratch. You’ll head to Google and search for what you need. And because Google has everything, you’ll find it.
But no model perfectly suits your needs out of the box.
That’s okay, because after you’ve taken this course, you’ll have the skills to tweak those models you find on Google.
Whether you create models from scratch or tweak models you get from others, after this course, you’ll be able to free up hours of your time using VBA.
Here’s Your Learning Journey
You can view the detailed curriculum below. Click on “See a full outline” button below to expand the lecture list.
See anything that jumps out? Which lesson do you think you’d begin with?
Section 1: Introduction & Scope
- Course Structure & Content
- Important Compatibility & Setup Information
- Course Resources: Download Course Project Files
- Course Expectations
- Course Outline for Quick Reference
- Quick Check-in
Section 2: Your First Excel Macro
- Overview: Macros & Visual Basic Editor (VBE)
- Steps to Your First Macro Recording
- Visual Basic Editor: What You Need to Know
- Project: Dynamic Selection (Special Cells) – Perfect for Flexible Macros
- Project: Copy (Consolidate) Data – Absolute versus Relative Macro Recording
- 7 Ways to Run Macros / VBA code (incl. creative & modern buttons)
- OFFICE 365 Update: Change from Comments to Notes
- Activity: Record a Macro that Deletes all Notes/Comments
- What’s the Difference Between Macros and VBA?
- Quiz: Test Your Knowledge on Macros
Section 3: The Object Model
- Overview: VBA Object Model (What you need to become an expert in VBA)
- VBA’s Code Reference Object Library
- VB Color Guidelines & Keyboard Shortcuts
- Excel VBA Object Model
- Object Properties
-
Object Methods
-
How to Find the Object, Property & Method
-
Conclusion: Key Takeaways & Message from Me
-
Test Your Knowledge about the Object Model
You’ll Also Get These Bonuses
In addition to the curriculum and downloadable files, templates and projects, you’ll also get these bonuses to help you tackle any VBA challenge you’ll come across:
Bonus 1: VBA Code Book
Inside you’ll find the code for all the projects we cover in one place.
That’s VBA code for over 50 real-case projects and 50 more examples on how to write proper code.
For example, let’s say you need to find the last row or next blank row. “What was the code for doing that?”, you ask yourself.
Jump to Section 4.3 and you’ll have your answer. Simply copy and paste the line to your VBA editor.
This bonus will be available 30 days after enrolling.
Bonus 2: Even More Downloadable Projects To Inspire You
You’ll get EVEN MORE real-world projects.
We recently added three more completed projects for you to learn from and be inspired by:
- Restrict editing & working with protected sheets
- Populate and consolidate Bill of Materials
- Web scraping project
These projects will be available 30 days after enrolling.
Beam Me Up, Scotty! Jump into the Topic You Need – Fast
I told you I was a Star Trek fan…
Watching the show, I was always in awe of the transporter technology. It blew my mind how they could spot a nearby planet, then instantly transport their team to that exact location.
I want your experience inside our Excel VBA Macros Mastery course to be just as instantaneous.
Thanks to a new tool we created here in our XelPlus “laboratory.” Now, when you want to find a topic, you can do so instantly. We’ve gone through every second of every lesson and pulled out the key words & topics.
Then, we created an interactive agenda which allows you to quickly locate exactly what you’re looking for. Once you find your topic, it’s simply a matter of saying “Beam me up!” (not actually required to say this).
Click the link and you’ll instantly be transported to the correct lesson and timestamp.
No more wasting hours searching. Find what you need, then get back to work.
Earn CPD Credits
I’m excited to announce this course is CPD certified. The Continuing Professional Development is a top global accreditation, trusted by companies and industries worldwide.
When you complete this course, you’ll get a special certificate with the official CPD stamp. You will earn 22.5 CPD hours with the course.
If CPD credits can help in your career, this is not a course to skip.
Reviews
There are no reviews yet.