Here is what you will learn during Excel 2010 Level 2

Module 1- Calculating Data with Advanced Formulas

Apply Cell and Range Names 

Calculate Data Across Worksheets 

Use Specialized Functions 

Analyze Data with Logical and Lookup Functions 

Module 2 -Organizing Worksheet and Table Data 

Create and Modify Tables 

Format Tables 

Sort or Filter Worksheet or Table Data 

Use Functions to Calculate Data in a Table or Worksheet 

Module 3 - Presenting Data Using Charts

Create a Chart 

Modify Charts 

Format Charts 

Module 4 - Analyzing Data Using PivotTables, Slicers, and PivotCharts

Create a PivotTable Report 

Filter Data Using Slicers 

Analyze Data Using PivotCharts 

Module 5 - Inserting Graphic Objects

Insert and Modify Pictures and ClipArt 

Draw and Modify Shapes 

Illustrate Workflow Using SmartArt Graphics 

Layer and Group Graphic Objects 

Module 6 - Customizing and Enhancing Workbooks and the Excel Environment 

Customize the Excel Environment 

Customize Workbooks 

Manage Themes 

Create and Use Templates