MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.67 GB | Duration: 4h 59m
What you’ll learn
Automate your work with Excel VBA and save time
Complete real world VBA projects from beginning to end
Create 10+ VBA tools that you can use in your daily life
Learn real VBA examples that I’ve used as a CPA accountant and freelance programmer over the past seven years
Learn the fundamentals of VBA coding in Excel, creating well written and efficient VBA code
Learn how VBA can be used to interact with Excel, internet browsers, emailing, PDF form filling and more
Familiarity with Microsoft Excel.
Demonstration is done with Excel 2016 but the techniques work with any version of Excel.
Excel on Windows (many techniques will work on mac, but I will not be able to support you).
Go from Beginner to Microsoft Excel VBA Expert!
I’ll take you step-by-step through engaging videos starting with a VBA tutorial. You’ll learn all of the VBA fundamentals that you need to become a VBA expert. Afterwards, you’ll be taught actual code I’ve used over the past seven years as a CPA accountant and freelance programmer with hundreds of clients. You will be taught line-by-line, as we build 10+ VBA tools together that you can use in your daily life.
Every coding related section includes a video walkthrough. And, every line of code in the course includes comments, so you’re not left guessing what each line of code does.
Why this course?
Learn from a CPA and freelance programmer. By showing real world examples, you’re more likely to use the knowledge in your daily life.
Create 10+ Excel VBA tools. I’ll walk you through how to write VBA tools ranging from dynamic Excel templates, sending emails with attachments, automating a web browser, filling in PDF forms and more.
Learn proper VBA syntax. You’ll learn the fundamentals of VBA, creating well written & efficient code. This is much more than just recording macros.
High quality videos. Every coding related section includes a video walkthrough.
Documentation. Every line of code includes a comment about what the code does. You’re not left guessing.
Wide range of topics. This course goes beyond just using VBA with Excel. You’ll learn how VBA can be used for web browser automation, sending emails, PDF form filling and more.
What you’ll learn
Please see a few examples of what you’ll learn in the course video.
Who this course is for:
Any Excel users looking to increase their VBA coding abilities, while learning real-world examples that you will use day-in-and-day-out.
Even if you are a beginner, there is a fundamentals section to teach VBA basics.
Business professionals who’d like to simplify & automate their work flow.