Topics Covered:

Calculating with Advanced Formulas , Manage Cell and Range Names , Calculate Data Across Worksheets , Use Specialized Functions , Analyze Data with Logical and Lookup Functions , Organizing Worksheet and Table Data , Create and Modify Tables , Format Tables , Sort or Filter Worksheet or Table Data , Calculate Data in a Table or Worksheet , Presenting Data Using Charts , Create a Chart , Modify Charts , Format Charts , Analyzing Data Using PivotTables and PivotCharts , Create a PivotTable Report , Analyze Data Using PivotCharts , Inserting Graphic Objects , Insert and Modify Pictures and ClipArt , Draw and Modify Shapes , Illustrate Workflow Using SmartArt Graphics , Layer and Group Graphics Objects , Customizing the Excel Environment , Customize Workbooks , Manage Themes , Create and Use Templates

Registration Period: July 30, 2012 - August 16, 2012