Excel 2010 Level 2

1 Day Course
Hands On
Code DEX10L2

This course has been retired. Please view currently available User Microsoft Office Training Courses.

Modules

Hide all

Calculating Data with Advanced Formulas (4 topics)

  • Apply Cell and Range Names
  • Calculate Data Across Worksheets
  • Use Specialized Functions
  • Analyze Data with Logical and Lookup Functions

Organizing Worksheet and Table Data (4 topics)

  • Create and Modify Tables
  • Format Tables
  • Sort or Filter Data
  • Use Functions to Calculate Data

Presenting Data Using Charts (3 topics)

  • Create a Chart
  • Modify Charts
  • Format Charts

Analyzing Data Using PivotTables, Slicers, and PivotCharts (3 topics)

  • Create a PivotTable Report
  • Filter Data Using Slicers
  • Analyze Data Using PivotCharts

Inserting Graphic Objects (4 topics)

  • Insert and Modify Pictures and ClipArt
  • Draw and Modify Shapes
  • Illustrate Workflow Using SmartArt Graphics
  • Layer and Group Graphic Objects

Customizing and Enhancing the Excel Environment (4 topics)

  • Customize the Excel Environment
  • Customize Workbooks
  • Manage Themes
  • Create and Use Templates

Prerequisites

You must have attended Excel 2010 Level 1 or have equivalent knowledge.

Course PDF

Print

Sections