Course Information
Course Overview
Automate mundane tasks with Microsoft Excel VBA & Excel Macros and become your company's hero!
By the end of this course, you will go from knowing nothing about VBA Macros to knowing how to do the most common functions...all within 3.5 hours!
Any version of Excel is supported.
Excel VBA Macros are one of the most powerful features in Excel. Why? Because Macros can help you automate almost any routine task, saving you hours and hours of time.
During this course, we start with the very foundations of VBA Macros and slowly build your quiver of knowledge. We only teach you the most important functions, functions that can help you accomplish almost any task in VBA.
Our instructors have years of experience working with leading companies (like Puma) and universities (like Harvard) to help them automate their spreadsheets. We've also taught hundreds of professionals around the U.S. these amazing skills. After all of this, we know what you need to know to get started.
Absolutely ZERO background in VBA or programming is necessary!
Some key things you’ll learn:
Learn the structure of VBA code and best practices
Create sub routines to segment your code
Declare and call variables
Create For /Next loops
Create If/Then and If/Then/Else logical tests
What makes our course so awesome?
Real world application: In depth, real-world case studies
Fun: Light-hearted, fun, and enjoyable course (we never take ourselves too seriously)
Knowledgeable instructor: Nate has spent his entire career mastering Excel, consulting companies in Excel, and teaching Excel.
No fluff: We don’t teach theory or waste your time with useless information. Everything we teach you can start applying TODAY
Let's start learning!
Course Content
- 8 section(s)
- 42 lecture(s)
- Section 1 Welcome
- Section 2 Intro to VBA Coding
- Section 3 VBA Code Basics
- Section 4 Named Ranges & If Statements
- Section 5 For/Next Loops & Making Our Code Dynamic
- Section 6 Recording and Manipulating a Macro
- Section 7 Real-World Case Study
- Section 8 Conclusion
What You’ll Learn
- Master Excel VBA & Macros
- Make your work-life WAY easier
- Automate routine tasks within Excel
- Write custom VBA code to automate your Excel tasks
- VBA programming concepts to create dynamic, re-usable code
- Coding best practices
- Complete real world Macro/VBA projects from beginning to end
Skills covered in this course
Reviews
-
DDawn Applin
Always a very thorough explanation. Even when I broke the codes I could replay a couple of steps and figure out what went wrong.
-
SSanchayeta Bhattacharya
Yes it was!!
-
AAna Romero
Very engaging course with simple but well-designed exercises and amazing explanations.
-
BBernadeth Ocdamia
nice