Part IV. Data analysis

Programmers write games, online ordering systems, cell phone apps, satellite control software. You name it.

Most business programmers work for companies that aren’t in the software business. Banks, airlines, city governments, medical facilities, universities. These types of organizations buy almost all of their software. So what do those programmers do?

Often they work on data analytics. Taking data from a sales system, and formatting it for analysis in Excel. Grabbing data from a Web site, selecting just the data the company is interested in, and summarizing it for management. These are fairly small, data-intensive programs. Just what Excel VBA is good at.

This part of the course is about those programs.