ADVANCE 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 Pivot Tables; 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 OFFICE SUITE: Create mail merges, sort and filter them; customize toolbars; run and record Macros; filter data and manage a filtered list; create and modify some Macro commands; create, modify, and format charts; create basic Macros to automate forms and data entry; customize the appearance and functionality of reports; use hyperlinks and perform data integration.