Additional Material: Download Course Slides Link
Construction of an application
- Overview of user forms
- Overview of Workbook and Worksheet events
- Application of dynamically populated List items
- Use of form templates to dynamically manipulate form display contents at runtime
- Assigning macros to ribbon tabs (toolbars)
- Creation and maintenance of menus
Add-ins
- Creation of add-in workbook
- Application of ribbon tab to invoke and control an add-in
- Application of Excel options window to activate an add-in
Class modules
- Overview of class module versus program module
- Creation of property and method procedures
- Use and manipulation of class modules
Combining with external applications and files
- Use of data from other Excel files
- Use of data text files
- Use of data databases via ODBC connections
- Use of object hierarchies in other Microsoft Office applications
- Data storage in the Windows registry
- Use of external dynamic link libraries (DLL files)
Charts
- Creation of a chart as a sheet or as an object within a sheet
- Application of formats to different chart areas and items
- Maintenance of data labels and values
- Maintenance of key attributes
Pivot tables
-
- Creation of a pivot table and definition of its source data
Manipulation of column and row headings
Manipulation of cell values
Application of grouping and filtering
Application of formats to different sections of a table