Analytics in Excel VBA

Catalog description

This course introduces the construction and use of data analysis tools that are commonly used for business analysis. The course builds on the spreadsheet and analytical skills developed in OIDD1010, providing a much more extensive treatment of spreadsheet application development (using Excel Visual Basic for Applications). In addition, we will cover best practices in programming and analytics generally which can carry over to other tools and languages. Time permitting, we will do an introduction to some advanced analytical methods that show up in complex data analysis tasks and provide a foundation for further study. In prior years, this course was a 1 cu offering combining the content described here with the content of what is now OIDD3150: Databases for Analytics (0.5 cu). Students seeking this experience can take this course along with OIDD3150 either sequentially or concurrently.