Excel 2010 VBA: Expert

In this course, you’ll learn how to develop macros for Microsoft Excel 2010 using the Visual Basic for Application (VBA) editor. To begin, you’ll learn about the Excel 2010 Object Model and gain a deeper understanding of how Excel is organized and its hierarchy so that you can be a better programmer. You’ll also explore VBA editor and the various tools and menu options available to you. Then, you’ll develop an understanding of programming basics, including how to declare a variable and how to start writing code within VBA. Programming control structures, such as loops which are used to make programs more robust, are also discussed. Finally, you’ll learn how to create User Forms and debug your macros properly.
This course features step-by-step instructions and engaging visuals to help you advanced your macro skills.