Excel VBA Macros: Save Hours and Automate Excel (All Levels)

$0.99
Instructor:
Rami Abou Jaoude
Category:

I’m not just an Excel fan—I’ve used it to build analytics departments, automate reports, and lead strategy at the VP level . I hold a Harvard MBA , a degree in Computational Sciences , and spent over a decade managing teams in a global bank. I was also a McKinsey consultant , trained to solve complex problems under pressure. I’ve worked in AI, built chatbots, and automated full workflows—but I still believe Excel is the fastest path to real-world productivity . And nothing unlocks that faster than VBA.

 

What you’ll learn
  • Automate your tasks in Excel and focus your time on more productive activities
  • Wow your stakeholders, eg, Dynamic Charts and AI analyzing your report
  • Make your team work fast and better with efficient VBA tools
  • As you can’t memorize everything, learn how to search, modify and use the right piece of code
  • Loose the fear of using VBA
Course content
23

23 sections • 175 lectures • Total duration 19 h 42 min

Introduction
My First Macro (*)
Referencing and Copy Paste (**)
Data Object Model (*)
Menus & Toolbar Walkthrough (*)
Variables & Formulas (**)
Macro Recording (***)
Looping through Objects, Conditional & Logical Operators (***)
Interacting with Users (***)
Looping (***)
Improving your code & Error Handling (***)
Text Manipulation (**)
Date Manipulation (***)
Create your own Excel function (***)
Arrays (***)
Files and Folders (*****)
How to deal with Excel Tables & Pivot Tables (*****)
Interacting with Other Applications (*****)
Sheet Controls (****)
Userforms (****)
Charts (****)
Workbook and worksheet events (****)
Quiz