|Survey: subroutines and macros
Practice session: writing simple macros
Survey: input and output
Practice session: using the MacroMorsels
Survey: testing and debugging
Practice session: testing and debugging
Survey: the power of macros
Practice session: writing more complex macros
This course will emphasize the most error-prone aspects of such writing, which involves data output and, even more, data input. A set of MacroMorsels will be provided to illustrate many of these points. Students will also learn how to test and debug their routines, and how to incorporate existing data processing routines, such as those of the Numerical Recipes by Press et al., into their Excel functions and macros.
This is a hands-on course, with most of the time devoted to practical exercises. Students should bring their own laptop computers, and all pre-registered students will be informed by the instructor well ahead of the course what Microsoft and additional free software tools to load. Students will get pdf copies of the PowerPoint slides used, and therefore will be able to concentrate on the practical exercises rather than on taking notes.