We have felt the power of a data table, but perhaps this new capability poses as many questions as it answers.  Would it be possible to do a 3-criteria analysis, for example?  A data table permits only two, of course.  So, what are the options?

Excel VBA opens up a new world of possibilities!  The good news is that any analysis you can conceptualise in your own head is possible with VBA; the bad news is that it takes a lot of time to learn, and it can be infuriating.  Be prepared for a rollercoaster ride!

In this course, we take a practical approach to learning Excel VBA.  After some preparation for using code such as making the developer tab visible, we jump straight into the deep end in this video!

We use the macro recorder facility to record some code, then we review it in the VBA editor.  Then, we tweak the code, attach it to a button, and run it from the spreadsheet.  There, you go - an organically coded macro, you're now a computer programmer!

Topics And Techniques:

- Getting ready for Excel VBA
- Recording code with the Macro recorder
- Creating your own macro in the VBA editor
- Creating a button and assigning a macro