ADVANCED MICROSOFT OFFICE SUITE: Manage Macro commands, create dialogue boxes, and understand the notions of Visual Basic application programming: use advanced functions (Names, VLOOKUP, IF, IS); work with PivotTables; manage Macro commands: concepts, planning, operations, execution, modification, interruption; use Visual Basic to create a public function or event procedures, or add general procedures in a form module; plan and examine an application, develop a distributed application design. Intermediate Microsoft Excel: Create, modify, and format charts, use graphic objects to enhance worksheets and charts, filter data and manage a filtered list, perform multiple-level sorting, use sorting options, and design considerations, use mathematical, logical, statistical, and financial functions, group and dissociate data and perform interactive analysis, create and modify some Macro commands.