In this lecture, I discuss two ways of introducing more programming concepts in Excel.
The first involves directly programming in Visual Basic for Applications (VBA), the scripting language included with Excel.
The second uses the XLWings module to integrate Python with Excel, thus extending Python’s functionality to Excel.
VBA is discussed in the first video and XLWings is discussed in the second.
Extra handouts about the syntax for using both VBA and XLWings are included below as well.
