Intermediate
Microsoft Excel 2010

Course Content

• Lesson 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
• Lesson 2: Organizing Worksheet and Table Data
  • Create and Modify Tables
  • Format Tables
  • Sort or Filter Data
  • Use Functions to Calculate Data
• Lesson 3: Presenting Data Using Charts
  • Create a Chart
  • Modify Charts
  • Format Charts
• Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts
  • Create a PivotTable Report
  • Filter Data Using Slicers
  • Analyze Data Using PivotCharts
• Lesson 5: Inserting Graphic Objects
  • Insert and Modify Pictures and ClipArt
  • Draw and Modify Shapes
  • Illustrate Workflow Using SmartArt Graphics
  • Layer and Group Graphic Objects
• Lesson 6: Customizing and Enhancing the Excel Environment
  • Customize the Excel Environment
  • Customize Workbooks
  • Manage Themes
  • Create and Use Templates

---

All Excel Courses

Excel 2010 Classes	Excel 2007 Classes	Excel 2003 Classes
What's New in Excel 2010 > Introduction > Intermediate > Advanced >	What's New in Excel 2007 > Introduction > Intermediate > Advanced > Expert >	Introduction > Intermediate > Advanced >
		About Excel >

---