# Excel 2010: Intermediate

 Audience This course is designed for individuals interested in learning the skills necessary to calculate data using functions and formulas, sort and filter data, use Pivot Tables and PivotCharts for analyzing data, and customizing workbooks in Microsoft Office Excel 2010. Description Upon successful completion of this course, individuals will be able to:Use advanced formulas.Organize worksheet and table data using various techniques.Create and modify charts.Analyze data using Pivot Tables, Slicers and PivotCharts.Insert and modify graphic objects in a worksheet.Customize and enhance workbooks and the Microsoft Office Excel 2010 environment. Prerequisites To ensure your success, we recomend you first take the following courses or have equivalent knowledge:Microsoft Office Windows ExperienceMicrosoft Office Excel 2010: Beginning Suggested Class Size Minimum 3Maximum 12 Course Length Full day Content Lesson 1: Calculating Data with Advanced Formulas    Topic 1A: Apply Cell and Range Names    Topic 1B: Calculate Data Across Worksheets    Topic 1C: Use Specialized Functions    Topic 1D: Analyze Data with Logical and Lookup FunctionsLesson 2: Organizing Worksheet and Table Data    Topic 2A: Create and Modify Tables    Topic 2B: Format Tables    Topic 2C: Sort or Filter Data    Topic 2D: Use Functions to Calculate DataLesson 3: Presenting Data Using Charts    Topic 3A: Create a Chart    Topic 3B: Modify Charts    Topic 3C: Format ChartsLesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts    Topic 4A: Create a PivotTable Report    Topic 4B: Filter Data Using Slicers    Topic 4C: Analyze Data Using PivotChartsLesson 5: Inserting Graphic Objects    Topic 5A: Insert and Modify Pictures and ClipArt    Topic 5B: Draw and Modify Shapes    Topic 5C: Illustrate Workflow Using SmartArt Graphics    Topic 5D: Layer and Group Graphic ObjectsLesson 6: Customizing and Enhancing the Excel Environment    Topic 6A: Customize the Excel Environment    Topic 6B: Customize Workbooks    Topic 6C: Manage Themes    Topic 6D: Create and Use Templates