Registration and Payment Deadline Extended - New Date January 23

# 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 FormulasTopic 1A: Apply Cell and Range NamesTopic 1B: Calculate Data Across WorksheetsTopic 1C: Use Specialized FunctionsTopic 1D: Analyze Data with Logical and Lookup FunctionsLesson 2: Organizing Worksheet and Table DataTopic 2A: Create and Modify TablesTopic 2B: Format TablesTopic 2C: Sort or Filter DataTopic 2D: Use Functions to Calculate DataLesson 3: Presenting Data Using ChartsTopic 3A: Create a ChartTopic 3B: Modify ChartsTopic 3C: Format ChartsLesson 4: Analyzing Data Using PivotTables, Slicers, and PivotChartsTopic 4A: Create a PivotTable ReportTopic 4B: Filter Data Using SlicersTopic 4C: Analyze Data Using PivotChartsLesson 5: Inserting Graphic ObjectsTopic 5A: Insert and Modify Pictures and ClipArtTopic 5B: Draw and Modify ShapesTopic 5C: Illustrate Workflow Using SmartArt GraphicsTopic 5D: Layer and Group Graphic ObjectsLesson 6: Customizing and Enhancing the Excel EnvironmentTopic 6A: Customize the Excel EnvironmentTopic 6B: Customize WorkbooksTopic 6C: Manage ThemesTopic 6D: Create and Use Templates