Learn Microsoft Excel VBA Fundamentals (Excel 2010, 2013, 2016)
Microsoft Excel VBA (Visual Basic for Applications) provides Excel users with the ability to automate any Excel task. Excel Tasks that would normally take an extensive amount of work and time to complete can ultimately be automated and completed in a single click of a button. All that's needed to automate your experience is a little Excel VBA knowledge.
Maybe you've heard of Excel Macros and VBA. Or, maybe you've even attempted to create your own. Jumping into VBA can be a bit daunting and overwhelming. I've been teaching Excel for 15+ years and have had loads of questions from those that have taken the dive into learning Excel VBA. Where should I start? What do I need to know? What's a variable? Enroll in this course and I'll share the knowledge and experience I've gained working with Excel VBA.
WHAT YOU'LL LEARN
Fundamentals of Excel VBA
Proper Syntax Writing VBA Code
Excel Object Structure to Effectively Communicate with Excel
Working with the Most Common VBA Objects in Excel
Automate Routine Microsoft Excel Tasks
And More....
EXERCISE FILES AND QA
As you go through the video lectures you can download the exercise files, found within each section. Use the exercise files to practice the concepts you will be learning.
The course contains a QA section where you can interact with me and ask any questions as you develop your VBA skills.
ENROLL NOW
As you participate in this introductory Excel VBA course you will build the knowledge and confidence to automate your experience in Excel, saving you time and money.
Fundamental Building Blocks of Using Excel VBA to Automate Routine Tasks
How to Implement Excel VBA into an Excel Workbook
Become Familiar with Common Excel VBA Programming Syntax
2 Lectures
8 Lectures
8 Lectures
6 Lectures
5 Lectures
8 Lectures
7 Lectures
5 Lectures
4 Lectures
1 Lectures
Welcome! I'm Kyle Pew, a Microsoft Certified Trainer (MCT), Microsoft Office Master Instructor, and Udemy Instructor Partner, with over 20 years of experience training over 1.8 million students in Microsoft Office and beyond. I’m passionate about helping students of all backgrounds and skill levels succeed in using tools like Excel, Word, PowerPoint, Access, and more, as well as diving into...
so far I am enjoying it. Easy to listen to and understand. I like the instructor. Nice voice and explains things well.
i got , what is required from the course, however i observe if he can deliver the content little more faster, by cutting short some unnecessary stuff in the videos that will be help full for the student, to learn and complete the course early.
It was definitely useful to my current and future roles.
Not enough real life examples in this course. I want to know and learn about how to collect data from different files and make a summary report. Do some calculations and technical analysis
Already, I like this course very much! It breaksdown down the VBA language to its most basic components. Previously, I had to cancel another VBA course because it used language that left me on the lurch, wondering how much I was missing. This saved my interest in VBA. Thank you.
Thank you for this course!
The instructor did a great job of breaking the content down into easy to follow steps. I followed along on an Excel file and took some notes. It was right on my level
It is an introduction, very well paced and detailed enough for beginners, but if you know a little about programming like ifs and loops, you probably want a more advanced course.
This is an excellent beginning course on VBA. If you are studying VBA, it is assumed that you have some basic skills in Excel, including inputting data, formatting it, and even writing some very basic formulas such as IF statements. However, you don't need to be an advanced user to take this course. As VBA is a form of programming, you will also get a very basic introduction to thinking like a programmer.
This is an introductory course though, and the instructor goes at a slower pace assuming no knowledge of VBA, which is perfect for beginners since it teaches you how to think about your cord and not just write it. If you have the basics of VBA, you will probably want to look at a more advanced course.
Your email address will not be published. Required fields are marked *
Yusuf R.
Even though the course is 7 years old, it is still relevant and useful. It is a great introduction to excel VBA.