The Visual Basic for Applications ﴾VBA﴿ programming language allows you to automate routine tasks in Excel—and it's not as hard to learn as most people think. In this course, Excel expert offers a crash course on VBA, sharing techniques that can help users of Excel 2007 or later get more out of this powerful program. In this course Excel expert covers creating subroutines and functions to hold code, and provides a solid grounding in the Excel object model. Programming techniques are demonstrated through real‐world examples. Exercise files accompany the course.

Topics covered |duration : 4+ hrs Video Course

01 Visual Basic for Applications
02 Defining Variables, Constants, and Calculations
03 Adding Logic to Your VBA Code
04 Debugging Your VBA Code
05 Managing Workbook Elements and Data in VBA
06 Adding Advanced Elements to Your Workbook
07 Using Excel Events in Your VBA Code
08 Putting It All Together