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. Advance Microsoft Excel: Customize the work area, use advanced functions (Names, VLOOKUP, IF, IS), work with Pivot Tables, transform data with PowerQuery, use PowerPivot, use spreadsheet Web components, manage Macro commands: concepts, planning, operations, execution, modification, interruption, use personalized toolbars, perform some programming in VBA and/or DAX.