Online Excel VBA Training --- FREE!
VBATrain.com courseware comprises two courses: VBA Basics for Excel 2010 and the workshop-style Trip Planner Parallel Project. The latter course was developed using Excel 2000 and 2003. Nonetheless, the VBA code will work with Excel 2010 and will probably also work with Excel 2013 (although we have done little testing with Excel 2013). Enjoy!
VBA Basics for Excel 2010
This is the main course. After going through the course, you should end up with an understanding of how VBA works and the capability to design and write your own Excel VBA applications. There are lots of code examples. VBA Basics 2010
VBA Applied, Trip Planner Parallel Project
This workshop-style course walks you through tasks in a hypothetical Excel application-building project. Manipulation of both the Excel workbook user interface and the background VBA code is accomplished by the student. End result: a working Excel "front-end". At key lessons during the workshop, the student may download Excel workbooks that are complete up to that point in the project. This enables the student to start with a "clean slate" at those particular lessons. An Excel workbook that comprises the entire, finished project is available for download at the end of the project. Note: This course was developed for Excel 2000-2003. Parallel Project Trip Planner
Excel VBA Training and Consulting
for more information.